Canvas Data 2 - Incremental Query Since timestamp

Jump to solution
KeithSmith_au
Community Contributor

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?

Labels (1)
1 Solution
LeventeHunyadi
Instructure
Instructure

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.

View solution in original post