CODEWITHSUNDEEP
postmantableau-apirest
325
325

Reputation: 606

Connecting REST API to Tableau

I am trying to use REST API to connect data into Tableau Desktop. Which option do I select when choosing the datasource when opening Tableau Desktop? I have tested the API in Postman, and it successfully connects.

Upvotes: 0

Views: 867

Answers (2)

Crystal L
Crystal L

Reputation: 571

Tableau cannot connect to REST API directly.

One way is to use Web Data Connector, BUT you have to build a web page for each REST API and paste the web page link in Web Data Connector.

Alternatively, you can use ETL tools that support extracting data from API and loading it to Tableau. (I personally recommend Acho. Its API connector is very useful)

Upvotes: 0

vizyourdata
vizyourdata

Reputation: 1444

The REST API is not a data source that can be accessed from Tableau Desktop. To use the REST API you have to export the data from an API call to csv or other flat file. Then you can connect Tableau Desktop to that file. You can automate this using Python. You can also export directly from Postman. At the top of your results after you run your GET, download the file from here here

I do strongly recommend you do this all in Python rather than Postman though so you can consume the json file much more easily with pandas. I would also recommend looking at tableauserverclient within Python rather than using the API directly. tableauserverclient is more limited than the API but will likely have the functionality you need.

Upvotes: 1

Related Questions