search

divinorum-webb / tableau-api-lib

An API library that allows developers to call on the methods listed in Tableau's REST API documentation.
MIT License
96 stars 34 forks source link

Problem using `get_view_data_dataframe()` #104

Open alejandro-anzu opened 2 years ago

alejandro-anzu commented 2 years ago

Hi, I'm trying to get data from a view using the get_view_data_dataframe() function but I'm getting an empty text in the response. No idea what can be happening because the view id is ok and the response has code 200

divinorum-webb commented 2 years ago

Hey @alejandro-anzu I just tested the function and am getting the expected results, for example:

image

First possible issue that comes to mind: are you referencing the view ID for a dashboard rather than for an actual sheet? This is often the cause of receiving unexpected (and incomplete) results when querying a view ID for its underlying data.

I would also confirm your user permissions against the view you are querying, but the first thing to check is whether you are querying a dashboard or an actual sheet which exists within a dashboard.

therealbmills commented 1 year ago

This may be related but I have been using your wonderful script to burst PDFs by looping through filter values, but we upgraded our Tableau Server back in October and our API version went from 3.14 to 3.15 and now if I try and export an entire workbook (with multiple dashboards) it fails with the error:

dashboard_view_id = views[views['name'] == DASHBOARD_VIEW_NAME]['id'].values[0]

IndexError: index 0 is out of bounds for axis 0 with size 0

Strangely, if I reference just one dashboard within that workbook (which itself contains multiple views) it works just fine but not if I try to export the entire workbook as a PDF which it would do successfully with API version 3.14. Might this be related? Or is there something in the API that changed that would cause this or something else altogether?