Change Page Number to extract information from Tableau Server

HI All,

I am working on a workflow to update my Tableau server Group with the help of Alteryx. I have overall 1094 Users in my Tableau server but I am only able to extract 1000 users information as it is an API restriction therefore How I can get the rest 94 users information?

I tried to change the page number as well but not getting required result.

Thanks,

Kuldeep

Screenshot 2023-09-08 094841.png

Screenshot 2023-09-08 094955.png

Publish

Workflow

Developer

Developer Tools

Designer Cloud

Output

Connectors

Dynamic Processing

Download

Accepted answers

Prometheus

@Kuldeepmathur I was reading up on Tableau REST APIs (https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_concepts_paging.htm) and it says here that you can change the page number. If you can't change the page number by just creating two data streams with one Formula tool that has [server] + "/api/3.17/sites/" +[site_id] +'/users?fields=_all_&pageSize=1000&pageNumber=1' in it and another Formula tool that has [server] + "/api/3.17/sites/" +[site_id] +'/users?fields=_all_&pageSize=1000&pageNumber=2' in it, then you can turn your whole workflow into a batch macro where the value that goes into it at the Control Parameter is the page number. The batch macro will send [server] + "/api/3.17/sites/" +[site_id] +'/users?fields=_all_&pageSize=1000&pageNumber=1' first and get your results then it'll run [server] + "/api/3.17/sites/" +[site_id] +'/users?fields=_all_&pageSize=1000&pageNumber=2' and get your results.

I attached a simple batch macro as an example, in case you've never used or created a batch macro. This macro queries a database that has both hot and iced coffee drink names, descriptions, and recipes. If you pull this macro into a workflow and input a single field with just the values "hot" and "iced" in a column, it'll return all the drinks that are hot and the drinks that are iced by changing the URL.

Using Coffee API Macro.yxzp

All comments

Prometheus

@Kuldeepmathur This sounds like a use case for creating a batch macro. If you can identify the part of the URL that needs to change for each API call, then you can have it run until you have all your users.

Kuldeepmathur

Thanks for the reply Do you have any Macro ready as an example?

Prometheus

Using Coffee API Macro.yxzp

Kuldeepmathur

Sorry for the late reply Prometheus! Thank you so much.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703