In RevPro 36.008.00, a new version of BI Views API specifications, which is also referred to as integration services, are released. The BI Views APIs are used to download RevPro data into your data warehouse systems. Compared with the previous version, this new version enables accelerated downloads, downloading of large datasets, and assures data consistency.
An enhancement of BI Views V2 is the accelerated data downloads. This enhancement provides the following features to accelerate data download especially in the large volume scenario:
- Increased row count for download
- Compressed download support
- Use of continuation token
- Selectable fields for download
For more information about this enhancement, see Accelerating downloads.
With the introduction of continuation token in BI Views V2, after a data query request is made, the status of the query can be retrieved any time. If a query is pending for a long time, corrective actions can be taken accordingly.
For more information about this feature, see Activity monitoring.
Download data without row counts
It is a common practice to get to know the number of rows that will be returned for a query and then to programmatically scroll for the number of pages to download. In BI Views V2, two approaches are provided to download data.
For large volume scenarios, the above mentioned common practice might result in timeout response when the request to get the row count is made. In this case, it is feasible to start downloading and keep scrolling to a point where there is no more data without knowing the row count.
For more information about this feature, see Download data without row counts.
To avoid overheating of the system, rate limits are placed on the number of parallel executions that one client can perform against all BI Views and per BI View.
Typically, 15 parallel queries are allowed against all the BI Views. For a given BI view, 3 parallel queries are allowed. These rate limits will vary from customer to customer based on their workloads.
If these limits are to be breached, a rate limit alert message will be returned when a request to get data is made. To cancel an active task, use the Cancel task operation.