Invalid pagination rule in Copy data, assistance appreciated

Nov '24 • Technical

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:

0 comments

skool.com/microsoft-fabric

Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.

Leaderboard (30-day)

+33

+24

+19

+15

+13