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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.

Labels (5)
1 Reply
Anonymous
Not applicable

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

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