I am selecting accounting data from a 3rd party REST API. However they only return 50 rows per call. If I want to select an entire year that will not work. But I know that I dont have more than 50 data sets per month.
By this I would like to send one query per Month. For this I have created a static data source from a excel sheet with two columns in the following format:
In the REST call I can limit the min_date and max_date through the Body parameters date_from and data_to
They must be in the format: "YYYY-MM-DD".
How can I use this table to run for each line of the excel the query? Thanks in advance :-)