[ARCHIVED] Roles table into a spreadsheet

[JarredMcNeely]

Is there a way to pull a report from the permissions tab showing the roles and permissions granted to them?

[Ron_Bowman]

@JarredMcNeely -

I am going to guess the only way would be with an API call.  Unfortunately, I do not know what information to tell you other than that.  Someone with experience using API's may see this and respond if it is possible.

I am not familiar with the permissions tab, so I will guess that you are an admin and this is one of the admin views.

[Sandie]

I don't think there is any report that you can pull this data. We have different roles and accounts created for different users so we keep track of the permission records by creating our own spreadsheet manually. 

[Sandie]

@JarredMcNeely 

There are PDF files that you can download but not spreadsheet.

Canvas_Permissions_Course

Canvas_Permissions_Account

Hope this helps.

[Ron_Bowman]

@Sandie -

Thanks for the pdf's explaining all the various aspects of roles and permissions.  That is a useful reference to keep around.

However, I think what @JarredMcNeely was looking for, is - in a canvas course or for an entire institution - is there a way to pull the role and permissions for all people using Canvas.  I could be wrong and they may have been looking for what you posted.

[Sandie]

@Ron_Bowman 

You are welcome 😊. The PDFs are from Canvas Resource documents and only listed the default accounts and course roles permissions. 

As mentioned before we created extra accounts and roles than the defaulted so we keep our own records in a spreadsheet. I may be wrong but I think even with the API call it will only give @JarredMcNeely a list of text that she will still need to manually create/convert into a spreadsheet.

Would love to know if someone have the solution so I dont have to keep update our record manually.

[NicoletteStaley]

@JarredMcNeely 

As the other contributors posited, there is no "report" that can be downloaded that lists the particular permissions for each role in a Canvas instance, but you can use the API to access a JSON file listing this permissions.  Then you could use a script or online-tool to convert the JSON to a CSV that would open as a spreadsheet in Excel, Sheets, or a similar program.

The API call would be  GET /api/v1/accounts/:account_id/roles

and the documentation on that part of the API can be found at Canvas Roles API Documentation