/table api not returning response when `Z` is included in filter datetime
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-04-2026 11:28 AM - edited 02-04-2026 11:45 AM
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
