Skip to Content

Retrieving WebI data in REST

Nov 07, 2017 at 06:48 PM


avatar image

Using the REST API, it appears that I can retrieve data from a WebI data provider flow in either CSV format or OData.

CSV format is concise, but there is no data type information, which I need.

OData format has the data type information, but for large reports it generates an explosive amount of data, either causing the HTTP request to time out (after 30 minutes), or to generate a generic error message.

How can I retrieve the data type information for a flow, without having to retrieve the entire data set in OData?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dell Stinnett-Christy Nov 07, 2017 at 09:12 PM

If you look at additional information that is available through REST, you should be able to get to the Data Provider(s) in the report. The details of the Data Providers will tell you what the data type is for each of the dimensions/measures included in the report.


Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you, Dell.

I've tried that approach but there are two issues:

1. The "resultObjects" key returned in a "specification" call only contains the name and ID of the object. It's necessary to then read and parse the universe from the SL API in order to get the datatype from the ID.

2. The ordering of columns and result objects is different in queries with multiple flows.