Set up a Smartsheet connector

Capabilities

Resource	Sync	Provision
Account
Group

Additional functionality: None.

Gather Smartsheet configuration information

Configuring the connector requires you to pass in information from Smartsheet. Gather these configuration details before you move on. Here’s the information you’ll need:

Base URL
Access Token

See the Smartsheet docs for information on how to acquire credentials: View the documentation

Configure the Smartsheet connector

To complete this task, you’ll need:

The Connector Administrator or Super Administrator role in C1
Access to the set of Smartsheet configuration information gathered by following the instructions above

Cloud-hosted
Self-hosted

Follow these instructions to use a built-in, no-code connector hosted by C1.

In C1, navigate to Apps > Connectors and click Add connector.

Search for Smartsheet and click Add.

Choose where to add the connector: Create a new app, or Add to an existing app (then select the app).If you’re creating a new app, choose whether to link it to an application discovered from your identity provider: select Yes and pick the IdP application, or No to continue with just the connector.

Set the connector’s Name and, optionally, a Description.

Click the pencil icon next to Owners to choose who can configure and manage this connector.

Click Add. The connector is created and its configuration page opens.

Find the Settings area of the page and click Edit.

Enter the configuration information from the previous section.

Click Save.

The connector’s label changes to Syncing, followed by Connected. You can view the logs to ensure that information is syncing.

Done. Your Smartsheet connector is now pulling access data into C1.

Follow these instructions to use the Smartsheet connector, hosted and run in your own environment.When running in service mode on Kubernetes, a self-hosted connector maintains an ongoing connection with C1, automatically syncing and uploading data at regular intervals. This data is immediately available in the C1 UI for access reviews and access requests.

Resources

Official download center: For stable binaries (Windows/Linux/macOS) and container images.

Step 1: Set up a new Smartsheet connector

In C1, navigate to Apps > Connectors and click Add connector.

Search for Baton and click Add.

Set the connector’s Name and, optionally, a Description.

Click the pencil icon next to Owners to choose who can configure and manage this connector.

Click Add. The connector is created and its configuration page opens.

In the Settings area of the page, click Edit.

Click Rotate to generate a new Client ID and Secret.Carefully copy and save these credentials. We’ll use them in Step 2.

Step 2: Create Kubernetes configuration files

Create two Kubernetes manifest files for your Smartsheet connector deployment:

Secrets configuration

# baton-smartsheet-secrets.yaml
apiVersion: v1
kind: Secret
metadata:
  name: baton-smartsheet-secrets
type: Opaque
stringData:
  # C1 credentials
  BATON_CLIENT_ID: <C1 client ID>
  BATON_CLIENT_SECRET: <C1 client secret>

  # Smartsheet config
  BATON_SMARTSHEET_BASE_URL: <Smartsheet Base URL. See https://developers.smartsheet.com/api/smartsheet/introduction#base-url>
  BATON_SMARTSHEET_TOKEN: <Smartsheet Access Token>

See the connector’s README or run --help to see all available configuration flags and environment variables.

Deployment configuration

# baton-smartsheet.yaml
apiVersion: apps/v1
kind: Deployment
metadata:
  name: baton-smartsheet
  labels:
    app: baton-smartsheet
spec:
  selector:
    matchLabels:
      app: baton-smartsheet
  template:
    metadata:
      labels:
        app: baton-smartsheet
        baton: true
        baton-app: smartsheet
    spec:
      containers:
      - name: baton-smartsheet
        image: public.ecr.aws/conductorone/baton-smartsheet:latest
        imagePullPolicy: IfNotPresent
        env:
        - name: BATON_HOST_ID
          value: baton-smartsheet
        envFrom:
        - secretRef:
            name: baton-smartsheet-secrets

Step 3: Deploy the connector

Create a namespace in which to run C1 connectors (if desired), then apply the secret config and deployment config files.

Check that the connector data uploaded correctly. In C1, click Apps. On the Managed apps tab, locate and click the name of the application you added the smartsheet connector to. smartsheet data should be found on the Entitlements and Accounts tabs.

Done. Your Smartsheet connector is now pulling access data into C1.

Welcome

Manage connectors

Deploy connectors

Upload connector data

Configurable connectors

Pre-built connectors

Set up a Smartsheet connector

Capabilities

Gather Smartsheet configuration information

Configure the Smartsheet connector

Resources

Step 1: Set up a new Smartsheet connector

Step 2: Create Kubernetes configuration files

Secrets configuration

Deployment configuration

Step 3: Deploy the connector

​Capabilities

​Gather Smartsheet configuration information

​Configure the Smartsheet connector

​Resources

​Step 1: Set up a new Smartsheet connector

​Step 2: Create Kubernetes configuration files

​Secrets configuration

​Deployment configuration

​Step 3: Deploy the connector

Capabilities

Gather Smartsheet configuration information

Configure the Smartsheet connector

Resources

Step 1: Set up a new Smartsheet connector

Step 2: Create Kubernetes configuration files

Secrets configuration

Deployment configuration

Step 3: Deploy the connector