Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
songong_0103
Contributor
Contributor

How to request an open API from Talend, receive a response as json data, and load it into a database table

songong_0103_0-1740536822006.pngsongong_0103_1-1740537017629.png

I am working on receiving json data using the public data API key I have, extracting the data, and loading it into a table.
I entered the API information I had correctly. 
I would like to ask a question because an error keeps occurring.
I would like to know if it is a workflow problem.
I checked the issue with the API authentication key and found no problem.
And I would like to know what problem is causing the API data request not to be received.
Also, since I am not sure that the workflow I created is the correct method, I would like to know in detail the appropriate way to receive json data through the API and load it into the table, along with how to set up the component.

 

Labels (3)
1 Reply
quentin-vigne
Partner - Creator II
Partner - Creator II

Hi @songong_0103 

Can you try using tRest component instead of tRestClient ?

Could you also share more information on your component setup with screenshots ?

 

- Quentin