AnsweredAssumed Answered

Can See Assignment Due Date in API But Not Canvas Data

Question asked by Brett Sheeran on Jun 7, 2018
Latest reply on Jun 7, 2018 by Samuel Timme

Hi,

 

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:
https://stpetersgirls.instructure.com/api/v1/courses/5148/assignments/29092?access_token=<snip/>

 

The API returns:
due_at: 2018-06-18T14:29:00Z

 

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;

 

Any suggestions?

 

Thanks

 

Regards Brett Sh

Outcomes