joe_fahs
Community Participant

Report of user creation date for all Canvas users

Canvas Admin Reports provides a report of all users with their last logon dates but not when the accounts were actually created. 

Is there an API call to list the creation date for all users? I have very basic knowledge of API's.

Thank you for any guidance that you can provide. 

0 Kudos
3 Replies
ellen_peters
Community Participant

I have not found an API call for this, but I know there is a created_at column in the pseudonym_dim file in Canvas Data. As far as I can tell, this is the date that the user was created.

0 Kudos
chriscas
Community Coach
Community Coach

Hi @joe_fahs,

The Users API will return a "created_at" field for each user, which should be exactly what you want.  If you run the users list API for your whole account, you'll have to take pagination into account to get all of your users, but shouldn't be too difficult.

Hope this helps!

-Chris

0 Kudos
joe_fahs
Community Participant

Hi @chriscas 

Thanks for pointing me in the right direction. I was able to pull the first 100 records in macOS Terminal with the command (per_page max of 100 it seems)

curl -X GET "https://school.instructure.com/api/v1/accounts/self/users/?page=1&per_page=100" -H "Authorization: Bearer xxx"

and will work on pagination next to get all records.

Joe