ThoughtSpot REST APIs allow you to programmatically manage users, user sessions, and fetch data from the ThoughtSpot application.

The ThoughtSpot REST APIs enable your client applications to access data from the ThoughtSpot application. Client applications can use the REST APIs for the following purposes:

  • get pinboard and visualization data from the ThoughtSpot application.
  • get ThoughtSpot data by programmatically sending a search query.
  • list the metadata object and visualization headers in the repository.
  • transfer ownership of all objects from one user to another and more.
  • embed data from visualizations and pinboards in a web page, portal, or application.

The REST APIs return data as a JSON string. To embed data into your application, extract the data from the JSON file, and render it on your Web page.

REST APIs retrieve live data from ThoughtSpot, so whenever the Web page is rendered, the current values are shown.

Swagger portal

To access REST APIs on Swagger:

  1. Log in to your ThoughtSpot instance as an admin user.

  2. Access the Swagger portal. If you have already logged into your ThoughtSpot instance, use the following URL to access the portal:

    https://<your-thoughtspot.com>/external/swagger

    The portal displays a list of REST API services available for the logged in ThoughtSpot users.

  3. Click on a header to expand and view the list of services.

  4. Click on a service name to view more details about the API service.

List of APIs

The following APIs are available on the Swagger portal for ThoughtSpot users.

User management

You can use the user APIs to manage ThoughtSpot users.

Request URL Description
GET /tspublic/v1/user/list Get all users, groups, and their inter-dependencies.
POST /tspublic/v1/user/updatepassword Change the password of a user account.
POST /tspublic/v1/user/transfer/ownership Transfer ownership of all objects from one user to another.
POST /tspublic/v1/user/sync Synchronize principal from your client application with ThoughtSpot.

User group management

You can use the group APIs to configure privileges for user groups.

Request URL Description
POST /tspublic/v1/group/addprivilege Add a privilege to a group.
POST/tspublic/v1/group/removeprivilege Remove a privilege from a group.

Authentication and session management

You can use the session APIs to manage ThoughtSpot user sessions.

Request URL Description
POST /tspublic/v1/session/login Authenticate and log in a user.
POST /tspublic/v1/session/logout Log out a user from an existing session.
POST /tspublic/v1/session/auth/token Obtain an authentication token for a user.

TML APIs

You can use the tml APIs to import and export TML objects.

Request URL Description
POST /tspublic/v1/metadata/tml/import Validate and import the TML objects.
POST /tspublic/v1/metadata/tml/export Export TML objects.

Data APIs

You can use the data APIs to query and embed data from the ThoughtSpot application.

Data API Request URL Description  
Pinboard Data POST /tspublic/v1/pinboarddata Fetch the pinboard data from the ThoughtSpot application.  
Pinboard Export POST /tspublic/v1/export/pinboard/pdf Download a pinboard or specific visualizations from a pinboard as a PDF file.  
Metadata GET /tspublic/v1/metadata/listobjectheaders List the metadata object headers in the repository  
  GET /tspublic/v1/metadata/listvizheaders Get the visualization headers from the ThoughtSpot system.  
Search data POST /tspublic/v1/searchdata Search data from a specific data source in the ThoughtSpot application.