Has anyone successfully retrieved the completed_at date for an enrolment via the API?

[barbaracoen]

Hi 

We've been trying to access the completed_at date for enrolments so that we can easily report the number of students that have completed courses in a given time period. However we're having trouble accessing this field via the API - has anyone been able to do this and if so, would you mind explaining how?

Thanks a million

Barbara

[barbaracoen · Accepted solution]

Just in case anyone looks this up in the future, this is the info we received from support ...

At the current moment there is not an endpoint in the API for a completed at field, like the created_at or updated_at fields in the API. The Student Enrollments Report build by Professional Services actually queries the database for the enrollment data when creating the CSV, and not through an API call to the enrollments. The enrollment completed at date, if wanting to locate it, can be found in Canvas Data through the enrollment_dim for the completed_at timestamp.

I'll update this conversation later if we manage to get the data!

Thanks

Barbara

[stuart_ryan]

Hi  @barbaracoen ,

Thank you for coming back and updating your question with the new information your received from Support.

I had a bit of a hunt around in the community and was unable to find this as a pre-existing feature request. If you would like to see it in future, I think it would be a great candidate for you to create an idea suggesting it is added to the APIs for which both yourself and others could vote on.

Thanks so much again for following up!

Stuart