Skip to main content
Nirav Dedhia ha fatto una domanda in #Tableau APIs & Embedding

Hello All,

 

I have a dashboard and have filter called 'Agent Name' and it consist of 10 agents. The agent name is listed in filter is in format 'Lastname, Firstname' with a space after comma and before first name.

 

I am trying to write a cmd file to download the pdf of the dashboard for each of the agent, I have a agentlist saved in csv format, Agents name in the list is in below format

Lastname, Firstname

 

Tabcmd give below error:

tabcmd: error: unrecognized arguments: Firstname

 

Below is the code for batch file:

for /F "tokens=*" %%a in (C:\gsactiveagents.csv) do call :processline %%a

 

:processline

tabcmd export "GSDashboard/GSAgentDashboard?Agent%20Name=%*" --pdf -f "C:\tabCMD Test\%*.pdf"

 

Above code give me below error:

Passing filter value in TabCMD which has space and comma in nameI even tried to pass a single agent instead of list of agents and still give me same error. Below is the code for single agent:

tabcmd export "/GSDashboard/GSAgentDashboard?Agent%20Name='"Smith, John"'" --pdf -f "C:\Users\S0318675-a\Desktop\TabCMD Test\John.pdf"

 

The filter name in the dashboard is 'Agent Name', I have used %20 as for the space in filter name.

 

Please advise

3 risposte
  1. 21 lug 2023, 06:05

    Thank You for response. I am getting below error

     

    Requesting ''views/AgentKPIDashboard/AgentKPIDashboard?Agent0Name=SmithC0John'' from the server...

    The ''ExportCommand'' command requires a <workbook>/<view> parameter, and there must be at least one slash (/) in this parameter [/workbook_name/view_name]

0/9000