Why we need this ?
For quite some time tabcmd has been Tableau’s swiss-army-knife for all kinds of tasks (external extracts, publishing, etc). Last couple of years a new tool has emerged - Tableau Rest API - which is continuously beefed up by Tableau.
Generate Personal Access Token in your Tableau profile
Copy your TokenSecret and paste it into a new environment variable called TableauTokenSecret
on Windows
on Linux
run nano .my.cshrc and add variable
setenv TableauTokenSecret "123456..."
ssh-connect to “analytics” server
Run “~analytics/TigerETL3/runEtlShell.sh“
Establish new session to Tableau REST API
import analytics.tiger.agents.TableauRestAPI._
val session = signin("https://tableau.broadinstitute.org/api/3.6","myToken")
Examples:
lookup extractRefreshId by Workbook name
session.lookupExtractRefreshTaskId("Array QC Tesy Extract With REST_API")
print out first 5 items from extracts-list
session.siteItems("tasks/extractRefreshes", "tasks").take(5).foreach(println)
print out dataAlerts having daily-frequency
session.siteItems("dataAlerts").filter(it => ((it \ "@frequency").text) == "daily").map(da => (da \ "@subject", da \ "@frequency", da \ "@suspended")).foreach(println)