Getting last login information via API call

srinisubra
srinisubra ✭✭
edited 12/09/19 in API & Developers

I am hitting the users endpoint(https://api.smartsheet.com/2.0/users) to get all of our user information. I am trying to find out inactive users based on last login date. The API call doesn't return me the last login information for any user. I can see this information when I export the csv of the users from the admin console though. The sample response from the list API shows the last login information. Any thoughts on why I am not getting this info through an APIΒ call?

Β 

https://smartsheet-platform.github.io/api-docs/#list-users

Comments

  • dAVE Inden
    dAVE Inden Employee

    For that request to have info on the last login for the users you'll need to make sure you are sending the request with a token from an account that is a System Admin. With that you can then use the include query string parameter set to a value of lastLogin. The example in the docs is using this query string. This will return a max of 100 user objects and you can use paging query string parameters to move through the pages of the results if needed.

    The URL would look like this:

    https://api.smartsheet.com/2.0/users?include=lastLogin

  • Curibe
    Curibe ✭✭

    i did ran the following https://api.smartsheet.com/2.0/users?include=lastLogin but it gave me the same result with no lastLogin here is an example of the attributes that was returned

    emailΒ Β Β Β Β Β Β Β :

    nameΒ Β Β Β Β Β Β Β Β :

    firstNameΒ Β Β Β Β Β :

    lastNameΒ Β Β Β Β Β Β :

    adminΒ Β Β Β Β Β Β Β :

    licensedSheetCreator :

    groupAdminΒ Β Β Β Β Β :

    resourceViewerΒ Β Β Β :

    jiraAdminΒ Β Β Β Β Β :

    jiraUserΒ Β Β Β Β Β Β :

    salesforceAdminΒ Β Β :

    idΒ Β Β Β Β Β Β Β Β Β :

    statusΒ Β Β Β Β Β Β Β :

    sheetCountΒ Β Β Β Β Β :

    please let me know how to get lastLoging as part of the list user results in "https://smartsheet.redoc.ly/tag/users#operation/list-users"

  • Hi @Curibe

    How many users do you have?

    If you have more than 100, you must paginate your query to see lastLogin.

    Note also that this field won't appear if the user never logged in or if they did not login in the last 6 months.

    Here's more information: https://smartsheet.redoc.ly/tag/users#operation/list-users

    Cheers,

    Genevieve

    Need more information? πŸ‘€ | Help and Learning Center

    こんにけは (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!πŸ‘‹ | Global Discussions

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com