question Re: 404 Error in case of REST API not returning any data in Developer forum

404 Error in case of REST API not returning any data

Dan87 — Mon, 28 Oct 2024 18:46:48 GMT

Hi Team,

I am using REST API to get data from tables.

However, it seems in case of nor records found in particular time range, API returns 404 and below response.

{
    "error": {
        "message": "No Record found",
        "detail": "Records matching query not found. Check query parameter or offset parameter"
    },
    "status": "failure"
}

Is this correct behavior and we need to handle this 404 response in case of empty records.

Query used:

sys_created_on>=javascript&colon;gs.dateGenerate('2024-10-28','18:25:01')^sys_created_on<javascript&colon;gs.dateGenerate('2024-10-28','18:30:01')^ORDERBYDESCsys_created_on

This query works well for other time range.

Please let me know if anything wrong with query as well.

Add Products

Re: 404 Error in case of REST API not returning any data

Sheldon Swift — Tue, 29 Oct 2024 05:09:53 GMT

Hi @Dan87 - I would expect 200 OK and an empty result set, not a 404.

{ "result": [] }

In this case, I suspect you're using the wrong endpoint.

Retrieving a single record:
- GET /api/now/table/{table}/{sys_id}
Retrieving multiple records:
- GET /api/now/table/{table}

Also, at a glance, your query appears to be malformed. The query parameters should look like:

?sysparm_query=sys_created_on>=javascript&colon;gs.dateGenerate('2024-10-28','18:25:01')^sys_created_on<javascript&colon;gs.dateGenerate('2024-10-28','18:30:01')

?sysparm_query=sys_created_on%3E%3Djavascript%3Ags.dateGenerate('2024-10-28'%2C'18%3A25%3A01')%5Esys_created_on%3Cjavascript%3Ags.dateGenerate('2024-10-28'%2C'18%3A30%3A01')

Finally, if I understand correctly that your intended query parameters are Created >= 2024-10-28 18:25:01 AND Created < 2024-10-28 18:30:01, you might consider using the between operator instead.

Re: 404 Error in case of REST API not returning any data

Dan87 — Wed, 27 Nov 2024 21:09:13 GMT

Thanks Sheldon!

1. I want multiple records hence using below api

GET /api/now/v1/table/sys_audit

2. I pasted the parameters from curl command above.
Actual params looks like this

sysparm_limit:10000 sysparm_offset:0 sysparm_query:sys_created_on>=javascript&colon;gs.dateGenerate('2024-11-27','04:06:58')^sys_created_on<javascript&colon;gs.dateGenerate('2024-11-27','05:06:58')^ORDERBYDESCsys_created_on

3. And the response is 404:

{ "error": { "message": "No Record found", "detail": "Records matching query not found. Check query parameter or offset parameter" }, "status": "failure" }

I am trying to understand is this the current behavior of api.

Re: 404 Error in case of REST API not returning any data

Sheldon Swift — Fri, 29 Nov 2024 16:36:03 GMT

You're using the v1 Table API...just switch to v2 (/api/now/v2/table/sys_audit) or latest (/api/now/table/sys_audit).

In version v1, if a GET query to retrieve multiple records matches no records, the response is the error No Record Found with status code 404.

In version v2, if a GET query to retrieve multiple records matches no records, the response is an empty array with status code 200.

Source: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0551763