Export "latest login" column

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?

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!

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"
        }
    ]
}

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

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

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”
}

Hi @assaf.myers,

Are you setting an access token before calling the endpoint?

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

2 Likes

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