Pinboard Data API

You can retrieve the data in a pinboard or other ThoughtSpot visualization.

This API enables you to retrieve the data of a pinboard or visualization from the ThoughtSpot system. You may want to visualize the following:

  • Fetch all the visualization objects on a pinboard.

  • Fetch a specific or a group of visualizations on a pinboard.

Resource URL

post /tspublic/v1/pinboarddata

Request Parameters

Query Parameter Data Type Description

id

string

The pinboard id in the system.

vizid

string

(Optional) The visualization id(s) on a pinboard. Use this parameter to fetch a specific visualization on a pinboard. The syntax is:

["4fdf9d2c-6f34-4e3b-9fa6-bd0ca69676e1", "…​…​"]

batchsize

integer

The batch size for loading of pinboard objects. The system default is -1.

pagenumber

integer

The system default is -1.

offset

integer

The system default is -1. Alternately, set the offset using the following code:

1-based indexingOffset = (pageNumber - 1) * batchSize

formattype

string

Valid values are COMPACT or FULL JSON. The system default is COMPACT.

Request Example

cURL
curl -X POST --header 'Content-Type: application/json' --header 'Accept: application/json' --header 'X-Requested-By: ThoughtSpot' 'https://<instance>/callosum/v1/tspublic/v1/pinboarddata?id=f4533461-caa5-4efa-a189-13815ab86770&batchsize=-1&pagenumber=-1&offset=-1&formattype=COMPACT'
Request URL
https://<instance>/callosum/v1/tspublic/v1/pinboarddata?id=f4533461-caa5-4efa-a189-13815ab86770&batchsize=-1&pagenumber=-1&offset=-1&formattype=COMPACT

Response Example

{
  "4fdf9d2c-6f34-4e3b-9fa6-bd0ca69676e1": {
    "name": "Sample Name",
    "columnNames": [
      "Opportunity Stage",
      "Opportunity Owner Name",
      "Total Amount"
    ],
    "data": [
      [
        "s3 alignment with eb",
        "jeff cameron",
        1102272
      ],
      [
        "s4 validation",
        "brian mcquillan",
        59150
      ]
    ],
    "samplingRatio": 1,
    "totalRowCount": 14,
    "rowCount": 14,
    "pageSize": 10,
    "offset": 0
  }
}