I am trying to pull JSON data from an API, with pagination rules in the query params. Relative URL is like this: /api/v1/sites?range={start}-{stop} I can pull 100 records at a time, so I would have to do: /api/v1/sites?range=0-99 /api/v1/sites?range=100-199 /api/v1/sites?range=200-299 etc. I thought I would use two query parameters, start and stop, starting at 0 and 99 respectively and incrementing by 100 for each request. I have set up something similar before, but don't quite understand why this is failing now. Any help would be appreciated 😊 This is my setup, error message and source code:

I need to put some data into my data warehouse, but using Web API in data flow is not possible since I need to do an authentication request with a JSON body to get a JWT token to do requests, but Web API won't allow me to do a request with a body. So Get Data -> Web API is obviously not usable. What usable methods are there? I have been able to call the API and fetch data in a Power Automate Flow, and could very well store the JSON data in a file and read the file in the data flow, but this is too much of a workaround for my taste :)