/table api not returning response when `Z` is included in filter datetime

sameerk91509955
Giga Contributor

The api/now/v1/table API does not return any results when the sys_updated_on filter includes a trailing Z, even though the datetimes are sent in correct UTC format. For example, no records are returned for the following filter:

sys_updated_on>2026-01-20T16:21:52Z^sys_updated_on<2026-01-20T19:23:10Z

However, the API returns the expected results when the same filter is used without the Z suffix:

 

sys_updated_on>2026-01-20T16:21:52^sys_updated_on<2026-01-20T19:23:10

 

The only difference between the two queries is the presence of Z.  This behaviour is observed in one servicenow instance but in one of other dev instance it is working fine with proper UTC date with `Z`


Instance (not working with Z)

  • Build name: Zurich

  • Build date: 12-25-2025_1331

  • Build tag: glide-zurich-07-01-2025__patch4-hotfix3-12-23-2025

  • MID buildstamp: zurich-07-01-2025__patch4-hotfix3-12-23-2025_12-25-2025_1331

 

Any reason why it is happening, is it a known issue? any breaking changes from servicenow side? Attached screenshots of working and non working APIs

0 REPLIES 0