Andy Kriebel Tableau Public

  1. Andy Kriebel Tableau Public Health
PublicAndy Kriebel Tableau PublicAndy

Steal like an artist. Austin Kleon, author of Steal Like an Artist, encourages us to embrace the. View Andy Kriebel’s profile on LinkedIn, the world’s largest professional community. Andy has 1 job listed on their profile. See the complete profile on LinkedIn and discover Andy.

Public

Andy Kriebel Tableau Public Health


3/10/2019 updated 12/27/2019
Using the Tableau Public API in 3 Easy Steps

In this blog post I will outline how you can get quick and easy statistics on any Tableau Public Profile using the Tableau Public API, and how to batch download Tableau workbooks from a Tableau Public Profile page. There are already some good blog posts on this topic and a terrific community resource called The Cerebro Project that was built and is maintained by Josh Tapley. However, it's pretty easy to pull your data, or anyone's data, using the Tableau Public API in just a few steps.

Step 1: Build a URL using the Tableau Public Profile Name


The URL is pretty straight forward:
https://public.tableau.com/profile/api/[Profile Name]/workbooks?count=300&index=0
For example, to pull the data for my Tableau Public Profile I would use this URL:
https://public.tableau.com/profile/api/jeffrey.shaffer/workbooks?count=300&index=0
The data will return in JSON format. Right-click and save the file.
Note - The parameter count=300 is the maximum number of records, so if you need the full the data for someone that has more than 300 visualizations on their Tableau Public profile page, then you will need to use the second parameter Index. Since the Index starts at 0, then the second set of 300 starts at 300 and increases in increments of 300.
For example, as of 12/27/2019, Andy Kriebel has 867 visualizations on his Tableau Public Profile page. To download his entire list you would need three URLS to download three JSON files which can then be unioned together in Tableau.
https://public.tableau.com/profile/api/andy.kriebel/workbooks?count=300&index=0
https://public.tableau.com/profile/api/andy.kriebel/workbooks?count=300&index=300
https://public.tableau.com/profile/api/andy.kriebel/workbooks?count=300&index=600

Step 2: Load into Tableau (or parse the JSON if you like)


You could parse the JSON with any number of tools, for example using Alteryx, but there really is no need to do this since Tableau can import JSON directly.
Select Data in the menu and select 'New Data Source'.
Choose JSON and select the file.
The default schema selection should work without any configuration, so click OK.
If you have more than one JSON file, as in Andy's example above, then simply drag the additional JSON files in the data import window to Union them together.
You now have the data in Tableau.

Step 3: Build a Viz


Below is a sample viz that shows the information from my Tableau Public Profile page. The fields are pretty self-explanatory. I created two calculated fields that are built by combining a few fields into a URL, one for the Thumbnail view and the other to download the Tableau workbook.
Calculated Field: Thumbnail
Formula:
// https://public.tableau.com/thumb/views/BarHoppingThemeandVariationsonaBarChart/BarHopping
'https://public.tableau.com/thumb/views/' + [Workbook Repo Url] + '/' + replace(replace([Default View Name],' ','),'.',')
Calculated Field: Full URL
Formula:
// https://public.tableau.com/workbooks/BarHoppingThemeandVariationsonaBarChart.twb
'https://public.tableau.com/workbooks/' + [Workbook Repo Url] + '.twb'
Using a dashboard action we can view a thumbnail of a viz or download the viz. There are also fields that you might useful, for example; View Count, Number of Favorites, Allow Data Access, Show in Profile, and Revision.
Update: Thank you Annabelle Ricon for catching the bad date format and providing a formula to convert to a proper date.
Calculated Field: Date
Formula:
// Date First Publish converted to a date format
// Thank you Annabelle Ricon for catching this and providing a formula to resolve the date
date(dateadd('second', int(int([First Publish Date per Document])/1000), #1970-01-01#))
Using a dashboard action we can view a thumbnail of a viz or download the viz. There are also fields that you might useful, for example; View Count, Number of Favorites, Allow Data Access, Show in Profile, and Revision.