Skip to content
ThoughtSpot logo

Connectors / Data and analytics · HTTP Connector

Automate ThoughtSpot with Tray.ai

Import TML, run a search query and export a Liveboard report in ThoughtSpot. Connect ThoughtSpot to the rest of your data and analytics stack with Tray.ai.

What can you do with ThoughtSpot on Tray.ai?

ThoughtSpot is an analytics platform where people search their data in plain language and build Liveboards and reports on top of cloud data warehouses. Tray.ai connects to ThoughtSpot through the HTTP Connector, so your workflows can call the ThoughtSpot API alongside the rest of your stack.

  • Create a user in ThoughtSpot when a new employee joins in your HR system.
  • Deactivate a user in ThoughtSpot when someone leaves in your HR system.
  • Run a search query each Monday and post the weekly numbers to your team chat.
Connects through
HTTP Connector
Authentication
A bearer token

Set it up

Connect ThoughtSpot to Tray.ai

Each step uses ThoughtSpot's own API details, from its documentation.

Step 1

Save ThoughtSpot's API token

Save the token ThoughtSpot issues as a Tray.ai authentication. The HTTP Client sends it as a bearer token on every call. The token stays out of the workflow and out of the logs.

Step 2

Import a request from ThoughtSpot's docs

Add an HTTP Client step and paste a cURL example from ThoughtSpot's API docs. Tray.ai fills in the method, URL, headers, and query.

Step 3

Start with “Search users”

It's one of 22 documented actions, under Users. The response comes back as data the next step can map into your other apps.

Step 4

Hand it to an AI agent

Wrap “Create a user” and “Update a user” in workflows, and Tray.ai's Agent Gateway for MCP publishes them as governed tools Claude and other AI agents can call.

Workflows to build with ThoughtSpot

Each one uses actions and events from ThoughtSpot's own API documentation.

Email a weekly Liveboard report to leadership in Gmail

When

On a schedule

Then

  1. Export a Liveboard report for the weekly metrics
  2. Send the report to the leadership list in Gmail

With Gmail

Create ThoughtSpot users for new Okta group members

When

A user is added to the analytics group in Okta

Then

  1. Search users to check for an existing account
  2. Create a user with the person's name and email

With Okta

Deactivate ThoughtSpot users who leave in Workday

When

A worker is terminated in Workday REST

Then

  1. Search users for the worker's email
  2. Deactivate a user for that account

With Workday REST

Apps you can build on ThoughtSpot data

Internal tools your team can build with an AI assistant, each one using ThoughtSpot calls from its API documentation.

User access review

Lists users and groups so an admin can review access and deactivate users who no longer need it.

Liveboard report portal

Lets staff search for a Liveboard and download its report without opening ThoughtSpot.

Data connection inventory

Lists every data connection and lets an admin update a connection's settings.

Give your AI agents ThoughtSpot tools

Build an MCP server on ThoughtSpot in Agent Gateway and choose which actions your agents can call. Every call runs with access control and an audit trail. How Agent Gateway works

  • Search users
  • Search groups
  • Search metadata
  • Run a search query
  • Export a Liveboard report
  • Search connections
  • Create a user
  • Update a user

What the ThoughtSpot API covers

6 resources and 22 documented actions, each one a call the HTTP Connector can make from a Tray.ai workflow. Connecting it takes a few clicks: here's how.

Users

  • Search users
  • Create a user
  • Update a user
  • Delete a user
  • Deactivate a user

Groups

  • Search groups
  • Create a group
  • Update a group
  • Delete a group

Metadata

  • Search metadata
  • Export TML
  • Import TML
  • Delete metadata

Data

  • Run a search query
  • Fetch Liveboard data
  • Fetch Answer data

Reports

  • Export a Liveboard report
  • Export an Answer report

Connections

  • Search connections
  • Create a connection
  • Update a connection
  • Delete a connection

Checked against ThoughtSpot's own documentation on 2026-10-22

developers.thoughtspot.com/docs/rest-apiv2-reference

Frequently asked questions

What can a Tray.ai workflow do in ThoughtSpot?

+

The ThoughtSpot API documents 22 actions across 6 resources (Users, Groups, Metadata, Data, Reports, Connections). For example: Search users; Search groups; Search metadata. A workflow can make any documented call through the HTTP Connector.

How does Tray.ai authenticate with ThoughtSpot?

+

The ThoughtSpot API uses a bearer token. You save it once as a Tray.ai authentication, and the HTTP Connector adds it to every request.

See ThoughtSpot working against your stack.

We'll walk through a tailored demo with your systems plugged in.

Great — a couple more details

This helps us connect you with the right person. Optional, and you can skip it.