Using sysparm_query with Incident table

[thedavegray]

Hi all, 

Can I please get some starter advice on using the query parameter sysparm_query on the Incident table. 

Is it possible to get a date range based upon the sys_created_on field? So for example I would like to get just elements that match sys_created_on>=2022-01-21 AND <2022-01-22, I tried this but it does not work, it returns 

elements for 23rd, 24th etc,

sys_created_on%3E%3D2022-01-21&sys_created_on%3C2022-01-22

On the understanding that %3E%3D is >= and %3C is < (less than). 

Is it not possible to use multiple parameters with sys_created_on?

Screenshot of query running in Postman with values greater that 

Thanks 

[Basheer]

Hi @thedavegray ,

I would recommend to use sysparm limit and offset for the requirement instead of sysparm first row.

Do remember to set the quota limits before setting the sysparm limit. By default it is 60 seconds.

You can either increase the quota limit to increase the data in a single call or decrease the sysparm_limit so that whatever data is there goes within 60 seconds.

Refer below link for documentation and learning.

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

https://developer.servicenow.com/dev.do#!/learn/courses/sandiego/app_store_learnv2_rest_sandiego_res...