topic Re: Extracting Data from an API to an excel in Talend Studio

Extracting Data from an API to an excel

Anonymous — Tue, 09 Apr 2019 09:48:46 GMT

Hi,

I'm new to Talend and I'm trying to extract some information from an API to an excel. I have tried trestclient component but what I get is an excel with one line of information. It would be great If someone can guide me through how to set up the process where I can extract the information through an API to an excel in table format

Re: Extracting Data from an API to an excel

manodwhb — Tue, 09 Apr 2019 10:10:25 GMT

@Bhadraka ,please check the below links.

https://community.talend.com/t5/Design-and-Development/how-to-read-data-from-rest-client-API-in-json-and-how-to-load/td-p/125582

https://community.talend.com/t5/Design-and-Development/Getting-Started-with-tRest-and-API-s/td-p/43325

Re: Extracting Data from an API to an excel

Anonymous — Wed, 10 Apr 2019 13:00:12 GMT

These links doesn't cater my need

Re: Extracting Data from an API to an excel

akumar2301 — Wed, 10 Apr 2019 13:06:47 GMT

@Bhadraka

Can you please give more detail on your job design ? If you have sample of output of rest API ,it will help more.

normally you need to parse output of rest using XML/JSON components.

Re: Extracting Data from an API to an excel

Anonymous — Thu, 11 Apr 2019 07:21:35 GMT

Figure 1 is my tRestClient configuration where I have defined my API information and I have passed the headers in the Advanced settings

The result I get will be in Figure 2 where although I have defined it as Json Accept type it will give an XML output

I have tried textractJSONFileds component and tXMLMap components as well but I couldn't figure out a proper way. All my data will be stored in a string field and body will be null when I connect with tXMLMap component.

Can you please guide me on this...

Figure 1.PNG
Figure 2.PNG

Re: Extracting Data from an API to an excel

akumar2301 — Thu, 11 Apr 2019 07:48:17 GMT

Try to follow senario one for trestclinet, let us know if it helped.
https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/~V42EBQClKxKQghNvzHF1g

Otherwise attach a sample response of api.

Re: Extracting Data from an API to an excel

Anonymous — Thu, 11 Apr 2019 08:05:01 GMT

I actually tried this, I have attached my output and also I have attached a sample of my API response as well

API Response.txt
Figure 3.PNG
Figure 4.PNG