Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

rest api date range query params

chamarts
Kilo Explorer

‎03-01-2016 12:31 PM

Hi,

how do I query the rest api for incidents between date range ?   I used /incident?start=&end= but this doesn't see to work. It fetches all the records from beginning with 10,000 per page.

I am using chrome advanced rest client to query the api. any help is greatly appreciated

thx

sri

0 Helpfuls
  • 4,958 Views
1 REPLY 1

Thijs Daemen
Mega Guru

‎03-01-2016 12:47 PM

Hi Srinivas,



you can use the default way of getting the encoded query from the system.


  • go to the list of records
  • assemble the filter
  • right click on it -> copy query


Use the query in your REST API call for the sysparm_query parameter



Example:


https://<instance>.service-now.com/api/now/table/incident?sysparm_query=opened_atBETWEENjavascript%3Ags.dateGenerate('2015-12-06'%2C'00%3A00%3A00')%40javascript%3Ags.dateGenerate('2016-03-02'%2C'23%3A59%3A59')



Of course you can use the REST API Explorer to test these calls.



REST API Explorer - ServiceNow Wiki


0 Helpfuls