Using one API to get values from another API

[qmestu]

Hi,

I have an API which, given a parameter, give me a start and end date, in years.

first_date	2015
last_date	2023

I have a second API, in which i must feed the years that the first API returns, and the years between those years, plus another parameter:

date	parameter
2015	A
2016	A
2017	A
2018	A
2019	A
2020	A
2021	A
2022	A
2023	A

For now i'm only using the second API, as i can't automate the creation of the first column in this second table. I believe this can be done with some sort of function, but i've been unable to do so.

Any help on this would be greatly appreciated.

Thanks.