using REST API Explorer to get List of change request Between a time range

[venky1544]

HI

I would like to pull the list of change request from a date range using REST API explorer

can you please help me

[Alikutty A]

Hello,

You can apply your date range filter on your SN Table, copy its query and then paste it within the sysparm_query of REST API Explorer. This will filter out the required records from your Table within the date range mentioned in the query field.

Thanks!

[Alikutty A · Accepted solution]

For eg; 

sys_created_onBETWEENjavascript:gs.dateGenerate('2018-12-17','00:00:00')@javascript:gs.dateGenerate('2018-12-18','23:59:59')

will give you all records created today and yesterday. This query is copied from the filter applied on a table and you could paste it on your API Explorer.

[Alikutty A]

Hello Venky,

If your query is answered, request to mark a correct answer and close this thread. Thanks!

[santhoshsekar]

How to implement in python