Skip to content
Revenue API
/
/
Export journal entries to...

Export journal entries to CSV

Request

Purpose

Exports journal entries matching the body criteria as CSV.

When to use

  • Produce a CSV list of entries for reporting, audit or reconciliation in a spreadsheet.

Notes

  • Body filter fieldName values are passed through as-is and must be one of: id, name, description, reversalStatus, categoryCode, exRateType, periodId, status, reversalPeriodId, hashTotal, sobName, sobId, functionalCurrency, createdBy, createdDate, updatedBy, updatedDate, approverName.
  • Exports return all matching rows; pageNumber and pageSize are not applied.
  • values must contain at least one element for every operator.
Security
OneIdOAuth
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-list.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
Name,ID,Description,Reversal Status,Category Code,Ex Rate Type,Period Name,Status,Reversal Period Name,Hash Total,SOB Name,SOB ID,Functional Currency,Created By,Creation Date,Last Updated By,Last Updated Date,Approver Name
SEP-2026 Revenue Reclass,10045,Reclass deferred revenue,,RECLASS,User,SEP-2026,New,OCT-2026,3000,US Primary SOB,1,USD,jane.doe@example.com,2026-09-28,jane.doe@example.com,2026-09-28,