# Export "latest login" column

**URL:** <https://community.auth0.com/t/export-latest-login-column/20810>\
**Category:** Get Help\
**Created:** [January 31, 2019, 9:58am UTC](https://community.auth0.com/t/export-latest-login-column/20810 "2019-01-31T09:58:59Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![assaf.myers](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/assaf.myers/32/11129_2.png) [@assaf.myers](https://community.auth0.com/u/assaf.myers)\
**Post date:** [January 31, 2019, 9:58am UTC](https://community.auth0.com/t/export-latest-login-column/20810/1 "2019-01-31T09:58:59Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![konrad.sopala](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/konrad.sopala/32/13516_2.png) [@konrad.sopala](https://community.auth0.com/u/konrad.sopala)\
**Post date:** [January 31, 2019, 11:46am UTC](https://community.auth0.com/t/export-latest-login-column/20810/2 "2019-01-31T11:46:28Z")

</div>

Hey @asaf!

Have you tried reading our docs on that:

> **[User Import / Export Extension](https://auth0.com/docs/customize/extensions/user-import-export-extension)**
>
> Learn about the User Import/Export extension, which allows you to import and export users from or to any database you have configured in your account.

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

---

<div class="post-metadata">

**Author:** ![markd](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/markd/32/38919_2.png) [@markd](https://community.auth0.com/u/markd)\
**Post date:** [January 31, 2019, 12:35pm UTC](https://community.auth0.com/t/export-latest-login-column/20810/3 "2019-01-31T12:35:13Z")

</div>

Another option is the [`/users-exports`](https://auth0.com/docs/api/management/v2#!/Jobs/post_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.

```auto
{
    "format": "json",
    "fields": [
        {
            "name": "email"
        },
        {
            "name": "created_at"
        },
        {
            "name": "last_login"
        },
        {
            "name": "logins_count"
        }
    ]
}

```

---

<div class="post-metadata">

**Author:** ![assaf.myers](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/assaf.myers/32/11129_2.png) [@assaf.myers](https://community.auth0.com/u/assaf.myers)\
**Post date:** [January 31, 2019, 12:54pm UTC](https://community.auth0.com/t/export-latest-login-column/20810/4 "2019-01-31T12:54:39Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![konrad.sopala](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/konrad.sopala/32/13516_2.png) [@konrad.sopala](https://community.auth0.com/u/konrad.sopala)\
**Post date:** [January 31, 2019, 1:56pm UTC](https://community.auth0.com/t/export-latest-login-column/20810/5 "2019-01-31T13:56:42Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![assaf.myers](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/assaf.myers/32/11129_2.png) [@assaf.myers](https://community.auth0.com/u/assaf.myers)\
**Post date:** [January 31, 2019, 2:26pm UTC](https://community.auth0.com/t/export-latest-login-column/20810/6 "2019-01-31T14:26:37Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![markd](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/markd/32/38919_2.png) [@markd](https://community.auth0.com/u/markd)\
**Post date:** [January 31, 2019, 2:48pm UTC](https://community.auth0.com/t/export-latest-login-column/20810/7 "2019-01-31T14:48:30Z")

</div>

Hi @assaf.myers,

Are you setting an [access token](https://auth0.com/docs/api/management/v2/tokens) before calling the endpoint?

---

<div class="post-metadata">

**Author:** ![assaf.myers](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/assaf.myers/32/11129_2.png) [@assaf.myers](https://community.auth0.com/u/assaf.myers)\
**Post date:** [January 31, 2019, 3:06pm UTC](https://community.auth0.com/t/export-latest-login-column/20810/8 "2019-01-31T15:06:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![konrad.sopala](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/konrad.sopala/32/13516_2.png) [@konrad.sopala](https://community.auth0.com/u/konrad.sopala)\
**Post date:** [January 31, 2019, 3:24pm UTC](https://community.auth0.com/t/export-latest-login-column/20810/9 "2019-01-31T15:24:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![konrad.sopala](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/konrad.sopala/32/13516_2.png) [@konrad.sopala](https://community.auth0.com/u/konrad.sopala)\
**Post date:** [August 29, 2019, 10:30am UTC](https://community.auth0.com/t/export-latest-login-column/20810/10 "2019-08-29T10:30:26Z")

</div>