sysparm_offset and sysparm_limit not quite working

markcurtis
Tera Contributor

I am interrogating a SNOW API instance and need to request a chunk of data at a time through the query parameters sysparam_offset and sysparam_limit. It seems the limit is not honored, in that, in some cases, the actual number of results is less than the limit. This becomes problematic as I am not sure what items have been missed.

9 REPLIES 9

Manoj89
Giga Sage

Hi Curtis,

 

Can you share the Endpoint you are trying with?

markcurtis
Tera Contributor

/api/now/v1/table/cmdb_model

There is a typo in the parameter, it has to be sysparm_offset and sysparm_limit, remove a from sysparam

/api/now/table/cmdb_model?sysparm_limit=10&sysparm_offset=0

 

Sorry, the post title is incorrect but the parameters I am using are correct:

&sysparm_offset=3001&sysparm_limit=1000