Export users list/accepted/not accepted invitation

Jump to solution
MARYMCGINTY1
Community Member
I have a question about exporting a user list in Canvas.  I can't find a way, and I also can't find any reference to it in the guide.
 
What I'm actually after is a way to export users so I can see who hasn't accepted the invitation without scrolling through 1900+ names on the People screen.  I have a course for the entire student body to self enroll in, so a csv file would be the easiest way to follow up on students who haven't yet accepted the invitation.
0 Likes
1 Solution
NicoletteStaley
Instructure
Instructure

@MARYMCGINTY1 There may be a way for you to locate the information that you are looking for about the pending enrollments in a course via the API.  It won't provide you with a CSV, but a JSON that you could then convert to a CSV using a tool like this one . 

You could access this JSON at https://[your Canvas domain]/api/v1/courses/[course number]/enrollments?per_page=100&page=1 .    If you wanted to the Json to already be filtered to include only students whose enrollments are pending you would format it as https://[your Canvas domain]/api/v1/courses/[course number]/enrollments?state[]=invited&per_page=100&page=1

*note these JSONS will display they first 100 results, if your course has over a thousand users like you state, you would want to change the page at the end of the provided urls about to be able to "page" through the enrollments

View solution in original post

0 Likes