Skip to content
Revenue API
/
/
Export lines to CSV

Export lines to CSV

Request

Purpose

Exports the lines of a journal entry as CSV using the template column titles plus audit columns. The export has no line ID column; to use it for a full-file update (PATCH /journal-entries/{jeId}), add an ID column first.

When to use

  • Download all lines of an entry to review or reconcile them in a spreadsheet.

Notes

  • Body filter fieldName values are passed through as-is and must be one of: id, headerId, clientId, orgId, createdBy, createdDate, updatedBy, updatedDate, bookId, rcId, rcLineId, currency, debit, credit, exchangeRateDate, exchangeRate, gexchangeRate, startDate, endDate, reason, errorMessage, description, comments, accountType, soLineId, soNum, costOrVcType, jeSetNo, accountCode, typeName, reference1, reference2, reference3, reference4, reference5, reference6, reference7, reference8, reference9, reference10, reference11, reference12, reference13, reference14, reference15.
  • 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-lines-{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,Account Type,Account Code,Currency,Debit,Credit,Ex Rate Date,Functional Ex Rate,Global Ex Rate,Start Date,End Date,...,Error Message,Org Id,Book Id,Created By
1,Contract Liability,2400-100-000,USD,1500,,2026-09-30,1,1,2026-09-01,2026-09-30,...,,101,1,jane.doe@example.com
1,Revenue,4000-100-000,USD,,1500,2026-09-30,1,1,2026-09-01,2026-09-30,...,,101,1,jane.doe@example.com