Table API GET Call not returning all values

[EricG]

My PowerBI specialist is running a Table API with the following parameters

instance.service-now.com/api/now/table/task?sysparm_query=sys_updated_onBETWEENjavascript%3Ags.dateGenerate(%272022-02-01%27%2C%2700%3A00%3A00%27)%40javascript%3Ags.dateGenerate(%272022-02-28%27%2C%2723%3A59%3A59%27)

They are getting results, but missing some records.

if i add %5EnumberSTARTSWITHRITM0468653 to the end of the above, they get that record.

Any reason why this record is missing and others.

We  spot checked some other tickets and they were missing too.

Is this a record limitation?

[VaranAwesomenow]

if you run the same query condition on a list, is that working ? that would be a good way to test the query.

[EricG · Accepted solution]

Yes I can pull the query.

Looks like it was a Record Limit issue.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0727636

created several get statements with the ysparm_offset parameter set for each 10000 records

example
qry 1  had sysparm_offset=0

qry 2 had sysparm_offset=10000

qry 3 had sysparm_offset=20000

and so on till i reached  the list query total.

Thanks.