Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
DY94
Contributor II
Contributor II

Get Data from API to mysql Database

Hello,

 

I'm trying to get the information returned by an API to send them to a MySQL database.

the API in question limits the quantity of results obtained with a pagination system by returning for example 1500 results per page.

 

Also, the results are not always identical , some information is missing.

In some results and therefore not displayed in the response sent by the API.

 

I am looking to create a job that would allow me to retrieve all the results despite the pagination system, analyze each result obtained to assign the right values in the right columns to send all the information to my database .

 

Thank you.

1 Reply
Anonymous
Not applicable

I have written a piece on API pagination here....

https://community.talend.com/s/feed/0D75b0000053nJICAY