# BI Views v2


Starting from version 36.008.00, the BI Views V2 operations are provided to download data from the standard BI views. Compared with the previous version, BI Views V1, this new version has the following enhancements:

* In addition to CSV format, data can also be downloaded in a compressed format, gzip.
* The number of rows on each downloaded page is increased. In the CSV format, each page can contain up to 10,000 rows. In the gzip format, each page can contain up to 20,000 rows.
* The data volume of up to 5 million rows per query can be supported by using the BI Views V2 operations.
* A continuation token is introduced to accelerate data download for multiple pages. After a request is made for the first page, a continuation token is returned in the response header. Meanwhile, subsequent pages are cached by the system. Using the continuation token  in the subsequent requests will make the system to retrieve data from the cache instead of re-executing the query against the database.
* An operation to query the row count is introduced. You can know the number of rows to be returned before the actual download.

For more information about the BI Views V2 operations, such as new feature introduction, suggested pattern to consume these APIs,  and sample codes, see <a href="https://knowledgecenter.zuora.com/Zuora_Revenue/Y_Integration_service_(BI_Views_V2)" target="_blank">Integration service (BI Views V2)</a> in Zuora Revenue Knowledge Center.


## Get all task status

 - [GET /api/integration/v2/biviews-status](https://developer.zuora.com/other-api/revenue/bi-views-v2/get_alltaskstatus.md): Gets the status information about all BI view related tasks.

## Cancel task

 - [DELETE /api/integration/v2/biviews-status/{task_id}](https://developer.zuora.com/other-api/revenue/bi-views-v2/delete_task.md): Cancels the active tasks that are associated with the specified continuation token in the path.

## Get active task details

 - [GET /api/integration/v2/biviews-status/{task_id}](https://developer.zuora.com/other-api/revenue/bi-views-v2/get_taskdetails.md): Gets the details of all active tasks for the specified continuation token.

## Get row count

 - [GET /api/integration/v2/biviews/count/{tmpl_name}](https://developer.zuora.com/other-api/revenue/bi-views-v2/get_rowcount.md): Gets the row count of a BI view.


Note: This operation starts a count query against the database for a full table scan.
It is helful to know the number of rows that will be returned before data download.
However, if the data volume is large, this operation might result in timeout responses.

## Download BI view

 - [GET /api/integration/v2/biviews/{view_name}](https://developer.zuora.com/other-api/revenue/bi-views-v2/get_biview.md): Downloads data from a BI view in a CSV or gzip file.


If the data volume is large, it is recommended to use this operation to download Page 1 first.
A continuation token will be returned in the response header. After that, provide the continuation
token in this operation to download the subsequent pages.

## Get column list

 - [GET /api/integration/v2/biviews/{tmpl_name}/describe-columns](https://developer.zuora.com/other-api/revenue/bi-views-v2/get_columnlist.md): Gets a list of columns that are contained in a BI view.