This post is written by Tor Arnth Petersen and Carlene Østergaard who are both data consultants at Inviso by Devoteam.
One of the magical things about Tableau and Alteryx is how well they work together. In this past blog post, we walked through how to use the Tableau API with Alteryx from scratch using the download tool. To do this there are 3 steps:
- Log into the tableau server through the API to get an access key
- Find out which view ID you want to work with
- Download the view as an image
Today, we want to introduce you to some new Alteryx tools we have built to make this 3-step process a whole lot much easier.
For each of the steps below there’s both a video of Tor showing how it’s done and a text description with screenshots. Hope you will enjoy it.
A little preparation to get going
- Download the tools from github here: https://github.com/InvisoByDevoteam/TableauServerAPIAlteryxTools by clicking the green code button and then “download to zip”
- Unzip the file and click on the .yxi files one at a time. This will install them in Alteryx. You will not receive a “successfully installed” note, but it only takes a second to install them and you can then find them in your toolbar by searching “Tableau Server”
Find the information you need:
- Your Tableau Server URL without http/https
- Your username
- Your password
- The URL of the view you would like to work with
- Your site name (see below how to find this)
In my demonstration here I will be using the following values:
Tableau Server URL without http/https: tableau.inviso.dk
- Username: firstname.lastname@example.org
- Password: nice try 😉
- URL of the view: : https://tableau.inviso.dk/#/site/Inviso-TorPetersen/views/test2/Sheet1?:iid=1
- Site name: Inviso-TorPetersen (you can find the site name in the highlighted section of your views’s URL – marked in red above)
Now we are ready to go!
Step 1: Log into your Tableau Server
To log into the tableau server you will have to submit a request to Tableau, and they send you back a token. For the next 240 minutes (unless you change this setting) you can use this token in all of your other requests you submit.
To summarize: First we send our username and password to tableau, they send back a token which will then count as our pseudo username and password when using the API
But you can ignore this, because you have tool number 1 – The Tableau Server API Authentication Tool. Simply drag to your canvas and fill in the required information and you are ready for step 2.
Step 2: Find our View ID
In step 2, we will ask Tableau to give us a list of all of the views on our site. It will return the list and include a numeric view_id which we will then use to ask Tableau to download our view. Unfortunately, this is the only way to get the view_id. You can not find it on the Tableau Server.
To summarize, you need to use the Tableau Server API Get View ID tool ONE time to get the view_id that you need. It will not change, even if you move the workbook inside the same site, rename it, etc.
There are no configurations, just attach it to the previous tool and run. You can see all of the views on your site in the output. I have copied the View ID from row 2 as that is the view I want to download, and continue to step 3.
Step 3: Download your dashboard
After finding your view ID, you simply plug that into our last tool, the Tableau Server API Download Image tool, tell Alteryx where to download the image to and run!
Using these tools on the server
You can use these tools on the server once your server admin has installed them on the server. They should follow these instructions: https://help.alteryx.com/20201/server/install-custom-tools
We are looking forward to hearing your feedback on these tools and your use cases. Actually, we are quite serious about that. If you use them, please let us know and show us how – write to us at email@example.com or firstname.lastname@example.org and show us your stuff.
These tools are a 1.0 version, but we know that so much else can be built. If your use case goes outside the scope of downloading a dashboard as a png, let us know and we could build that functionality in.
Until then though, you can always use tools 1 and 2, and continue the old custom approach for part 3. This might be relevant if you want to:
- Download data from a view
- Download as something other than png
- Download a png with filters set
- Any other feature that you find on the API documentation
Download data from view:
Download view with filters applied:
** Remember to add vf_ before each filter