hi

[modara]

Hi,

I am lasly taked API data to mysql. In my API got year from 2005 to 2023

but i cant take data from 2005 to 2023, I have to do filter one by one i.e.

https://calendarific.com/api/v2/holidays?api_key=sdfddsafsfd&country=BD&year=2005

https://calendarific.com/api/v2/holidays?api_key=sdfddsafsfd&country=BD&year=2006

https://calendarific.com/api/v2/holidays?api_key=sdfddsafsfd&country=BD&year=2007 and so on....

I have created a ID_AUTO_Gen_id in mysql

 

 

and when i give that ID_AUTO_Gen it gives me Null in return in mysql but ID_AUTO_Gen is working

 

if remove ID_AUTO_Gen , then i got only that specific year data that i put in api.

i want to store data into mysql from 2005 till 2023

please give me guide how could i do that.

these is no way in API to get data as of today, they mentioned it. So if there is a way out to store data from 2005 till 2023 in talend please guild me

thanks

[modara · Accepted solution]

thanks i resolved every thing. i can get data from api to mysql and store is year after year.