Data API URL only pulling 100 rows

You should change this. No one understands it.

Azure literally has a switch - pagination on or off. If on then everything is automatically handled. No cursors or other nonsense.

Azure also fetches 1000 items before pagination is required - not 100. 100 is way too small a number.

Finally you can also set a limit on the number of number of records to be retrieved- e.g. stop pagination after 10,000 items, or 5,000. Etc.

You should consider making your pagination this easy.

7 Likes