Having an Issue exporting users WITH last login field

Get Help
,
1

I have tried the import / export tool but it returns nothing for last_login

Only the user id field is returned.

I have also tried the bulk export functionality from the app adding last_login, no luck. When I export as a CSV without specifying any fields, I get the column for last_login, and 1800 empty rows. But adding the last_login then gives me an empty column.

Tried using the management API, but it limits me to 1000 paged records so this is no use either.

3

Hi @alex56,

Welcome to the Auth0 Community!

The root cause of your issue is that the last login information is stored in the user metadata and not in the root user object that the bulk export tool directly queries. The bulk export requires you to explicitly select fields from the root user profile, which is why simply adding last_login doesn’t work. For the Management API, the 1000-record limit per page is a default, but it can be overcome by using pagination.

We have two robust solutions for you, depending on whether you prefer a fully-automated API approach or a manual dashboard one.

1. Recommended: Use the Management API with Pagination

This is the most direct and reliable way to get all your users and their full profiles. You must use the page and per_page parameters in your requests to iterate over your user base.

  • Endpoint: GET /api/v2/users
  • Steps:
    1. Start with page=0 and set per_page to a maximum value of 100 (or 50 for better stability).
    2. Include the include_totals=true parameter in your first request to find out the total number of users.
    3. In your request, specify the fields you need, including last_login. You may need to use fields=user_id,last_login,name (or whatever fields you need) and include_fields=true.
    4. Make a subsequent request, incrementing the page number by 1, until you have retrieved all users.

Example Request Flow (Conceptual):

  1. Request 1: GET /api/v2/users?page=0&per_page=100&include_totals=true
  2. Request 2: GET /api/v2/users?page=1&per_page=100
  3. … and so on.

2. Manual Solution: User Export Tool (Alternative Field Selection)

If you still prefer the dashboard tool for a quick, one-off export, try these steps:

  1. Go to Dashboard > Users & Roles > User Export.
  2. Select CSV as the format.
  3. In the “Fields to Include” box, try specifying the exact path to the last_login field if it’s nested. If the bulk export is not picking up the root last_login field, your only reliable option is the Management API (Solution 1), as the dashboard export tool has known limitations with non-root profile fields. The API is the source of truth.

If you have any further questions, please don’t hesitate to reach out.

Have a good one,
Vlad

4

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.