Guidelines for CSV file upload in Data Loader
Preparing the CSV file for Data Loader
Nested objects are data structures in which one object is placed within another, creating a hierarchy of related information. Imagine it as a series of containers within containers, each holding a specific set of related data. This structure helps organize data and shows the connection between the main object and its sub-components.
For example, an Invoice in Zuora Billing contains a collection of Invoice Items and Custom Rates. Each Invoice Item includes its own details, like Tax and Discount Items, creating a clear and organized data relationship. In Data Loader, this hierarchy is clearly defined using IsMarker
columns, which help identify when a new object needs to be created within another, streamlining the data import process.
Nested Object CSV file Template for Standalone Invoices:
- The
IsMarker
column in Data Loader templates shows when a new object needs to be created. For example, in the Standalone Invoices template, the fieldsIsNewInvoiceItem
andIsNewCustomRates
indicate when a new item or rate needs to be added. - The
IsNew
marker columns in the CSV file are used to signal when new records should be created in the context of the file, not within Zuora Billing. For example, when adding an Invoice with multiple Invoice Items, the first row for that Invoice will haveIsNewInvoice =
True
. TheIsNewInvoiceItem =
True
indicates a new Invoice Item. Subsequent rows, representing additional Invoice Items for the same Invoice, will haveIsNewInvoice = False
or can be left blank since it is not a new Invoice anymore. This approach allows the CSV to maintain hierarchical relationships within a flat-file format.
- For data accuracy, mapping the
IsMarker
column in the Field Mapping Interface is mandatory when the value of theIsMarker
column is TRUE. - You may provide the value of
Ismarkercolumn
for the child object as True or False, depending on the nesting of the records required for creation.
Here are some sample CSV files for reference: