Many of Sigma’s API endpoints require a unique identifier (id) for a target object (e.g. organizationId, connectionId, workbookId). This article will point you to where you can find these ids based on the object type.
 

Summary of Content

Requirements
Find your Organization’s Id
Find a Connection Id
Find a Dataset Id
Find a Workbook Id
Find a Workbook Element Id
Find a Member Id
Find a Team Id
Related Resources

Requirements

  • Organization and member ids can only be accessed through Sigma’s API. A user must authenticate with the API. The authenticated user must also have permission to access the requested data.
  • All other ids can be accessed when logged into the Sigma application. The logged in user must also have permission to access the object.

Find Your Organization’s Id

In Sigma

An organization id cannot be identified directly from the Sigma application.

In the API

When using Sigma’s API, the organization that the current authenticated user belongs to can be identified using the API’s WhoAmI endpoint.

Find a Connection Id

In Sigma

A connection id can be identified from the individual connection’s page in Sigma. This is only accessible to organization members with access to the entire connection. To look up a connection Id:

  1. Open your Sigma home page.
  2. Select a connection from the left navigation panel.

This will open the connection page.

  1. The connection id will be included in the URL.
    The connection name and id are separated by a dash (-).
    Structure:
    https://app.sigmacomputing.com/<company-url>/s/<connection-name>-<connection-id>
    Example:
    https://app.sigmacomputing.com/my-company/s/Connection-Root-mtVQZuY2C78qStSyBE64y

In the API

Unknown connection ids cannot be accessed from the API. 

Find a Dataset Id

In Sigma

A dataset id can be identified from the individual dataset’s page in Sigma. To look up a dataset Id:

  1. Open the dataset.
  2. The dataset id will be included in the URL.
    Structure:
    https://app.sigmacomputing.com/<company-url>/b/<dataset-name>-<dataset-id>/...
    Example:
    https://app.sigmacomputing.com/my-company/b/Salesforce-Campaigns-23PiCBrgchwHc3g323Aiy

In the API

A complete list of datasets, including their ids, can be accessed from the dataset endpoint.

Find a Workbook Id

In Sigma

A workbook id can be identified from the individual dataset’s page in Sigma. To look up a workbook Id:

  1. Open the workbook.
  2. The workbook id will be included in the URL.
    Structure:
    https://app.sigmacomputing.com/<company-url>/workbook/<workbook-name>-<workbook-id>/...
    Example:
    https://app.sigmacomputing.com/my-company/workbook/My-Workbook-7sYWojYnccxJqdqkNKAw6S?:draftId=72c0acd6-4803-4766-b322-7dd05c4a445d

In the API

A complete list of datasets, including their ids, can be accessed from the workbook endpoint.

Find a Workbook Element Id

In Sigma

A workbook element’s id can be identified when the workbook is open and the element is selected. To look up a workbook element id:

  1. Open the workbook.
  2. Click to select the element. 
  3. The element id will be included in the URL as an “inodeId.”
    Structure:
    https://app.sigmacomputing.com/<company-url>/workbook/<workbook-name>-<workbook-id>?:nodeId=<element-id>
    Example:
    https://app.sigmacomputing.com/my-company/workbook/My-Workbook-7sYWojYnccxJqdqkNKAw6S?:nodeId=Mkaex5leIGcjlkQa5PqEw

 

In the API

Workbook element ids can be found nested within in a success response from the workbook schema endpoint

Find a Member Id

In Sigma

Member ids cannot be identified directly from the Sigma application.

In the API

When using Sigma’s API, the memberId belonging to the current authenticated user can be identified using the API’s WhoAmI endpoint. A complete list of organization members, including their ids, can be accessed from the members endpoint.

Find a Team Id

In Sigma

A team id can be identified in Sigma via the Admin Portal. This is only accessible to organization members with team administration permissions. To look up a team Id:

  1. Open the Admin Portal.
  2. Select the Teams Page from the left panel.
  3. Click a team in the list to select it.
  4. The team id will be included in the URL.
    Structure:
    https://app.sigmacomputing.com/<company-url>/admin/teams/<team-id>
    Example:
    https://app.sigmacomputing.com/my-company/admin/teams/87659652-5289-4225-95cQ-4b75T3268bEn

In the API

A complete list of teams, including their ids, can be accessed from the team endpoint.

 

Related Resources

Get Started with Sigma's API