Revenue API
/- Download the CSV upload template
Export journal entries to CSV
Export lines to CSV
Export schedules to CSV
Export waterfall to CSV
Download the CSV upload t...
Purpose
Downloads the combined CSV template for POST /journal-entries (multipart). Row 1 holds the header column titles; fill row 2 with the header values, keep the blank line, then add one row per line under the line column titles. Column titles are matched case-insensitively ignoring spaces and punctuation; both friendly titles (for example Account Code, Debit) and legacy codes (for example DR_SEGMENTS, AMOUNT) are accepted. Reference columns show your tenant's labels; rename them to Reference1 ... Reference15 before uploading.
When to use
- Before preparing a CSV upload: get the exact column layout expected by POST /journal-entries (multipart).
Security
OneIdOAuth
- Zuora Revenue API (base URL)https://one.zuora.com/revenue/services/v1/journal-entries/template
curl -i -X GET \
https://one.zuora.com/revenue/services/v1/journal-entries/template \
-H 'Authorization: Bearer <YOUR_TOKEN_HERE>'Response
Name,Description,Category Code,Ex Rate Type,Period Name,Reversal Period Name,SOB Name,SOB ID,Functional Currency,Book Id,Org Id,GL Transfer,Rev Rec Type,Account Method,Approval Currency
Set No,Account Type,Account Code,Currency,Debit,Credit,Ex Rate Date,Functional Ex Rate,Global Ex Rate,Start Date,End Date,So Line Id,Unbill Flag,Description,Rc Id,Rc Line Id,SO Number,Type Name,Cost Or Vc Type,Reference 1,...,Reference 15,Comments