This content has been marked as final. Show 2 replies
Goal : Use the REST API to return a sample of data from each view in a dashboard.
It appears that if one uses this new-ish endpoint against a Dashboard (vs a worksheet), it only returns data from the FIRST worksheet added to the dashboard...
...so if viewid 2474164d-8d37-4a4c-abc7-c2070fd25fd5 = "My Sheet" and "My Sheet" contains a single data source, I'm going to be a happy camper
However, if viewid 2474164d-8d37-4a4c-abc7-c2070fd25fd5 = "My Dashboard" and it contains 3 different worksheets, and each worksheet has a distinct data source associated with it, then I'm out of luck if I want to use this method to get data for the second or third worksheet.
I pretty much need to query the individual worksheets OUTSIDE of the dashboard if I want to sample data from each sheet. OK. Willing to do that.
But I don't see anything in the current API that lets me understand what views are included in a specific dashboard. so I'm sort of SOL here, too.
I guess I could download each workbook from Server and then parse the XML to figure out what views are in each dashboard, but that seems like cruel and unusual punishment. Any ideas?