User Import Export Extension not Loading for Large Database

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.

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.