Auth0 Home Blog Docs

Export "latest login" column

#1

Hello everyone,

I exporting my user list and im trying to add manually the colum “Latest login” and cant seem to make it work.

does any 1 know how to add it?

#2

Hey @asaf!

Have you tried reading our docs on that:

Let me know if you’ve tried it otherwise I’ll try to find any tips on how to handle that!

#3

Another option is the /users-exports management API endpoint. You can pass in a job file (see below) and you will get back a dump of your entire user database, with the fields specified in the job file.

{
    "format": "json",
    "fields": [
        {
            "name": "email"
        },
        {
            "name": "created_at"
        },
        {
            "name": "last_login"
        },
        {
            "name": "logins_count"
        }
    ]
}
#4

Yes i used it but in there i cant manage to get the “last login” column to work

#5

Gotchya! Then go for the Management API option that Mark presented above. It’ll for sure let you do what you plan!

#6

I tried what markd wrote but it keeps telling me missing authentication.
error code : 401
response body:
{
“statusCode”: 401,
“error”: “Unauthorized”,
“message”: “Missing authentication”
}

response header
{
“www-authenticate”: “Bearer”,
“content-type”: “application/json; charset=utf-8”,
“cache-control”: “private, no-store, no-cache, must-revalidate, post-check=0, pre-check=0”
}

#7

Hi @assaf.myers,

Are you setting an access token before calling the endpoint?

#8

no, first time ever using that site.
ill read about it thanks!

2 Likes
#9

Let us know if you are able to handle that eventually!