Creating an inactive licenses report using the API

How to use the Torii API to build a dataset for a report that can be used by popular BI tools such as Tableau and Power BI

This guide provides a brief overview of how to create a report using the BI tool of your choice using data from your Torii account. There are two API calls required for this:

  1. Use the List Apps endpoint to retrieve the list of apps in your organization. The response will include the unique identifier for the app in your organization. This value must be used as the app's unique ID in step (2).
  1. Use the value of id for the app you would like to retrieve information about inactive licenses and the user's they are assigned to with the List Application Users API call. In your code or low code automation artifact this list will need to be processed in a loop which iterates through calling List Application Users for each app that has been discovered in your Torii account.
  1. To process the data so that it can be used as a data source for BI tools such as Tableau or Power BI the JSON responses from each request made to List Application Users will need to be assembled into a single file. This file can then be used as the data source from which to build the report.

    1. Tableau allows usage of JSON files as data sources. Additional information can be found in their documentation as well as this blog post.
    2. Power BI allows usage of JSON files as data sources. Additional information can be found in their documentation.
> ๐Ÿ“˜ {  
>   "users": \[  
>     {  
>       "annualCost": null,  
>       "originFirstName": "Torii",  
>       "isUserRemovedFromApp": false,  
>       "scoreV2": 0,  
>       "lifecycleStatus": "active",  
>       "numberOfInactiveLicenses": 1,  
>       "score": 0,  
>       "originFullName": "Torii Demo",  
>       "idAppAccount": 12023,  
>       "gsuite_emails": [  
>         "[email protected]",  
>         "[email protected]"  
>       ],  
>       "isExternal": false,  
>       "okta_id": "00uo8qzmbWKa5NgZc5d6",  
>       "hubspot_primary_team": "Sales & Marketing",  
>       "annualCostConverted": null,  
>       "firstName": "Torii",  
>       "identitySourcesDeletionTime": null,  
>       "isSupportLastVisit": true,  
>       "isOffboardingIgnored": false,  
>       "isDeletedInIdentitySources": false,  
>       "userType": null,  
>       "originEmail": "[[email protected]](mailto:[email protected])",  
>       "status": "active",  
>       "lastName": "Demo",  
>       "originLastName": "Demo",  
>       "role": null,  
>       "creationTime": "2021-06-25T21:43:41.000Z",  
>       "sources": [  
>         "atlassian",  
>         "google"  
>       ],  
>       "originIdUser": 873786409,  
>       "ignoreAccount": false,  
>       "creationTimeInApp": null,  
>       "idUser": 873786409,  
>       "photoUrl": "<https://avatars.slack-edge.com/2021-04-30/2005593218055_890d98ffeefaf4075fd8_72.png">,  
>       "gsuite_groups": [  
>         "Europe",  
>         "Finance",  
>         "North America",  
>         "South America",  
>         "sales"  
>       ],  
>       "lastVisitTime": "2021-08-31T00:00:00.000Z",  
>       "email": "[[email protected]](mailto:[email protected])",  
>       "slack_slackId": "U020SFJ1RCL",  
>       "gsuite_department": "IT",  
>       "okta_creation_date": "2021-05-01T15:11:19.000Z",  
>       "fullName": "Torii Demo",  
>       "gsuite_orgUnitPath": "/Sales",  
>       "appAccountName": "demo-torii",  
>       "licenses": [  
>         {  
>           "calculatedLastUsageTime": "2021-06-30T01:34:43.000Z",  
>           "calculatedLicenseFeatureStatus": {  
>             "reasonType": null,  
>             "status": "inactive"  
>           },  
>           "isLicenseTypePaid": true,  
>           "lastUsageTime": "2021-06-30T01:34:43.000Z",  
>           "pricePerUser": null,  
>           "idExternalLicense": "license",  
>           "type": "jira-software",  
>           "calculatedStatus": {  
>             "reason": "noUsage",  
>             "ssoSources": null,  
>             "status": "inactive"  
>           },  
>           "name": "Jira Software",  
>           "lastTimeLicenseFeatureUsed": null,  
>           "currency": "USD",  
>           "id": 3,  
>           "pricePerUserConverted": null,  
>           "status": "active"  
>         }  
>       ],  
>       "lastVisitTimeV2": "2021-08-31T00:00:00.000Z",  
>       "externalStatus": "active",  
>       "isNewUserInApp": false,  
>       "isOwnerNotifiedToRemoveUser": false  
>     },  
>     {  
>       "jumpCloud_department": null,  
>       "annualCost": null,  
>       "originFirstName": "Luke",  
>       "isUserRemovedFromApp": false,  
>       "scoreV2": 0,  
>       "lifecycleStatus": "active",  
>       "numberOfInactiveLicenses": 1,  
>       "score": 0,  
>       "onelogin_company": "Demo-Torii",  
>       "originFullName": "Luke Skywalker",  
>       "jumpCloud_costCenter": null,  
>       "idAppAccount": 12023,  
>       "gsuite_emails": [  
>         "[email protected]",  
>         "[email protected]"  
>       ],  
>       "isExternal": false,  
>       "jumpCloud_location": null,  
>       "okta_id": "00uob6vfgDh6n80ht5d6",  
>       "annualCostConverted": null,  
>       "firstName": "Luke",  
>       "onelogin_department": "Finance",  
>       "identitySourcesDeletionTime": null,  
>       "isSupportLastVisit": true,  
>       "jumpCloud_company": null,  
>       "isOffboardingIgnored": false,  
>       "isDeletedInIdentitySources": false,  
>       "userType": null,  
>       "originEmail": "[[email protected]](mailto:[email protected])",  
>       "onelogin_title": "Associate",  
>       "status": "active",  
>       "lastName": "Skywalker",  
>       "originLastName": "Skywalker",  
>       "role": null,  
>       "creationTime": "2021-06-25T01:06:31.000Z",  
>       "sources": [  
>         "atlassian",  
>         "google"  
>       ],  
>       "originIdUser": 916706870,  
>       "ignoreAccount": false,  
>       "creationTimeInApp": null,  
>       "idUser": 916706870,  
>       "photoUrl": null,  
>       "gsuite_groups": [  
>         "North America"  
>       ],  
>       "lastVisitTime": "2021-08-30T00:00:00.000Z",  
>       "email": "[[email protected]](mailto:[email protected])",  
>       "slack_slackId": "U020NUE5UM8",  
>       "gsuite_department": "Engineering",  
>       "okta_creation_date": "2021-05-02T17:59:26.000Z",  
>       "fullName": "Luke Skywalker",  
>       "gsuite_orgUnitPath": "/Finance",  
>       "appAccountName": "demo-torii",  
>       "licenses": [  
>         {  
>           "calculatedLastUsageTime": "2021-06-24T18:24:03.000Z",  
>           "calculatedLicenseFeatureStatus": {  
>             "reasonType": null,  
>             "status": "inactive"  
>           },  
>           "isLicenseTypePaid": true,  
>           "lastUsageTime": "2021-06-24T18:24:03.000Z",  
>           "pricePerUser": null,  
>           "idExternalLicense": "license",  
>           "type": "jira-software",  
>           "calculatedStatus": {  
>             "reason": "noUsage",  
>             "ssoSources": null,  
>             "status": "inactive"  
>           },  
>           "name": "Jira Software",  
>           "lastTimeLicenseFeatureUsed": null,  
>           "currency": "USD",  
>           "id": 3,  
>           "pricePerUserConverted": null,  
>           "status": "active"  
>         }  
>       ],  
>       "jumpCloud_jobTile": null,  
>       "jumpCloud_employeeType": null,  
>       "lastVisitTimeV2": "2021-08-30T00:00:00.000Z",  
>       "onelogin_userManager": {  
>         "firstName": "Torii",  
>         "lastName": "Demo",  
>         "photoUrl": "<https://avatars.slack-edge.com/2021-04-30/2005593218055_890d98ffeefaf4075fd8_72.png">,  
>         "fullName": "Torii Demo",  
>         "id": 873786409,  
>         "email": "[[email protected]](mailto:[email protected])"  
>       },  
>       "externalStatus": "active",  
>       "isNewUserInApp": false,  
>       "isOwnerNotifiedToRemoveUser": false  
>     },  
>     {  
>       "lastName": "wan",  
>       "annualCost": null,  
>       "originFirstName": "Obi",  
>       "originLastName": "wan",  
>       "isUserRemovedFromApp": false,  
>       "scoreV2": -1,  
>       "role": null,  
>       "lifecycleStatus": "active",  
>       "creationTime": "2021-07-09T02:26:47.000Z",  
>       "sources": [  
>         "atlassian"  
>       ],  
>       "originIdUser": 1084925659,  
>       "numberOfInactiveLicenses": 0,  
>       "ignoreAccount": false,  
>       "creationTimeInApp": null,  
>       "idUser": 1084925659,  
>       "score": -1,  
>       "photoUrl": null,  
>       "lastVisitTime": null,  
>       "originFullName": "Obi wan",  
>       "email": "[[email protected]](mailto:[email protected])",  
>       "idAppAccount": 12023,  
>       "isExternal": false,  
>       "okta_creation_date": "2021-07-08T20:20:59.000Z",  
>       "fullName": "Obi wan",  
>       "okta_id": "00u1661snnXlhIyeR5d7",  
>       "gsuite_orgUnitPath": "/",  
>       "appAccountName": "demo-torii",  
>       "annualCostConverted": null,  
>       "firstName": "Obi",  
>       "identitySourcesDeletionTime": "2023-02-25T00:51:25.000Z",  
>       "licenses": \[],  
>       "isSupportLastVisit": true,  
>       "lastVisitTimeV2": null,  
>       "isOffboardingIgnored": false,  
>       "isDeletedInIdentitySources": true,  
>       "userType": null,  
>       "externalStatus": "active",  
>       "isNewUserInApp": false,  
>       "originEmail": "[[email protected]](mailto:[email protected])",  
>       "status": "active",  
>       "isOwnerNotifiedToRemoveUser": false  
>     },  
>     {  
>       "annualCost": null,  
>       "originFirstName": "Inti",  
>       "isUserRemovedFromApp": false,  
>       "scoreV2": -1,  
>       "lifecycleStatus": "offboarding",  
>       "numberOfInactiveLicenses": 0,  
>       "score": -1,  
>       "originFullName": "Inti Test",  
>       "idAppAccount": 12023,  
>       "isExternal": false,  
>       "okta_id": "00u2gpwrxv0FNIFFs5d7",  
>       "annualCostConverted": null,  
>       "firstName": "Inti",  
>       "identitySourcesDeletionTime": "2021-07-12T01:32:34.000Z",  
>       "isSupportLastVisit": true,  
>       "isOffboardingIgnored": false,  
>       "isDeletedInIdentitySources": true,  
>       "userType": null,  
>       "originEmail": "[[email protected]](mailto:[email protected])",  
>       "status": "active",  
>       "lastName": "Test",  
>       "originLastName": "Test",  
>       "role": null,  
>       "creationTime": "2021-07-10T02:25:13.000Z",  
>       "sources": [  
>         "atlassian"  
>       ],  
>       "salesforce_profile_name": "Standard Platform User",  
>       "originIdUser": 1087843175,  
>       "ignoreAccount": false,  
>       "creationTimeInApp": null,  
>       "idUser": 1087843175,  
>       "photoUrl": null,  
>       "lastVisitTime": null,  
>       "email": "[[email protected]](mailto:[email protected])",  
>       "salesforce_userPreferencesLightningExperiencePreferred": "Yes",  
>       "slack_slackId": "U027U6Q3Z8U",  
>       "okta_creation_date": "2021-11-01T17:47:52.000Z",  
>       "fullName": "Inti Test",  
>       "gsuite_orgUnitPath": "/",  
>       "appAccountName": "demo-torii",  
>       "licenses": \[],  
>       "lastVisitTimeV2": null,  
>       "externalStatus": "active",  
>       "isNewUserInApp": false,  
>       "isOwnerNotifiedToRemoveUser": false  
>     },  
>     {  
>       "lastName": "TestUser1",  
>       "annualCost": null,  
>       "originFirstName": "Temp",  
>       "originLastName": "TestUser1",  
>       "isUserRemovedFromApp": false,  
>       "scoreV2": -1,  
>       "role": null,  
>       "lifecycleStatus": "active",  
>       "creationTime": "2021-07-11T02:25:12.000Z",  
>       "sources": [  
>         "atlassian"  
>       ],  
>       "originIdUser": 1090542200,  
>       "numberOfInactiveLicenses": 0,  
>       "ignoreAccount": false,  
>       "creationTimeInApp": null,  
>       "idUser": 1090542200,  
>       "score": -1,  
>       "photoUrl": null,  
>       "lastVisitTime": null,  
>       "originFullName": "Temp TestUser1",  
>       "email": "[[email protected]](mailto:[email protected])",  
>       "idAppAccount": 12023,  
>       "isExternal": false,  
>       "okta_creation_date": "2021-07-10T17:43:49.000Z",  
>       "fullName": "Temp TestUser1",  
>       "okta_id": "00u16wy42iuMxMXMe5d7",  
>       "gsuite_orgUnitPath": "/",  
>       "appAccountName": "demo-torii",  
>       "annualCostConverted": null,  
>       "firstName": "Temp",  
>       "identitySourcesDeletionTime": "2021-07-11T17:06:06.000Z",  
>       "licenses": \[],  
>       "isSupportLastVisit": true,  
>       "lastVisitTimeV2": null,  
>       "isOffboardingIgnored": false,  
>       "isDeletedInIdentitySources": true,  
>       "userType": null,  
>       "externalStatus": "active",  
>       "isNewUserInApp": false,  
>       "originEmail": "[[email protected]](mailto:[email protected])",  
>       "status": "active",  
>       "isOwnerNotifiedToRemoveUser": false  
>     },  
>     {  
>       "lastName": "Test",  
>       "annualCost": null,  
>       "originFirstName": "Test",  
>       "originLastName": "Test",  
>       "isUserRemovedFromApp": false,  
>       "scoreV2": -1,  
>       "role": null,  
>       "lifecycleStatus": "active",  
>       "creationTime": "2021-07-11T02:25:12.000Z",  
>       "sources": [  
>         "atlassian"  
>       ],  
>       "originIdUser": 1090542284,  
>       "numberOfInactiveLicenses": 0,  
>       "ignoreAccount": false,  
>       "creationTimeInApp": null,  
>       "idUser": 1090542284,  
>       "score": -1,  
>       "photoUrl": null,  
>       "lastVisitTime": null,  
>       "originFullName": "Test Test",  
>       "email": "[[email protected]](mailto:[email protected])",  
>       "idAppAccount": 12023,  
>       "isExternal": false,  
>       "okta_creation_date": "2021-07-10T18:43:17.000Z",  
>       "fullName": "Test Test",  
>       "okta_id": "00u16xk5l13V7HNAq5d7",  
>       "gsuite_orgUnitPath": "/",  
>       "appAccountName": "demo-torii",  
>       "annualCostConverted": null,  
>       "firstName": "Test",  
>       "identitySourcesDeletionTime": "2021-07-11T16:36:58.000Z",  
>       "licenses": \[],  
>       "isSupportLastVisit": true,  
>       "lastVisitTimeV2": null,  
>       "isOffboardingIgnored": false,  
>       "isDeletedInIdentitySources": true,  
>       "userType": null,  
>       "externalStatus": "active",  
>       "isNewUserInApp": false,  
>       "originEmail": "[[email protected]](mailto:[email protected])",  
>       "status": "active",  
>       "isOwnerNotifiedToRemoveUser": false  
>     },  
>     {  
>       "lastName": "TestUser3",  
>       "annualCost": null,  
>       "originFirstName": "Temp",  
>       "originLastName": "TestUser3",  
>       "isUserRemovedFromApp": false,  
>       "scoreV2": -1,  
>       "role": null,  
>       "lifecycleStatus": "active",  
>       "creationTime": "2021-07-12T02:25:16.000Z",  
>       "sources": [  
>         "atlassian"  
>       ],  
>       "originIdUser": 1093266061,  
>       "numberOfInactiveLicenses": 0,  
>       "ignoreAccount": false,  
>       "creationTimeInApp": null,  
>       "idUser": 1093266061,  
>       "score": -1,  
>       "photoUrl": null,  
>       "lastVisitTime": null,  
>       "originFullName": "Temp TestUser3",  
>       "email": "[[email protected]](mailto:[email protected])",  
>       "idAppAccount": 12023,  
>       "isExternal": false,  
>       "okta_creation_date": "2021-07-11T17:02:10.000Z",  
>       "fullName": "Temp TestUser3",  
>       "okta_id": "00u177knhs96f0eqP5d7",  
>       "gsuite_orgUnitPath": "/",  
>       "appAccountName": "demo-torii",  
>       "annualCostConverted": null,  
>       "firstName": "Temp",  
>       "identitySourcesDeletionTime": "2021-07-11T19:15:43.000Z",  
>       "licenses": \[],  
>       "isSupportLastVisit": true,  
>       "lastVisitTimeV2": null,  
>       "isOffboardingIgnored": false,  
>       "isDeletedInIdentitySources": true,  
>       "userType": null,  
>       "externalStatus": "active",  
>       "isNewUserInApp": false,  
>       "originEmail": "[[email protected]](mailto:[email protected])",  
>       "status": "active",  
>       "isOwnerNotifiedToRemoveUser": false  
>     },  
>     {  
>       "lastName": "Russo",  
>       "annualCost": null,  
>       "originFirstName": "Chewbacca",  
>       "originLastName": "Russo",  
>       "isUserRemovedFromApp": false,  
>       "scoreV2": -1,  
>       "role": null,  
>       "lifecycleStatus": "active",  
>       "creationTime": "2021-07-27T02:25:36.000Z",  
>       "sources": [  
>         "atlassian"  
>       ],  
>       "originIdUser": 1136758709,  
>       "numberOfInactiveLicenses": 0,  
>       "ignoreAccount": false,  
>       "creationTimeInApp": null,  
>       "idUser": 1136758709,  
>       "score": -1,  
>       "photoUrl": null,  
>       "lastVisitTime": null,  
>       "originFullName": "Chewbacca Russo",  
>       "email": "[[email protected]](mailto:[email protected])",  
>       "idAppAccount": 12023,  
>       "isExternal": false,  
>       "okta_creation_date": "2021-07-26T18:42:23.000Z",  
>       "fullName": "Chewbacca Russo",  
>       "okta_id": "00u1bzoelr3aaf87a5d7",  
>       "gsuite_orgUnitPath": "/",  
>       "appAccountName": "demo-torii",  
>       "annualCostConverted": null,  
>       "firstName": "Chewbacca",  
>       "identitySourcesDeletionTime": "2022-02-04T20:24:31.000Z",  
>       "licenses": \[],  
>       "isSupportLastVisit": true,  
>       "lastVisitTimeV2": null,  
>       "isOffboardingIgnored": false,  
>       "isDeletedInIdentitySources": true,  
>       "userType": null,  
>       "externalStatus": "active",  
>       "isNewUserInApp": false,  
>       "originEmail": "[[email protected]](mailto:[email protected])",  
>       "status": "active",  
>       "isOwnerNotifiedToRemoveUser": false  
>     },  
>     {  
>       "lastName": "C3PO",  
>       "annualCost": null,  
>       "originFirstName": "C3PO",  
>       "originLastName": "C3PO",  
>       "isUserRemovedFromApp": false,  
>       "scoreV2": -1,  
>       "role": null,  
>       "lifecycleStatus": "active",  
>       "creationTime": "2021-07-27T02:25:36.000Z",  
>       "sources": [  
>         "atlassian"  
>       ],  
>       "originIdUser": 1136758710,  
>       "numberOfInactiveLicenses": 0,  
>       "ignoreAccount": false,  
>       "creationTimeInApp": null,  
>       "idUser": 1136758710,  
>       "score": -1,  
>       "photoUrl": null,  
>       "lastVisitTime": null,  
>       "originFullName": "C3PO C3PO",  
>       "email": "[[email protected]](mailto:[email protected])",  
>       "idAppAccount": 12023,  
>       "isExternal": false,  
>       "okta_creation_date": "2021-07-26T18:38:41.000Z",  
>       "fullName": "C3PO C3PO",  
>       "okta_id": "00u1bzkdjvYhF9uF95d7",  
>       "gsuite_orgUnitPath": "/",  
>       "appAccountName": "demo-torii",  
>       "annualCostConverted": null,  
>       "firstName": "C3PO",  
>       "identitySourcesDeletionTime": "2023-02-25T00:51:25.000Z",  
>       "licenses": \[],  
>       "isSupportLastVisit": true,  
>       "lastVisitTimeV2": null,  
>       "isOffboardingIgnored": false,  
>       "isDeletedInIdentitySources": true,  
>       "userType": null,  
>       "externalStatus": "active",  
>       "isNewUserInApp": false,  
>       "originEmail": "[[email protected]](mailto:[email protected])",  
>       "status": "active",  
>       "isOwnerNotifiedToRemoveUser": false  
>     },  
>     {  
>       "annualCost": null,  
>       "originFirstName": "Yoda",  
>       "isUserRemovedFromApp": false,  
>       "scoreV2": -1,  
>       "lifecycleStatus": "active",  
>       "numberOfInactiveLicenses": 0,  
>       "score": -1,  
>       "bamboohr_zipcode": "94010",  
>       "originFullName": "Yoda Baby",  
>       "idAppAccount": 12023,  
>       "gsuite_emails": [  
>         "[email protected]",  
>         "[email protected]",  
>         "[email protected]"  
>       ],  
>       "isExternal": false,  
>       "okta_id": "00uq0u5a7FHuss2v55d6",  
>       "hubspot_primary_team": "Sales & Marketing",  
>       "annualCostConverted": null,  
>       "firstName": "Yoda",  
>       "bamboohr_city": "Space",  
>       "identitySourcesDeletionTime": null,  
>       "isSupportLastVisit": true,  
>       "isOffboardingIgnored": false,  
>       "isDeletedInIdentitySources": false,  
>       "userType": null,  
>       "originEmail": "[[email protected]](mailto:[email protected])",  
>       "status": "active",  
>       "lastName": "Baby",  
>       "originLastName": "Baby",  
>       "role": null,  
>       "creationTime": "2021-06-25T21:43:41.000Z",  
>       "sources": [  
>         "atlassian"  
>       ],  
>       "originIdUser": 937146029,  
>       "ignoreAccount": false,  
>       "creationTimeInApp": null,  
>       "idUser": 937146029,  
>       "photoUrl": null,  
>       "lastVisitTime": null,  
>       "email": "[[email protected]](mailto:[email protected])",  
>       "gsuite_department": "Finance",  
>       "okta_creation_date": "2021-05-11T17:04:03.000Z",  
>       "fullName": "Yoda Baby",  
>       "gsuite_orgUnitPath": "/",  
>       "appAccountName": "demo-torii",  
>       "bamboohr_country": "United States",  
>       "licenses": \[],  
>       "lastVisitTimeV2": null,  
>       "externalStatus": "active",  
>       "bamboohr_hireDate": "2021-05-26",  
>       "isNewUserInApp": false,  
>       "isOwnerNotifiedToRemoveUser": false  
>     }  
>   ],  
>   "count": 10,  
>   "total": 10  
> }

๐Ÿ“˜

Example JSON combining responses of both API calls

An example is provided below that combines the JSON responses from both API calls. This can be used as a reference for your own implementation. Note that the fields could differ depending on what is in your account and what you may have scoped to return.

{
  "apps": [
    {
      "id": 20,
      "name": "Atlassian",
      "primaryOwner": 937146029,
      "owner": 937146029,
      "users": [
        {
      "annualCost": null,
      "originFirstName": "Torii",
      "isUserRemovedFromApp": false,
      "scoreV2": 0,
      "lifecycleStatus": "active",
      "numberOfInactiveLicenses": 1,
      "score": 0,
      "originFullName": "Torii Demo",
      "idAppAccount": 12023,
      "gsuite_emails": [
        "[email protected]",
        "[email protected]"
      ],
      "isExternal": false,
      "okta_id": "00uo8qzmbWKa5NgZc5d6",
      "hubspot_primary_team": "Sales & Marketing",
      "annualCostConverted": null,
      "firstName": "Torii",
      "identitySourcesDeletionTime": null,
      "isSupportLastVisit": true,
      "isOffboardingIgnored": false,
      "isDeletedInIdentitySources": false,
      "userType": null,
      "originEmail": "[email protected]",
      "status": "active",
      "lastName": "Demo",
      "originLastName": "Demo",
      "role": null,
      "creationTime": "2021-06-25T21:43:41.000Z",
      "sources": [
        "atlassian",
        "google"
      ],
      "originIdUser": 873786409,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 873786409,
      "photoUrl": "https://avatars.slack-edge.com/2021-04-30/2005593218055_890d98ffeefaf4075fd8_72.png",
      "gsuite_groups": [
        "Europe",
        "Finance",
        "North America",
        "South America",
        "sales"
      ],
      "lastVisitTime": "2021-08-31T00:00:00.000Z",
      "email": "[email protected]",
      "slack_slackId": "U020SFJ1RCL",
      "gsuite_department": "IT",
      "okta_creation_date": "2021-05-01T15:11:19.000Z",
      "fullName": "Torii Demo",
      "gsuite_orgUnitPath": "/Sales",
      "appAccountName": "demo-torii",
      "licenses": [
        {
          "calculatedLastUsageTime": "2021-06-30T01:34:43.000Z",
          "calculatedLicenseFeatureStatus": {
            "reasonType": null,
            "status": "inactive"
          },
          "isLicenseTypePaid": true,
          "lastUsageTime": "2021-06-30T01:34:43.000Z",
          "pricePerUser": null,
          "idExternalLicense": "license",
          "type": "jira-software",
          "calculatedStatus": {
            "reason": "noUsage",
            "ssoSources": null,
            "status": "inactive"
          },
          "name": "Jira Software",
          "lastTimeLicenseFeatureUsed": null,
          "currency": "USD",
          "id": 3,
          "pricePerUserConverted": null,
          "status": "active"
        }
      ],
      "lastVisitTimeV2": "2021-08-31T00:00:00.000Z",
      "externalStatus": "active",
      "isNewUserInApp": false,
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "jumpCloud_department": null,
      "annualCost": null,
      "originFirstName": "Luke",
      "isUserRemovedFromApp": false,
      "scoreV2": 0,
      "lifecycleStatus": "active",
      "numberOfInactiveLicenses": 1,
      "score": 0,
      "onelogin_company": "Demo-Torii",
      "originFullName": "Luke Skywalker",
      "jumpCloud_costCenter": null,
      "idAppAccount": 12023,
      "gsuite_emails": [
        "[email protected]",
        "[email protected]"
      ],
      "isExternal": false,
      "jumpCloud_location": null,
      "okta_id": "00uob6vfgDh6n80ht5d6",
      "annualCostConverted": null,
      "firstName": "Luke",
      "onelogin_department": "Finance",
      "identitySourcesDeletionTime": null,
      "isSupportLastVisit": true,
      "jumpCloud_company": null,
      "isOffboardingIgnored": false,
      "isDeletedInIdentitySources": false,
      "userType": null,
      "originEmail": "[email protected]",
      "onelogin_title": "Associate",
      "status": "active",
      "lastName": "Skywalker",
      "originLastName": "Skywalker",
      "role": null,
      "creationTime": "2021-06-25T01:06:31.000Z",
      "sources": [
        "atlassian",
        "google"
      ],
      "originIdUser": 916706870,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 916706870,
      "photoUrl": null,
      "gsuite_groups": [
        "North America"
      ],
      "lastVisitTime": "2021-08-30T00:00:00.000Z",
      "email": "[email protected]",
      "slack_slackId": "U020NUE5UM8",
      "gsuite_department": "Engineering",
      "okta_creation_date": "2021-05-02T17:59:26.000Z",
      "fullName": "Luke Skywalker",
      "gsuite_orgUnitPath": "/Finance",
      "appAccountName": "demo-torii",
      "licenses": [
        {
          "calculatedLastUsageTime": "2021-06-24T18:24:03.000Z",
          "calculatedLicenseFeatureStatus": {
            "reasonType": null,
            "status": "inactive"
          },
          "isLicenseTypePaid": true,
          "lastUsageTime": "2021-06-24T18:24:03.000Z",
          "pricePerUser": null,
          "idExternalLicense": "license",
          "type": "jira-software",
          "calculatedStatus": {
            "reason": "noUsage",
            "ssoSources": null,
            "status": "inactive"
          },
          "name": "Jira Software",
          "lastTimeLicenseFeatureUsed": null,
          "currency": "USD",
          "id": 3,
          "pricePerUserConverted": null,
          "status": "active"
        }
      ],
      "jumpCloud_jobTile": null,
      "jumpCloud_employeeType": null,
      "lastVisitTimeV2": "2021-08-30T00:00:00.000Z",
      "onelogin_userManager": {
        "firstName": "Torii",
        "lastName": "Demo",
        "photoUrl": "https://avatars.slack-edge.com/2021-04-30/2005593218055_890d98ffeefaf4075fd8_72.png",
        "fullName": "Torii Demo",
        "id": 873786409,
        "email": "[email protected]"
      },
      "externalStatus": "active",
      "isNewUserInApp": false,
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": "wan",
      "annualCost": null,
      "originFirstName": "Obi",
      "originLastName": "wan",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "role": null,
      "lifecycleStatus": "active",
      "creationTime": "2021-07-09T02:26:47.000Z",
      "sources": [
        "atlassian"
      ],
      "originIdUser": 1084925659,
      "numberOfInactiveLicenses": 0,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 1084925659,
      "score": -1,
      "photoUrl": null,
      "lastVisitTime": null,
      "originFullName": "Obi wan",
      "email": "[email protected]",
      "idAppAccount": 12023,
      "isExternal": false,
      "okta_creation_date": "2021-07-08T20:20:59.000Z",
      "fullName": "Obi wan",
      "okta_id": "00u1661snnXlhIyeR5d7",
      "gsuite_orgUnitPath": "/",
      "appAccountName": "demo-torii",
      "annualCostConverted": null,
      "firstName": "Obi",
      "identitySourcesDeletionTime": "2023-02-25T00:51:25.000Z",
      "licenses": [],
      "isSupportLastVisit": true,
      "lastVisitTimeV2": null,
      "isOffboardingIgnored": false,
      "isDeletedInIdentitySources": true,
      "userType": null,
      "externalStatus": "active",
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "annualCost": null,
      "originFirstName": "Inti",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "lifecycleStatus": "offboarding",
      "numberOfInactiveLicenses": 0,
      "score": -1,
      "originFullName": "Inti Test",
      "idAppAccount": 12023,
      "isExternal": false,
      "okta_id": "00u2gpwrxv0FNIFFs5d7",
      "annualCostConverted": null,
      "firstName": "Inti",
      "identitySourcesDeletionTime": "2021-07-12T01:32:34.000Z",
      "isSupportLastVisit": true,
      "isOffboardingIgnored": false,
      "isDeletedInIdentitySources": true,
      "userType": null,
      "originEmail": "[email protected]",
      "status": "active",
      "lastName": "Test",
      "originLastName": "Test",
      "role": null,
      "creationTime": "2021-07-10T02:25:13.000Z",
      "sources": [
        "atlassian"
      ],
      "salesforce_profile_name": "Standard Platform User",
      "originIdUser": 1087843175,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 1087843175,
      "photoUrl": null,
      "lastVisitTime": null,
      "email": "[email protected]",
      "salesforce_userPreferencesLightningExperiencePreferred": "Yes",
      "slack_slackId": "U027U6Q3Z8U",
      "okta_creation_date": "2021-11-01T17:47:52.000Z",
      "fullName": "Inti Test",
      "gsuite_orgUnitPath": "/",
      "appAccountName": "demo-torii",
      "licenses": [],
      "lastVisitTimeV2": null,
      "externalStatus": "active",
      "isNewUserInApp": false,
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": "TestUser1",
      "annualCost": null,
      "originFirstName": "Temp",
      "originLastName": "TestUser1",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "role": null,
      "lifecycleStatus": "active",
      "creationTime": "2021-07-11T02:25:12.000Z",
      "sources": [
        "atlassian"
      ],
      "originIdUser": 1090542200,
      "numberOfInactiveLicenses": 0,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 1090542200,
      "score": -1,
      "photoUrl": null,
      "lastVisitTime": null,
      "originFullName": "Temp TestUser1",
      "email": "[email protected]",
      "idAppAccount": 12023,
      "isExternal": false,
      "okta_creation_date": "2021-07-10T17:43:49.000Z",
      "fullName": "Temp TestUser1",
      "okta_id": "00u16wy42iuMxMXMe5d7",
      "gsuite_orgUnitPath": "/",
      "appAccountName": "demo-torii",
      "annualCostConverted": null,
      "firstName": "Temp",
      "identitySourcesDeletionTime": "2021-07-11T17:06:06.000Z",
      "licenses": [],
      "isSupportLastVisit": true,
      "lastVisitTimeV2": null,
      "isOffboardingIgnored": false,
      "isDeletedInIdentitySources": true,
      "userType": null,
      "externalStatus": "active",
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": "Test",
      "annualCost": null,
      "originFirstName": "Test",
      "originLastName": "Test",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "role": null,
      "lifecycleStatus": "active",
      "creationTime": "2021-07-11T02:25:12.000Z",
      "sources": [
        "atlassian"
      ],
      "originIdUser": 1090542284,
      "numberOfInactiveLicenses": 0,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 1090542284,
      "score": -1,
      "photoUrl": null,
      "lastVisitTime": null,
      "originFullName": "Test Test",
      "email": "[email protected]",
      "idAppAccount": 12023,
      "isExternal": false,
      "okta_creation_date": "2021-07-10T18:43:17.000Z",
      "fullName": "Test Test",
      "okta_id": "00u16xk5l13V7HNAq5d7",
      "gsuite_orgUnitPath": "/",
      "appAccountName": "demo-torii",
      "annualCostConverted": null,
      "firstName": "Test",
      "identitySourcesDeletionTime": "2021-07-11T16:36:58.000Z",
      "licenses": [],
      "isSupportLastVisit": true,
      "lastVisitTimeV2": null,
      "isOffboardingIgnored": false,
      "isDeletedInIdentitySources": true,
      "userType": null,
      "externalStatus": "active",
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": "TestUser3",
      "annualCost": null,
      "originFirstName": "Temp",
      "originLastName": "TestUser3",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "role": null,
      "lifecycleStatus": "active",
      "creationTime": "2021-07-12T02:25:16.000Z",
      "sources": [
        "atlassian"
      ],
      "originIdUser": 1093266061,
      "numberOfInactiveLicenses": 0,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 1093266061,
      "score": -1,
      "photoUrl": null,
      "lastVisitTime": null,
      "originFullName": "Temp TestUser3",
      "email": "[email protected]",
      "idAppAccount": 12023,
      "isExternal": false,
      "okta_creation_date": "2021-07-11T17:02:10.000Z",
      "fullName": "Temp TestUser3",
      "okta_id": "00u177knhs96f0eqP5d7",
      "gsuite_orgUnitPath": "/",
      "appAccountName": "demo-torii",
      "annualCostConverted": null,
      "firstName": "Temp",
      "identitySourcesDeletionTime": "2021-07-11T19:15:43.000Z",
      "licenses": [],
      "isSupportLastVisit": true,
      "lastVisitTimeV2": null,
      "isOffboardingIgnored": false,
      "isDeletedInIdentitySources": true,
      "userType": null,
      "externalStatus": "active",
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": "Russo",
      "annualCost": null,
      "originFirstName": "Chewbacca",
      "originLastName": "Russo",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "role": null,
      "lifecycleStatus": "active",
      "creationTime": "2021-07-27T02:25:36.000Z",
      "sources": [
        "atlassian"
      ],
      "originIdUser": 1136758709,
      "numberOfInactiveLicenses": 0,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 1136758709,
      "score": -1,
      "photoUrl": null,
      "lastVisitTime": null,
      "originFullName": "Chewbacca Russo",
      "email": "[email protected]",
      "idAppAccount": 12023,
      "isExternal": false,
      "okta_creation_date": "2021-07-26T18:42:23.000Z",
      "fullName": "Chewbacca Russo",
      "okta_id": "00u1bzoelr3aaf87a5d7",
      "gsuite_orgUnitPath": "/",
      "appAccountName": "demo-torii",
      "annualCostConverted": null,
      "firstName": "Chewbacca",
      "identitySourcesDeletionTime": "2022-02-04T20:24:31.000Z",
      "licenses": [],
      "isSupportLastVisit": true,
      "lastVisitTimeV2": null,
      "isOffboardingIgnored": false,
      "isDeletedInIdentitySources": true,
      "userType": null,
      "externalStatus": "active",
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": "C3PO",
      "annualCost": null,
      "originFirstName": "C3PO",
      "originLastName": "C3PO",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "role": null,
      "lifecycleStatus": "active",
      "creationTime": "2021-07-27T02:25:36.000Z",
      "sources": [
        "atlassian"
      ],
      "originIdUser": 1136758710,
      "numberOfInactiveLicenses": 0,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 1136758710,
      "score": -1,
      "photoUrl": null,
      "lastVisitTime": null,
      "originFullName": "C3PO C3PO",
      "email": "[email protected]",
      "idAppAccount": 12023,
      "isExternal": false,
      "okta_creation_date": "2021-07-26T18:38:41.000Z",
      "fullName": "C3PO C3PO",
      "okta_id": "00u1bzkdjvYhF9uF95d7",
      "gsuite_orgUnitPath": "/",
      "appAccountName": "demo-torii",
      "annualCostConverted": null,
      "firstName": "C3PO",
      "identitySourcesDeletionTime": "2023-02-25T00:51:25.000Z",
      "licenses": [],
      "isSupportLastVisit": true,
      "lastVisitTimeV2": null,
      "isOffboardingIgnored": false,
      "isDeletedInIdentitySources": true,
      "userType": null,
      "externalStatus": "active",
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "annualCost": null,
      "originFirstName": "Yoda",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "lifecycleStatus": "active",
      "numberOfInactiveLicenses": 0,
      "score": -1,
      "bamboohr_zipcode": "94010",
      "originFullName": "Yoda Baby",
      "idAppAccount": 12023,
      "gsuite_emails": [
        "[email protected]",
        "[email protected]",
        "[email protected]"
      ],
      "isExternal": false,
      "okta_id": "00uq0u5a7FHuss2v55d6",
      "hubspot_primary_team": "Sales & Marketing",
      "annualCostConverted": null,
      "firstName": "Yoda",
      "bamboohr_city": "Space",
      "identitySourcesDeletionTime": null,
      "isSupportLastVisit": true,
      "isOffboardingIgnored": false,
      "isDeletedInIdentitySources": false,
      "userType": null,
      "originEmail": "[email protected]",
      "status": "active",
      "lastName": "Baby",
      "originLastName": "Baby",
      "role": null,
      "creationTime": "2021-06-25T21:43:41.000Z",
      "sources": [
        "atlassian"
      ],
      "originIdUser": 937146029,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 937146029,
      "photoUrl": null,
      "lastVisitTime": null,
      "email": "[email protected]",
      "gsuite_department": "Finance",
      "okta_creation_date": "2021-05-11T17:04:03.000Z",
      "fullName": "Yoda Baby",
      "gsuite_orgUnitPath": "/",
      "appAccountName": "demo-torii",
      "bamboohr_country": "United States",
      "licenses": [],
      "lastVisitTimeV2": null,
      "externalStatus": "active",
      "bamboohr_hireDate": "2021-05-26",
      "isNewUserInApp": false,
      "isOwnerNotifiedToRemoveUser": false
    }
      ]
    },
    {
      "id": 30,
      "name": "Box",
      "owner": null,
      "users": [
        {
      "lastName": "Brown",
      "annualCost": null,
      "originFirstName": "Charlie",
      "originLastName": "Brown",
      "role": "coadmin",
      "isUserRemovedFromApp": false,
      "scoreV2": 0,
      "creationTime": "2021-04-23T23:24:33.000Z",
      "sources": [
        "box",
        "okta"
      ],
      "lifecycleStatus": "active",
      "okta_title": "Company Manager",
      "originIdUser": 878387511,
      "numberOfInactiveLicenses": 1,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 878387511,
      "score": 0,
      "photoUrl": null,
      "lastVisitTime": "2021-04-23T00:00:00.000Z",
      "originFullName": "Charlie Brown",
      "email": "[email protected]",
      "idAppAccount": 11137,
      "isExternal": true,
      "fullName": "Charlie Brown",
      "appAccountName": "Okta Khalid Test",
      "annualCostConverted": null,
      "firstName": "Charlie",
      "licenses": [
        {
          "calculatedLastUsageTime": "2021-04-23T00:00:00.000Z",
          "calculatedLicenseFeatureStatus": {
            "reasonType": null,
            "status": "inactive"
          },
          "isLicenseTypePaid": true,
          "lastUsageTime": null,
          "pricePerUser": null,
          "idExternalLicense": "license",
          "type": "box",
          "calculatedStatus": {
            "reason": "noUsage",
            "ssoSources": null,
            "status": "inactive"
          },
          "name": "Box",
          "lastTimeLicenseFeatureUsed": null,
          "currency": "USD",
          "id": 8146,
          "pricePerUserConverted": null,
          "status": "active"
        }
      ],
      "identitySourcesDeletionTime": null,
      "isSupportLastVisit": false,
      "lastVisitTimeV2": "2021-04-23T00:00:00.000Z",
      "isOffboardingIgnored": false,
      "okta_department": "Sales",
      "externalStatus": "active",
      "isDeletedInIdentitySources": false,
      "userType": null,
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": null,
      "annualCost": null,
      "originFirstName": "SK",
      "originLastName": null,
      "role": "admin",
      "isUserRemovedFromApp": false,
      "scoreV2": 0,
      "creationTime": "2021-04-23T23:36:01.000Z",
      "sources": [
        "box"
      ],
      "lifecycleStatus": "offboarding",
      "originIdUser": 884809710,
      "numberOfInactiveLicenses": 1,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 884809710,
      "score": 0,
      "photoUrl": null,
      "lastVisitTime": "2021-04-23T00:00:00.000Z",
      "originFullName": "SK",
      "email": "[email protected]",
      "idAppAccount": 11139,
      "isExternal": true,
      "fullName": "SK",
      "gsuite_orgUnitPath": "/",
      "appAccountName": "Shahbaz Demo Box",
      "annualCostConverted": null,
      "firstName": "SK",
      "licenses": [
        {
          "calculatedLastUsageTime": "2021-04-23T00:00:00.000Z",
          "calculatedLicenseFeatureStatus": {
            "reasonType": null,
            "status": "inactive"
          },
          "isLicenseTypePaid": true,
          "lastUsageTime": null,
          "pricePerUser": null,
          "idExternalLicense": "license",
          "type": "box",
          "calculatedStatus": {
            "reason": "noUsage",
            "ssoSources": null,
            "status": "inactive"
          },
          "name": "Box",
          "lastTimeLicenseFeatureUsed": null,
          "currency": "USD",
          "id": 8146,
          "pricePerUserConverted": null,
          "status": "active"
        }
      ],
      "identitySourcesDeletionTime": null,
      "isSupportLastVisit": false,
      "lastVisitTimeV2": "2021-04-23T00:00:00.000Z",
      "isOffboardingIgnored": false,
      "externalStatus": "active",
      "isDeletedInIdentitySources": false,
      "userType": null,
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "annualCost": null,
      "originFirstName": "Charlie",
      "isUserRemovedFromApp": false,
      "scoreV2": 0,
      "lifecycleStatus": "active",
      "bamboohr_department": "Finance",
      "numberOfInactiveLicenses": 1,
      "score": 0,
      "bamboohr_userManager": {
        "firstName": "Sam",
        "lastName": "Khalid",
        "photoUrl": null,
        "fullName": "Sam Khalid",
        "id": 884809710,
        "email": "[email protected]"
      },
      "bamboohr_zipcode": "12345",
      "originFullName": "Charlie Demo",
      "idAppAccount": 11137,
      "isExternal": true,
      "bamboohr_jobTitle": "Financial Advisor",
      "okta_id": "00uyxhwi7xvYKLFue0h7",
      "annualCostConverted": null,
      "firstName": "Charlie",
      "bamboohr_city": "Dallas",
      "identitySourcesDeletionTime": null,
      "isSupportLastVisit": false,
      "isOffboardingIgnored": false,
      "isDeletedInIdentitySources": false,
      "userType": null,
      "originEmail": "[email protected]",
      "status": "active",
      "lastName": "Demo",
      "originLastName": "Demo",
      "role": "coadmin",
      "creationTime": "2021-04-23T23:22:04.000Z",
      "sources": [
        "box",
        "extension"
      ],
      "originIdUser": 884809719,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 884809719,
      "photoUrl": null,
      "lastVisitTime": "2021-04-23T00:00:00.000Z",
      "email": "[email protected]",
      "okta_creation_date": "2021-04-30T00:23:14.000Z",
      "fullName": "Charlie Demo",
      "gsuite_orgUnitPath": "/",
      "appAccountName": "Okta Khalid Test",
      "bamboohr_country": "United States",
      "licenses": [
        {
          "calculatedLastUsageTime": "2021-04-23T00:00:00.000Z",
          "calculatedLicenseFeatureStatus": {
            "reasonType": null,
            "status": "inactive"
          },
          "isLicenseTypePaid": true,
          "lastUsageTime": null,
          "pricePerUser": null,
          "idExternalLicense": "license",
          "type": "box",
          "calculatedStatus": {
            "reason": "noUsage",
            "ssoSources": null,
            "status": "inactive"
          },
          "name": "Box",
          "lastTimeLicenseFeatureUsed": null,
          "currency": "USD",
          "id": 8146,
          "pricePerUserConverted": null,
          "status": "active"
        }
      ],
      "bamboohr_effectiveDate": "2021-04-30",
      "bamboohr_state": "Texas",
      "lastVisitTimeV2": "2021-04-23T00:00:00.000Z",
      "externalStatus": "active",
      "bamboohr_division": "North AMerica",
      "bamboohr_hireDate": "2021-04-30",
      "isNewUserInApp": false,
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": "Khalid",
      "annualCost": null,
      "originFirstName": "Shahbaz",
      "originLastName": "Khalid",
      "role": "admin",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "creationTime": "2021-04-23T23:24:33.000Z",
      "sources": [
        "box"
      ],
      "lifecycleStatus": "active",
      "originIdUser": 878387513,
      "numberOfInactiveLicenses": 0,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 878387513,
      "score": -1,
      "photoUrl": null,
      "lastVisitTime": null,
      "originFullName": "Shahbaz Khalid",
      "email": "[email protected]",
      "idAppAccount": 11137,
      "isExternal": true,
      "okta_creation_date": "2017-12-15T23:26:20.000Z",
      "fullName": "Shahbaz Khalid",
      "okta_id": "00udaezlztnAF2ywS0h7",
      "appAccountName": "Okta Khalid Test",
      "annualCostConverted": null,
      "firstName": "Shahbaz",
      "licenses": [
        {
          "calculatedLastUsageTime": null,
          "calculatedLicenseFeatureStatus": {
            "reasonType": null,
            "status": "inactive"
          },
          "isLicenseTypePaid": true,
          "lastUsageTime": null,
          "pricePerUser": null,
          "idExternalLicense": "license",
          "type": "box",
          "calculatedStatus": {
            "reason": null,
            "ssoSources": null,
            "status": "active"
          },
          "name": "Box",
          "lastTimeLicenseFeatureUsed": null,
          "currency": "USD",
          "id": 8146,
          "pricePerUserConverted": null,
          "status": "active"
        }
      ],
      "identitySourcesDeletionTime": null,
      "isSupportLastVisit": false,
      "lastVisitTimeV2": null,
      "isOffboardingIgnored": false,
      "externalStatus": "active",
      "isDeletedInIdentitySources": false,
      "userType": null,
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": "Green",
      "annualCost": null,
      "originFirstName": "Bill",
      "originLastName": "Green",
      "role": "user",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "creationTime": "2021-04-23T23:24:33.000Z",
      "sources": [
        "box"
      ],
      "lifecycleStatus": "active",
      "okta_title": "Account Manager",
      "originIdUser": 878387514,
      "numberOfInactiveLicenses": 0,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 878387514,
      "score": -1,
      "photoUrl": null,
      "lastVisitTime": null,
      "originFullName": "Bill Green",
      "email": "[email protected]",
      "idAppAccount": 11137,
      "isExternal": true,
      "fullName": "Bill Green",
      "appAccountName": "Okta Khalid Test",
      "annualCostConverted": null,
      "firstName": "Bill",
      "licenses": [
        {
          "calculatedLastUsageTime": null,
          "calculatedLicenseFeatureStatus": {
            "reasonType": null,
            "status": "inactive"
          },
          "isLicenseTypePaid": true,
          "lastUsageTime": null,
          "pricePerUser": null,
          "idExternalLicense": "license",
          "type": "box",
          "calculatedStatus": {
            "reason": null,
            "ssoSources": null,
            "status": "active"
          },
          "name": "Box",
          "lastTimeLicenseFeatureUsed": null,
          "currency": "USD",
          "id": 8146,
          "pricePerUserConverted": null,
          "status": "active"
        }
      ],
      "identitySourcesDeletionTime": null,
      "isSupportLastVisit": false,
      "lastVisitTimeV2": null,
      "isOffboardingIgnored": false,
      "okta_department": "Customer Support",
      "externalStatus": "active",
      "isDeletedInIdentitySources": false,
      "userType": null,
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": null,
      "annualCost": null,
      "originFirstName": "baazshah",
      "originLastName": null,
      "role": "user",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "creationTime": "2021-04-23T23:24:33.000Z",
      "sources": [
        "box"
      ],
      "lifecycleStatus": "active",
      "originIdUser": 896370245,
      "numberOfInactiveLicenses": 0,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 896370245,
      "score": -1,
      "photoUrl": null,
      "lastVisitTime": null,
      "originFullName": "baazshah",
      "email": "[email protected]",
      "idAppAccount": 11137,
      "isExternal": true,
      "fullName": "baazshah",
      "appAccountName": "Okta Khalid Test",
      "annualCostConverted": null,
      "firstName": "baazshah",
      "licenses": [
        {
          "calculatedLastUsageTime": null,
          "calculatedLicenseFeatureStatus": {
            "reasonType": null,
            "status": "inactive"
          },
          "isLicenseTypePaid": true,
          "lastUsageTime": null,
          "pricePerUser": null,
          "idExternalLicense": "license",
          "type": "box",
          "calculatedStatus": {
            "reason": null,
            "ssoSources": null,
            "status": "active"
          },
          "name": "Box",
          "lastTimeLicenseFeatureUsed": null,
          "currency": "USD",
          "id": 8146,
          "pricePerUserConverted": null,
          "status": "active"
        }
      ],
      "identitySourcesDeletionTime": null,
      "isSupportLastVisit": false,
      "lastVisitTimeV2": null,
      "isOffboardingIgnored": false,
      "externalStatus": "active",
      "isDeletedInIdentitySources": false,
      "userType": null,
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": "Blue",
      "annualCost": null,
      "originFirstName": "Barbara",
      "originLastName": "Blue",
      "role": "user",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "creationTime": "2021-04-23T23:24:33.000Z",
      "sources": [
        "box"
      ],
      "lifecycleStatus": "active",
      "originIdUser": 896370246,
      "numberOfInactiveLicenses": 0,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 896370246,
      "score": -1,
      "photoUrl": null,
      "lastVisitTime": null,
      "originFullName": "Barbara Blue",
      "email": "[email protected]",
      "idAppAccount": 11137,
      "isExternal": true,
      "fullName": "Barbara Blue",
      "appAccountName": "Okta Khalid Test",
      "annualCostConverted": null,
      "firstName": "Barbara",
      "licenses": [
        {
          "calculatedLastUsageTime": null,
          "calculatedLicenseFeatureStatus": {
            "reasonType": null,
            "status": "inactive"
          },
          "isLicenseTypePaid": true,
          "lastUsageTime": null,
          "pricePerUser": null,
          "idExternalLicense": "license",
          "type": "box",
          "calculatedStatus": {
            "reason": null,
            "ssoSources": null,
            "status": "active"
          },
          "name": "Box",
          "lastTimeLicenseFeatureUsed": null,
          "currency": "USD",
          "id": 8146,
          "pricePerUserConverted": null,
          "status": "active"
        }
      ],
      "identitySourcesDeletionTime": null,
      "isSupportLastVisit": false,
      "lastVisitTimeV2": null,
      "isOffboardingIgnored": false,
      "externalStatus": "active",
      "isDeletedInIdentitySources": false,
      "userType": null,
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": "Blue",
      "annualCost": null,
      "originFirstName": "Barbara",
      "originLastName": "Blue",
      "role": "user",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "creationTime": "2021-04-23T23:24:33.000Z",
      "sources": [
        "box"
      ],
      "lifecycleStatus": "active",
      "originIdUser": 896370247,
      "numberOfInactiveLicenses": 0,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 896370247,
      "score": -1,
      "photoUrl": null,
      "lastVisitTime": null,
      "originFullName": "Barbara Blue",
      "email": "[email protected]",
      "idAppAccount": 11137,
      "isExternal": true,
      "fullName": "Barbara Blue",
      "appAccountName": "Okta Khalid Test",
      "annualCostConverted": null,
      "firstName": "Barbara",
      "licenses": [
        {
          "calculatedLastUsageTime": null,
          "calculatedLicenseFeatureStatus": {
            "reasonType": null,
            "status": "inactive"
          },
          "isLicenseTypePaid": true,
          "lastUsageTime": null,
          "pricePerUser": null,
          "idExternalLicense": "license",
          "type": "box",
          "calculatedStatus": {
            "reason": null,
            "ssoSources": null,
            "status": "active"
          },
          "name": "Box",
          "lastTimeLicenseFeatureUsed": null,
          "currency": "USD",
          "id": 8146,
          "pricePerUserConverted": null,
          "status": "active"
        }
      ],
      "identitySourcesDeletionTime": null,
      "isSupportLastVisit": false,
      "lastVisitTimeV2": null,
      "isOffboardingIgnored": false,
      "externalStatus": "active",
      "isDeletedInIdentitySources": false,
      "userType": null,
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": "Brown",
      "annualCost": null,
      "originFirstName": "Charlie",
      "originLastName": "Brown",
      "role": "coadmin",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "creationTime": "2021-04-23T23:24:33.000Z",
      "sources": [
        "box"
      ],
      "lifecycleStatus": "active",
      "originIdUser": 896370248,
      "numberOfInactiveLicenses": 0,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 896370248,
      "score": -1,
      "photoUrl": null,
      "lastVisitTime": null,
      "originFullName": "Charlie Brown",
      "email": "[email protected]",
      "idAppAccount": 11137,
      "isExternal": true,
      "fullName": "Charlie Brown",
      "appAccountName": "Okta Khalid Test",
      "annualCostConverted": null,
      "firstName": "Charlie",
      "licenses": [
        {
          "calculatedLastUsageTime": null,
          "calculatedLicenseFeatureStatus": {
            "reasonType": null,
            "status": "inactive"
          },
          "isLicenseTypePaid": true,
          "lastUsageTime": null,
          "pricePerUser": null,
          "idExternalLicense": "license",
          "type": "box",
          "calculatedStatus": {
            "reason": null,
            "ssoSources": null,
            "status": "active"
          },
          "name": "Box",
          "lastTimeLicenseFeatureUsed": null,
          "currency": "USD",
          "id": 8146,
          "pricePerUserConverted": null,
          "status": "active"
        }
      ],
      "identitySourcesDeletionTime": null,
      "isSupportLastVisit": false,
      "lastVisitTimeV2": null,
      "isOffboardingIgnored": false,
      "externalStatus": "active",
      "isDeletedInIdentitySources": false,
      "userType": null,
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": "Grey",
      "annualCost": null,
      "originFirstName": "Gary",
      "originLastName": "Grey",
      "role": "user",
      "isUserRemovedFromApp": false,
      "scoreV2": -1,
      "creationTime": "2021-04-23T23:24:33.000Z",
      "sources": [
        "box"
      ],
      "lifecycleStatus": "active",
      "originIdUser": 896370249,
      "numberOfInactiveLicenses": 0,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 896370249,
      "score": -1,
      "photoUrl": null,
      "lastVisitTime": null,
      "originFullName": "Gary Grey",
      "email": "[email protected]",
      "idAppAccount": 11137,
      "isExternal": true,
      "fullName": "Gary Grey",
      "appAccountName": "Okta Khalid Test",
      "annualCostConverted": null,
      "firstName": "Gary",
      "licenses": [
        {
          "calculatedLastUsageTime": null,
          "calculatedLicenseFeatureStatus": {
            "reasonType": null,
            "status": "inactive"
          },
          "isLicenseTypePaid": true,
          "lastUsageTime": null,
          "pricePerUser": null,
          "idExternalLicense": "license",
          "type": "box",
          "calculatedStatus": {
            "reason": null,
            "ssoSources": null,
            "status": "active"
          },
          "name": "Box",
          "lastTimeLicenseFeatureUsed": null,
          "currency": "USD",
          "id": 8146,
          "pricePerUserConverted": null,
          "status": "active"
        }
      ],
      "identitySourcesDeletionTime": null,
      "isSupportLastVisit": false,
      "lastVisitTimeV2": null,
      "isOffboardingIgnored": false,
      "externalStatus": "active",
      "isDeletedInIdentitySources": false,
      "userType": null,
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "active",
      "isOwnerNotifiedToRemoveUser": false
    },
        {
      "lastName": null,
      "annualCost": null,
      "originFirstName": "tuser",
      "originLastName": null,
      "role": null,
      "isUserRemovedFromApp": true,
      "scoreV2": -1,
      "creationTime": "2021-04-23T23:24:33.000Z",
      "sources": [
        "box"
      ],
      "lifecycleStatus": "offboarded",
      "originIdUser": 896370250,
      "numberOfInactiveLicenses": 0,
      "ignoreAccount": false,
      "creationTimeInApp": null,
      "idUser": 896370250,
      "score": -1,
      "photoUrl": null,
      "lastVisitTime": null,
      "originFullName": "tuser",
      "email": "[email protected]",
      "idAppAccount": 11137,
      "isExternal": true,
      "fullName": "tuser",
      "appAccountName": "Okta Khalid Test",
      "annualCostConverted": null,
      "firstName": "tuser",
      "licenses": [],
      "identitySourcesDeletionTime": null,
      "isSupportLastVisit": false,
      "lastVisitTimeV2": null,
      "isOffboardingIgnored": false,
      "externalStatus": "No longer in app",
      "isDeletedInIdentitySources": false,
      "userType": null,
      "isNewUserInApp": false,
      "originEmail": "[email protected]",
      "status": "deleted",
      "isOwnerNotifiedToRemoveUser": false
    }
      ]
    }
  ]
}