Smartsheet
  • 05 Jul 2023
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Smartsheet

  • Dark
    Light
  • PDF

Article Summary

Smartsheet is a cloud-based work management platform that empowers collaboration, drives better decision making, and accelerates innovation.

Types of Assets Fetched

This adapter fetches the following types of assets:

  • Users
  • SaaS data

Parameters

  1. Authentication Method - Select API Token or OAuth2 as your method for authentication.

  2. Token (when API Token is selected as authentication method) - The access token created for the Axonius application.

  3. Application Client ID and Application Client Secret (when OAuth2 is selected as authentication method) - The OAuth Client ID and Client Secret for OAuth access to Smartsheet. For more information, see Request an Authorization Code.

  4. Refresh Token (when OAuth2 is selected as authentication method) - When using the OAuth method of authentication, enter the value of the Refresh Token issued by a Smartsheet instance. For more information, see Get or Refresh an Access Token.

  5. Username and Password (only for accounts with SaaS Management capability) - The user credentials of the user created for fetching SaaS data.

  6. 2FA Secret Key- (only for accounts with SaaS Management capability) - If you access Slack through an SSO solution that requires multi-factor authentication, you will need to generate a secret key in that solution and paste it here. See instructions for performing this action in Okta.

  7. Verify SSL - Select to verify the SSL certificate offered by the value supplied in Host Name or IP Address. For more details, see SSL Trust & CA Settings.

  8. HTTPS Proxy (optional) - A proxy to use when connecting to the value supplied in Host Name or IP Address.

  9. HTTPS Proxy User Name (optional) - The user name to use when connecting to the value supplied in Host Name or IP Address via the value supplied in HTTPS Proxy.

  10. HTTPS Proxy Password (optional) - The password to use when connecting to the value supplied in Host Name or IP Address via the value supplied in HTTPS Proxy.

To learn more about common adapter connection parameters and buttons, see Adding a New Adapter Connection.

Advanced Settings

Note:

Advanced settings can either apply for all connections for this adapter, or you can set different advanced settings and/or different scheduling for a specific connection, refer to ​Advanced Configuration for Adapters

  • Fetch Group Data -Select this option to fetch group data for Smartsheet users.

APIs

Axonius uses the Smartsheet API.

Required Permissions

While to access SaaS data you need to grant roles and/or permissions that include write capabilities, the adapter only actually reads data from the application.

if using Oauth2 flow, the required SCOPE for Request an Authorization Code is READ_USERS.

The username and password you create for fetching SaaS data, must have administrator permissions.

Setting Up the Integration

To successfully connect this adapter, you need to create a user account and an application access token by completing the following steps:

  1. Create a user account
  2. Create an application access token

Create a User Account

Note:

This process is only needed for retrieving SaaS data.
If single-sign-on is enabled and the 'Email + Password option' is disabled, then it is recommended to derive the username and password from a user account maintained by the SSO solution.

  • It is recommended for the username and password to be derived from a newly created user account dedicated for the usage of Axonius. Retrieve the username and password from that user account.
  • The password length should be at least 32 characters.
  • The System Licensed User role should be disabled and the System Admin role needs to be enabled.

Create an Application Access Token

Note:

This process is only needed if API Token is selected as the authentication method

The application access token needs to be derived from the newly create user account.

  1. Login to Smartsheet as the user.
  2. Click the user's avatar and select Personal Settings.
  3. Navigate to API Access and generate a new access token.
  4. Copy and save the token.
  5. In Axonius, paste the copied token in the Token field.



Was this article helpful?

What's Next
Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.