
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
- Export a Liveboard report for the weekly metrics
- 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
- Search users to check for an existing account
- 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
- Search users for the worker's email
- 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
How Tray.ai makes this work
ThoughtSpot plugs into the whole Tray.ai platform
Intelligent Integration
Integrate and automate across 12,000+ apps, databases, APIs, and services with visual workflows, error handling, and observability.
Learn more →Agent Builder
Build AI agents that read, write, and take action in ThoughtSpot — with guardrails, audit, and human-in-the-loop.
Learn more →Agent Gateway for MCP
Expose ThoughtSpot actions as governed MCP tools — observable, rate-limited, authenticated.
Learn more →Tray Helix
Build apps on ThoughtSpot data with your AI assistant, then deploy, run, and govern them on Tray.ai.
Learn more →More data and analytics apps on Tray.ai
Dedicated connectors and other apps Tray.ai reaches in the same category. See every data and analytics connector →
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.
Thanks — someone from our team will be in touch soon.