Count BI View rows

Request

Returns the number of rows in a BI View for a date range, limited to the organizations your role can access.

Purpose: Size an extraction before you start it, choose a page size, and reconcile the rows you loaded.

Notes:

Counting a large view over a wide range can take a while; narrow the date range where you can.

Security

OneIdOAuth

Path

tmpl_namestringrequired

BI View API name. Standard views: BI3_ACCT_TYPE, BI3_APPR_DTL, BI3_BOOK, BI3_CALENDAR, BI3_MJE, BI3_ORG, BI3_PERIODS, BI3_RC_BILL, BI3_RC_HEAD, BI3_RC_LNS, BI3_RC_LN_COST, BI3_RC_POB, BI3_RC_SCHD, BI3_RC_SCHD_DEL, BI3_RI_ACCT_SUMM, BI3_LINE_STAGE_HISTORY, BI3_EVENT_STAGE_HISTORY, BI3_CT_MOD_DETAIL, BI3_RC_LNS_VERSION, BI3_POB_ACTIONS, BI3_RC_CT_MOD_DET, BI3_RC_HOLD. Custom views configured for your tenant are also accepted.

Example:BI3_RC_LNS

Query

fromDatestringrequired

Start of the date range, yyyy-MM-ddTHH:mm:ss.

Example:fromDate=2026-09-01T00:00:00

toDatestringrequired

End of the date range, yyyy-MM-ddTHH:mm:ss.

Example:toDate=2026-09-30T23:59:59

Zuora-Track-Idstring

Optional correlation identifier (up to 64 characters) that you choose. The Zuora One gateway records it; quote it to Zuora Support when you report a problem.

Example:close-run-2026-09-001

cURL

curl -i -X GET \
  'https://one.zuora.com/api/integration/v2/biviews/count/BI3_RC_LNS?fromDate=2026-09-01T00%3A00%3A00&toDate=2026-09-30T23%3A59%3A59' \
  -H 'Authorization: Bearer <YOUR_TOKEN_HERE>' \
  -H 'Zuora-Track-Id: close-run-2026-09-001'

Responses

The row count.

Bodyapplication/json

countinteger

Number of rows in the view for the requested date range, limited to the organizations the caller can access.

Example:25430

Response

{
  "count": 12430
}