Connect Alteryx to Download from Tableau Server Database

[stapuff]

I am looking to retrieve a list of data sources, user information, workbooks, etc from Tableau. I am new to Tableau server so throwing the question out there. 

Thanks,

Puff 

[AbhilashR · Accepted solution]

Hi @stapuff, take a look at the SQL's mentioned in the following Tableau community post, and use them in Alteryx's Input tool to fetch the data inside Alteryx for further analysis.

https://community.tableau.com/thread/238244

Please mark this post as solution accepted if it answers your query

[stapuff]

I appreciate the response back.  I will take a look at it and let you know how I fair.

Thanks,

Puff

[stapuff]

I appreciate you posting that link. Extremely useful documents.

I did not use this suggestion though.  Just ended up build a Rest API workflow to produce the results I was looking for.

Again Thank You for your post,

Puff

[pablolarocca]

Could you Share the Rest API, I have the same need

[shalinipal23]

I have the same requirement. Could you please share the workflow.

[stapuff]

@shalinipal23 

Sorry... just seeing this.  Do you still need the example?

Puff

[bakedsalmon333]

Hi I also need the workflow do you mind sharing? Here's mine but I got some 404 errors. 

[stapuff]

@bakedsalmon333 @shalinipal23 @pablolarocca 

I am going to describe what works for me.

1) I created a user in Tableau and gave the user Admin rights.

2) I took the url of our Tableau site, username and password created in step 1 and placed it into the input tool marked with red line.

3) I then placed the url of our Tableau site and placed it in the formula tool marked with red line.

*Note - the formula tool marked with red line is where you can change what api is getting call/returned. Look at the tail end of the url getting called. I have mine hardcoded to /users?pageSize=1000 ,but this can be dynamic

[shalinipal23]

Thanks for the workflow. Apologies, for not replying any sooner.

One more query is this possible without the admin rights?