Get row count

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.

Request
path Parameters
tmpl_name
required
string

Name of the BI view.

query Parameters
clientId
required
integer
Default: 1

The ID of the Zuora Revenue application user.

fromDate
string
Default: "2016-07-26T00:00:00"

The date from which the data query begins.

toDate
string
Default: "2018-07-26T00:00:00"

The date on which the data query ends.

header Parameters
token
required
string

The valid authentication token that is generated by the Authentication operation.

Responses
200

The row count of the specified BI view is returned.

400

Error occurs. For example, the user ID is invalid, or the specified BI view does not exist.

401

The provided authentication token has expired. Send the Authentication request again to get a new token.

get/api/integration/v2/biviews/count/{tmpl_name}
Request samples 
curl -X GET https://ui_url/api/integration/v2/biviews/count/BI3_ACCT_TYPE?=&clientId=1&fromDate=2016-07-26&toDate=2018-07-26 -H 'token: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VybmFtZSI6IlNZU0FETUlOIiwicm9sZSI6IlJldnBybyBBUEkgUm9sZSIsImNsaWVudG5hbWUiOiJEZWZhdWx0IiwiY2xpZW50aWQiOjEsImlhdCI6MTU1ODMzMDIxMCwibmJmIjoxNTU4MzMwMjEwLCJpc3MiOiJadW9yYS1SSUEiLCJleHAiOjE1NTgzMzIwMTB9.Sr2oIxp7XWSJSy9bARfr7nkFvAmMbdhMaNBv9IR52Fo