Date Query Parameter in ISO 8601 standard doesn't return results

myusufk90
Tera Contributor

‎02-12-2024 04:32 AM

Hi Everyone,

We have a system that's integrating to our instance via API. When the system attempts to connect to our instance using query 1, no results are returned but when query 2 is executed, results are returned. Is there any way for us to configure our instance to accept both formats of the date/time format?

 

Query 1:

https://instance_name.service-now.com/api/now/v2/table/task?sysparm_query=sys_updated_on>=2023-10-27T23:59:59Z^sys_updated_on<2023-11-01T23:59:59Z^ORDERBYsys_created_on&sysparm_limit=10000

 

Query 2

https://instance_name.service-now.com/api/now/v2/table/task?sysparm_query=sys_updated_on>=2023-10-27 23:59:59^sys_updated_on<2023-11-01 23:59:59^ORDERBYsys_created_on&sysparm_limit=10000

 

 

0 Helpfuls
  • 266 Views
1 REPLY 1

ARUN MANOJ
Tera Contributor

‎02-12-2024 04:43 AM

Hi,

It is due to timezone , where query 1, this query retrieves records updated between October 27, 2023, at 23:59:59 UTC, and November 1, 2023, at 23:59:59 UTC. Where query 2 , timezone not specific so, it will fetch data as per the date/time.

 

I Hope it will be helpful,

 

 

 

0 Helpfuls