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

id

The pinboard id in the system.

Data type

string

vizid

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

Data type

string

Syntax

4fdf9d2c-6f34-4e3b-9fa6-bd0ca69676e1", "......

batchsize

The batch size for loading of pinboard objects.

Data type

integer

Valid values

The system default is -1.

pagenumber

The system default is -1.

Data type

integer

offset

The system default is -1.

Alternately, set the offset using the following code:

1-based indexingOffset = (pageNumber - 1) * batchSize`
Data type

integer

formattype
Data type

string

Valid values

COMPACT JSON (system default), FULL JSON

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
  }
}