sysparm_offset and sysparm_limit not quite working
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-01-2025 09:52 AM - edited ‎07-01-2025 10:40 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-01-2025 10:13 AM
Hi Curtis,
Can you share the Endpoint you are trying with?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-01-2025 10:19 AM
/api/now/v1/table/cmdb_model
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-01-2025 10:29 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-01-2025 10:33 AM
Sorry, the post title is incorrect but the parameters I am using are correct:
&sysparm_offset=3001&sysparm_limit=1000