Use the Data REST API to get data

Starting in May 2022, ThoughtSpot rebranded pinboards as Liveboards. For backward compatibility, we currently support internal processes and external methods that use the older naming convention.

This procedure shows how to use the REST API to get data out of ThoughtSpot, so you can use it in a Web page, portal, or application.

Data retrieved using the Data REST API is returned as JSON (JavaScript Object Notation).

Before you can use the Data REST API, you need to enable the JavaScript API (JS API) and authenticate to ThoughtSpot.

Use this procedure to construct the URL you will use to call the Data REST API:

  1. Log in to ThoughtSpot from a browser.

  2. Navigate to the Liveboard from which you want to get data. If it doesn’t exist yet, create it now.

  3. Find the ID number of the object you want to get the data from. If the object is:

    • A Liveboard, click the More menu icon more options menu icon the and select Copy Link.

      copy pinboard link
    • A visualization, click the Copy Link icon in the upper right corner of the table or chart.

      copy link
  4. Copy the ID number from the link shown. Paste it somewhere so that you can use it later to construct the URL to use when calling the REST API.

    If the object is:

    Liveboard

    Copy the identifier that appears after "viz/". Omit the trailing "/".

    copy link pinboard
    Visualization

    Copy the identifier that appears after "viz/". This is the visualization ID.

    Note: A visualization is a table or a chart.

    copy link viz pinboard part
  5. Construct the URL as follows: For a Liveboard, the URL takes the form:

    https://<thoughtspot_server>/callosum/v1/tspublic/v1
      /pinboarddata?id=<pinboard_id>

    For a visualization, the URL takes the form:

     https://<thoughtspot_server>/callosum/v1/tspublic/v1
      /pinboarddata?id=<pinboard_id>&vizid=%5B<visualization_id>%5D
  6. If you want to apply any filters to the data that will be returned, apply Runtime Filters.

  7. Now your URL is complete, and you can use it to access the data directly through the HTTP POST method. The Data REST API returns the data formatted as JSON.

  8. Retrieve the data from the JSON and display it in your Web page, Web portal, or application.