Extracting Data from an API to an excel

[Anonymous]

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

[manodwhb]

@Bhadraka ,please check the below links.

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

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

[Anonymous]

These links doesn't cater my need

[akumar2301]

@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.

[Anonymous]

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

[akumar2301 · Accepted solution]

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.

[Anonymous]

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