Make multiply REST calls (one per month)

Hi all,


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 :-)


Please sign in to leave a comment.