Table API not returning the correct recordsIssue <!-- div.margin { padding: 10px 40px 40px 30px; } table.tocTable { border: 1px solid; border-color: #e0e0e0; background-color: #fff; } .title { color: #d1232b; font-weight: normal; font-size: 28px; } h1 { color: #d1232b; font-weight: normal; font-size: 21px; margin-bottom: 5px; border-bottom-width: 2px; border-bottom-style: solid; border-bottom-color: #cccccc; } h2 { color: #646464; font-weight: bold; font-size: 18px; } h3 { color: #000000; font-weight: bold; font-size: 16px; } h4 { color: #666666; font-weight: bold; font-size: 15px; } h5 { color: #000000; font-weight: bold; font-size: 13px; } h6 { color: #000000; font-weight: bold; font-size:14px; } ul, ol { margin-left: 0; list-style-position: outside; } --> 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.