Skip to Content

Retrieving WebI data in REST

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.


    Add comment
    10|10000 characters needed 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.