Repository navigation
List workbooks error when Personal Space workbooks exist (missing project_id) #873
Description
Describe the bug
Listing all existing workbooks is failing with an error.
We usually run the following code to find dashboards by name for refresh operations. Since yesterday its failing with a ValueError exception. After some investigation it looks like a workbook in a "Personal Space" is causing it as it doesn't have a project_id nor a project_name. It can be circumvented by patching the code with:
if not project_id:
continue
to workbook_item.py line 278 and additionally ignoring the server error
tableauserverclient.server.endpoint.exceptions.ServerResponseError:
400006: Bad Request
Invalid page number '7'
following it.
Versions
Details of your environment, including:
- Tableau Online
- Python v3.9.4
- tableauserverclient-0.16.0
To Reproduce
Here is the code. It worked fine before the user added the personal workbook:
import tableauserverclient
tableau_auth = tableauserverclient.TableauAuth(...)
server = tableauserverclient.Server(server_address='https://dub01.online.tableau.com/', use_server_version=True)
with server.auth.sign_in(tableau_auth)
refresh_objs = [o for o in tableauserverclient.Pager(server.workbooks)]
Results
ValueError: project_id must be defined.
Activity
bcantoni commentedon Aug 23, 2021
Thanks @pschuemann for reporting this. I too can reproduce it on Tableau Online. We'll do some more digging here to understand what changed.
[-]ValueError: project_id must be defined.[/-][+]List workbooks error when Personal Space workbooks exist (missing project_id)[/+]bcantoni commentedon Aug 23, 2021
I confirmed with Query Workbooks for Site REST calls directly that workbooks in the new personal space feature do not have
project_idorproject_namedefined. Looks like we'll need to properly handle that in the TSC library and see if any other objects are affected in a similar way.adeturckheim commentedon Sep 23, 2021
Hi there, facing this problem too.
No issue with Projects, Users and Views
TomKlotzPro commentedon Oct 11, 2021
Hello @bcantoni, thanks for the fix!
When do you plan to release this fix?
jacalata commentedon Nov 8, 2021
This was released in 0.17 in October https://github.com/tableau/server-client-python/releases/tag/v0.17.0