API pagination same records repeated

I'm learning the basics of API and scripting and trying to start with a simple request - all record IDs for the given table using pagination (limit and offset) and have it saved as a JSON file. I’m encountering an issue where the same set of records is returned repeatedly.

Here’s what I’m doing:

• Using limit=100 and incrementing offset by 100 for each request.
• The API fetches records successfully, but each call after the first just repeats the same 100 records instead of fetching the next set.

Has anyone encountered this issue or have suggestions on what might be causing it?

Thanks!