Custom SQL (Metadata API) for a published workbook/datasource

Queries Tableau's Metadata (GraphQL) API for Custom SQL tables under a content item.

Usage

tbs_custom_sql_graphql(
  content_id,
  base_url = Sys.getenv("TABLEAU_BASE_URL"),
  site = Sys.getenv("TABLEAU_SITE"),
  token = Sys.getenv("TABLEAU_PAT")
)

Arguments

content_id

Character. Workbook or datasource ID (GUID).

base_url

Character. Tableau Server/Cloud base URL (e.g., "https://...").

site

Character. Site contentUrl ("" for the default site).

token

Character. REST credentials token (X-Tableau-Auth).

Value

A tibble with columns such as custom_sql_name, custom_sql_query, database, schema. Zero rows if none or if credentials are missing.

Examples

if (FALSE) { # \dontrun{
tbs_custom_sql_graphql(
  content_id = "abc-123",
  base_url   = Sys.getenv("TABLEAU_BASE_URL"),
  site       = Sys.getenv("TABLEAU_SITE"),
  token      = "<token>"
)
} # }