I'm finding some assignments show a due date when I query the API, but *not* when I query Canvas Data.
For example, if I query assignment 29092 through the API like so:
The API returns:
Whereas, if I run this SQL:
select id, title, due_at from assignment_dim a where canvas_id = 29092;
The DB returns:
due_at: 0000-00-00 00:00:00
Incidentally, have tried downloading the data several times. I also ran the following query to see if there were any overrides, but couldn't find anything.
select * from assignment_override_dim where assignment_id = 32760000000029092;
Regards Brett Sh