I am currently working on a set of google spreadsheets that will filter the MGP Grade Export admin report (newly implemented - thank you Canvas!). The purpose of these spreadsheets is to provide grade data to our administration and guidance departments for student monitoring and specific academic auditing requirements in a useful and easy to read way.
Thank you for any help/advice in advance!
I'm not an expert on this kind of thing but maybe I can help get you started.
The information for running account reports can be found here: Account Reports - Canvas LMS REST API Documentation
You can generate a report using the API and specify the report type which in your case would be mgp_grade_export_csv
Then you can use the "status of report" API call to monitor the progress. When the report is done, that call will return a url to a csv file which can be imported into Google Drive.
Thank you @kona for sharing with the developer community!
@MattHanes - Thank you for the reply and the info, it was quite helpful.
I did find some examples from various other posts and was able to connect and access reports via the API. My problem now is that the MGP Grade Export returns a zip file with the csv inside instead of just a csv.
Any advice would be greatly appreciated!
Were you able to find an answer to your question? I am going to go ahead and mark this question as answered because there hasn't been any more activity in a while so I assume that you have the information that you need. If you still have a question about this or if you have information that you would like to share with the community, by all means, please do come back and leave a comment.
Sorry for my absence. The mgp report had some issues initially (huge number of duplicate entries). This has recently been fixed by Canvas (thanks!)
The current issue is that the report is returned as a zip file containing a csv file and I have not had luck decompressing and accessing the csv via a google script. Anyone with any ideas on this would be greatly appreciated! Thanks in advance!