[ARCHIVED] Bulk delete users with no SIS ID

[megankoontz]

Hi there,

is there any way to bulk delete spambots?  They don't have SIS IDs which are required for the SIS upload CSV file. - see screenshot (this is not a real person so I felt OK sharing the email address)

We have over 1000 of these in our account and I'd really like to clean it up!

Thank you

Megan

[jerry_nguyen]

@megankoontz 

You can use Canvas API to remove users. The process is as follow:

1. Use this endpoint GET /api/v1/accounts/1/users (Root account endpoint) with this parameter search_term to look up User's Canvas ID

2. Then use that User's ID with this endpoint DELETE /api/v1/accounts/:account_id/users/:user_id to remove user

If you are not familiar with using API, I create a spreadsheet where you can enter a list of email to remove users

[BrianLester]

You could run the get users in account API call to get all user IDs:

https:/****.instructure.com/doc/api/live#!/users.json/list_users_in_account_get_0

(Replace **** with your institution if you're using an instructure.com address)

then run show user details call for each user:

https://****.instructure.com/doc/api/live#!/users.json/show_user_details_get_11

You could code this to filter for users without an SIS ID

Then delete these users

Obviously test this in beta first

You may also be able to do this using account reports, and SIS style csv uploads.