Issue
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.