User Import Export Extension not Loading for Large Database

Knowledge Articles
, , , ,
1

Problem statement

There is a large database with over 12 million users. When using the User Import Export Extension to export users, the Export button is not enabled after selecting the database.

image
image2298×1504 183 KB

Cause

The method used to retrieve an estimate of the user count for a connection only goes up 1000, and it can break the import-export extension if the user search query takes too long to complete, such as a connection with millions of users.

Solution

Use the Management API endpoint POST /api/v2/jobs/users-exports to perform the user export on large connections.