Question
Citiustech
IN
Last activity: 30 Aug 2023 10:01 EDT
Get external data into a table column.
Hi,
I have a requirment to get list of all countries into a country column in countries data table, can anyone help me with this please.
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
NCS Pte. Ltd
SG
Hi @SuryavamsiR: Your query is too generic. If you are fetching data from a external system and need to load it into local storage, you can define a data flow. If this is not the requirement, please help us to understand the requirement in detail.
Thanks.
Citiustech
IN
Hi @ArulDevan, Like I mentioned above i have a data a data type and it contains a country data object, let's say they is list of countries in a website and i want to pull that list into this particular data object.
Thanks/
NCS Pte. Ltd
SG
Hi @SuryavamsiR: When you say there is list of country in a website, is that the provider to you? Do you have any API integration with the provider to fetch the list of country?
Thanks.
Citiustech
IN
@ArulDevan,if you search list of countries in google you find a website in that site there will be an End point URL in the page right we can use it while creating a new data object we pass that URL to get the data, But when i do that it is creating a table and each country name is becoming a data model I want to pull that data into and the table contains student name, roll number etc... columns right we will store all students names inside the student coulmn like that i want to put all the country names inside the country column).
Thank you.
NCS Pte. Ltd
SG
Hi @SuryavamsiR: Are you using the Web browser URL to get the data? If so, it won't work. You need to have a service provider which gives you the data via API. Were you able to invoke the API in tools like postman to see the response?
Thanks.
Citiustech
IN
@ArulDevan Hi, I am a fresher and pega is new to me so i don't know much about postman tool, can you give me an info on that.
NCS Pte. Ltd
SG
Hi @SuryavamsiR: Postman is a client application which you can setup in your system. It helps to test your API outside PEGA.
Again, if you are referring the browser URL as the end point URL of the service, it wont work. Please share us some screenshots on what you are trying to better evaluate.
Thanks.