on 11-07-2017 6:48 PM
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?
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.
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.