Trying to retrieve all users in a Database

[carl.t]

Using the below endpoint, i only get back 50 records out of 500. Why?

“https://xxxxxxxx/api/v2/users?q=identities.connection:” + Auth0DbConnectionName

I cant find info on why only 50 are returned.

[sylvainf]

Hi @carl.t

That’s probably because you only grab the first page of the results and without using the per_page parameter documented here, this value is set to 50.

In other words, use the page param to grab the next page until you get all records, and if you need more (or less) records per page, use the per_page param.

Keep in mind that even with pagination you’re limited to 1000 total records so you might want to use several queries with predefined filters (loop on first letter of alphabet for example) or use a User export instead.