How to scrape a public tableau dashboard

Question

This is a question that has to be narrowed down. It is currently not accepting responses.

Do you have any suggestions for how to improve this question? By changing this post, you may change the question to focus on a single issue.

1 year ago, this business was closed.

Every day, I have to download data from a publicly accessible Tableau dashboard. The dashboard allows you to download the series when you've defined the parameters of interest (time series frequency, time series interval, and so on).

My life would be a lot simpler if I could use Python or R to automate the download of these series to a database. I tried to evaluate the requests made on the website before, but I couldn't go very far. Is it possible to automate this process?

https://tableau.ons.org.br/t/ONS Publico/views/DemandaMxima/Histrico

DemandaMxima?:embed=y&:showAppBanner=false&:showShareOptions=true&:display count=no&:showVizHome=no

Answer 1

To extract data from Tableau workbooks, I created a tableau scraper library.

You may easily import data from workbooks into a pandas dataframe. Also supported are the parametered values.

The following example obtains data from the worksheet Simples Demanda Máxima Ano, switches to daily mode, displays the data from the worksheet Simples Demanda Máxima Semana Dia, and then sets the start date to January 1, 2021:

FROM tableauscraper IMPORT TableauScraper AS TS

url = "https://tableau.ons.org.br/t/ONS_Publico/views/DemandMaxima/HistricoDemandMaxima"

ts = TS()
ts.loads(url)
wb = ts.getWorkbook()

# dataframe with yearly data
ws = wb.getWorksheet("Simples Demanda Máxima Ano")
print(ws.data)

# switch to daily
wb = wb.setParameter("Escala de Tempo DM Simp 4", "Dia")

# dataframe with daily data
ws = wb.getWorksheet("Simples Demanda Máxima Semana Dia")
print(ws.data)

# switch to daily
wb = wb.setParameter(
    "Início Primeiro Período DM Simp 4", "01/01/2021")

# show dataframe with daily data from 01/01/2021
ws = wb.getWorksheet("Simples Demanda Máxima Semana Dia")
print(ws.data)