ServiceNow Rest API - date filter - doesn't work

Question

How do we retrieve the incidents for the last 1 hour through rest api ? The following filter doesn't seem to work and returns every incident

https://instance.service-now.com/api/now/table/incident?sys_parrn_query=active=true^sys_created_onBETWEENjavascript:gs.dateGenerate('2018-02-28','05:00:00')@javascript:gs.dateGenerate('2018-02-28','06:00:00')&sysparm_fields=number,priority,short_description,caller_id,description,description,sys_id,severity,sys_created_on,sys_updated_on

i can see a typo in the query `sys_parrn_query` should be `sysparm_query` — Rafay, Feb 28 '18 at 13:48
Fixing that typo should fix this, I verified before and after on a private instance. — Kirk, Feb 28 '18 at 14:49

score 1 · Answer 1 · answered Mar 02 '18 at 14:06

1

Glad that helped..

As mentioned in the comments fixing the typo, sys_parrn_query to sysparm_queryshould fix your issue.

A couple of useful links related to Filters:

Use a URL query to filter a list result Filters and breadcrumbs

answered Mar 02 '18 at 14:06

Rafay

30,236
5
64
98

score 0 · Answer 2 · edited Jul 18 '18 at 05:17

0

Try this query:

https://instance.service-now.com/api/now/table/incident?sysparm_query=active=true^sys_created_onBETWEENjavascript:gs.dateGenerate('2018-02-28','05:00:00')@javascript:gs.dateGenerate('2018-02-28','06:00:00')&sysparm_fields=number,priority,short_description,caller_id,description,description,sys_id,severity,sys_created_on,sys_updated_on

edited Jul 18 '18 at 05:17

CJ Dennis

3,676
2
32
53

answered Jul 18 '18 at 04:45

Bhuvan

1

Can you explain why this solves the problem? Although it may solve it, explaining *why* or *how* it does so is often more important. Thank you! – Max von Hippel Jul 18 '18 at 04:48
@Bhuvan You should provide some explanation here! What is changed? What is the reason of the problem? – Aozi Jul 18 '18 at 05:13

ServiceNow Rest API - date filter - doesn't work

2 Answers2