hi

modara — Fri, 15 Nov 2024 21:44:00 GMT

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

Re: hi

modara — Sat, 03 Jun 2023 12:40:09 GMT

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

topic Re: hi in Talend Studio

hi

Re: hi