Skip to content
Revenue API
/
/
Export waterfall to CSV

Export waterfall to CSV

Request

Purpose

Exports the revenue waterfall of a journal entry as CSV (one column per period).

When to use

  • Download the revenue waterfall of an entry (one column per period) for analysis or sharing with stakeholders.

Notes

  • Body filter fieldName values are passed through as-is and must be one of: jeSetNo, soNumber, soLineId, accountCode, jeAmount, startDate, endDate, accountType.
  • Exports return all matching rows; pageNumber and pageSize are not applied.
  • values must contain at least one element for every operator.
Security
OneIdOAuth
Path
jeIdinteger, (int64)required

ID of the journal entry.

Example:10045
Bodyapplication/jsonrequired
pageNumberinteger or null, (int32)

1-based page number. Defaults to 1.

Example:1
pageSizeinteger or null, (int32)

Records per page. Defaults to 20; values above 40 are reduced to 40. Not applied by export endpoints, which return all rows.

Example:20
filtersArray of objects or null(QueryFilter)

Filter conditions, combined with AND.

orderingobject(QueryOrder)

Single sort order.

{
  "pageNumber": 1,
  "pageSize": 40,
  "filters": []
}

Responses

CSV file (je-waterfall-{jeId}.csv)

Headers
traceIdstring

Identifier of the request. Quote it when you contact Zuora Support.

Content-Dispositionstring

Attachment file name, for example attachment; filename="je-list.csv".

Bodytext/csv
string
Response
Set No,SO Number,SO Line ID,Account Code,JE Amount,Start Date,End Date,Account Type,SEP-2026,OCT-2026,NOV-2026
1,SO-50012,SO-50012-1,4000-100-000,1500,2026-09-01,2026-11-30,Revenue,500.00,500.00,500.00