Symptoms

Table API not returning the correct records. sysparm_query is not respected in the API call.

Example API call:

https://<instance_name>.service-now.com/api/now/table/sc_req_item?sysparm_query=0&sysparm_query=sys_created_onBETWEENjavascript:gs.dateGenerate('2018-01-01','00:00:00')@javascript:gs.dateGenerate('2018-01-02','00:00:00')&sysparm_display_value=true&sysparm_limit=100

Release

All versions

Cause

An invalid query in the URL ie. sysparm_query=0 which causes invalid records to get pulled via API call.

Resolution

Remove the invalid query i.e. sysparm_query=0 from the API call.