How to download Tableau View as Datatable to perform In-memory operations viaTableau Activities in UiPath

This video will give you an overview on how you can use the ‘Query View Activity’ to save the data to a datatable to perform in-memory operations using Tableau Activities in UiPath

Pre-Requisite: You need to have a Tableau account. If you don’t have an account then join the Tableau developer program by logging to this link https://www.tableau.com/developer to create your developer account

Here are the steps you need to perform:

Now, Open UiPath Studio and Install UiPath.Tableau.Activities

Now, Drag Tableau Application Scope to the main workflow and click on Configure button

Please see the tutorial here https://medium.com/@manojbatra071/how-to-configure-tableau-application-scope-connection-using-access-token-in-uipath-982aa5a70626 to configure Tableau Application Scope

Now Drag ‘Query View Data’ activity to the workflow

To Set the Site ID parameter, click on the find button and a popup would appear

Click on Find and it will display the list of site id associated with the account

Select the Site id and click done

Now, to find View Id. First copy the site Id and click on Find button next to the View ID textbox

Select the view from the list and click ‘Done’

Now select the output datatbale name

Drag a message box to the workflow to see the total number of rows

Run the program and see the action

This would be the output

Her is the YouTube Video: https://youtu.be/Zq8YQjJLXuc

Code: https://github.com/manojbatra071/UiPathSamples/tree/main/36%20-%20DownloadTableauViewAsDatatable

Happy Automation