AnsweredAssumed Answered

Discrepancy between Canvas Data "graded_at" and Submissions API "graded at" values?

Question asked by Ruby P Nugent on Jun 18, 2015
Latest reply on Dec 1, 2015 by Zac Watson


I was comparing submissions data and noticed a difference between the "graded_at" dates that were returned via Canvas Data in Redshift and the Submissions API.  I suspect it is timezone-related since it matches some of the time but not all the time, but wanted to confirm what we are seeing and understand why.


I am looking at submissions_dim.graded_at and comparing to what gets returned via API  /api/v1/courses/:course_id/students/submissions for graded_at value.  e.g.  for canvas course 618, assignment 4972, student 262554, Redshift returns 2/23/15 for graded_at while API returns 2/22/15.  For canvas course 618, assignment 4889, student 262554, the dates match.


Please advise, thanks.