Get Data from API to mysql Database

DY94 — Fri, 15 Nov 2024 23:09:57 GMT

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.

Re: Get Data from API to mysql Database

Anonymous — Wed, 02 Mar 2022 12:18:47 GMT

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

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

topic Get Data from API to mysql Database in Talend Data Catalog

Get Data from API to mysql Database

Re: Get Data from API to mysql Database