Canvas Data 2 - Incremental Query Since timestamp
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-26-2023
06:21 PM
The documentation on the table query for since states "Start timestamp (in UTC); only those records are returned that have been persisted since the specified date and time " with examples like "since": "2022-07-14T10:30:00Z".
All the examples I have seen use Zulu for the timestamps. Other time zones appear to work (e.g. "since": "2022-07-14T20:30:00+10:00")
The definition of timestamp elsewhere refers to RFC 3339, but I am a little concerned about the (in UTC) qualification.
Can anyone confirm that this parameter does indeed cater for any timezone reference for the "since" value?
Solved! Go to Solution.
1 Solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023
03:05 AM
I can confirm. The exact Python code looks like this:
datetime.fromisoformat(s).astimezone(timezone.utc)
In other words, if you supply an RFC 3339 date-time with a time zone designator, the date-time is converted into UTC, accommodating for the time zone difference.