How to download crosstab from a specific sheet from a Tableau dashboard via REST API

1. Sign in to Tableau Cloud / Tableau Server

URI:

POST /api/api-version/auth/signin

2. Query workbooks on the site

URI:

GET /api/api-version/sites/site-id/workbooks

3. Query views within the workbook

(Use the workbook-id from Step 2)

URI:

GET /api/api-version/sites/site-id/workbooks/workbook-id/views

4. Download the view (crosstab or data)

(Use the view-id from Step 3)

Download as Excel (crosstab):

GET /api/api-version/sites/site-id/views/view-id/crosstab/excel

Download as CSV (data):

GET /api/api-version/sites/site-id/views/view-id/data

Please note: If only the dashboard is published without individual worksheets, you may only obtain the view ID of the dashboard from Step 3. If you proceed to Step 4 and query the data via the REST API using the dashboard view ID, the result will always return the first visible worksheet in the dashboard (sorted alphabetically).

To download a specific worksheet instead of the first visible worksheet, use the following workaround:

Republish the workbook in Tableau Desktop and include all worksheets along with the dashboard (select all sheets during publishing). This will expose each worksheet as an individual view, allowing you to retrieve its view ID and download the corresponding crosstab via the REST API.