After selecting Zuora from our Destinations catalog, you will be prompted to enter your Zuora Base URL, Client ID, and Client Secret.
Use this table from Zuora to select the correct Zuora URL, and follow
these steps
to create an OAuth Client in Zuora that will provide you with the required Client ID and Secret.
Each object / action pair will have their own required properties to be mapped. These required properties will be in their own mapping section during sync configuration. Be sure to scroll down to our Zuora Object Notes to see which fields are required, and their respective data types.
Any optional built-in fields or custom fields sent to Zuora will be mapped in the custom mappings section of sync configuration. Scroll down to our Zuora Object Notes to see Zuora's optional built-in fields, and their respective data types.
Use our advanced mapper to fill in static values for numbers or string values that may be consistent across your sync, that may not have a column in your data warehouse. See the example below.
The following fields can be used for Subscriptions for each respective action.
Upsert(click to view table)
Field Name
Notes
Required
accountKey
string
yes
applyCredit
boolean
applyCreditBalance
boolean
autoRenew
boolean
collect
boolean
contractEffectiveDate
string
yes
creditMemoReasonCode
string
customerAcceptanceDate
string
documentDate
string
externallyManagedBy
string
gatewayId
string
initialTerm
integer
initialTermPeriodType
string
invoice
boolean
invoiceCollect
boolean
invoiceOwnerAccountKey
string
invoiceSeparately
boolean
invoiceTargetDate
string
notes
string
paymentMethodId
string
renewalSetting
string
renewalTerm
integer
yes
renewalTermPeriodType
string
runBilling
boolean
serviceActivationDate
string
subscriptionNumber
string
subscribetoRatePlans.productRatePlanId
string
yes
targetDate
string
termStartDate
string
termType
string
yes
CpqBundleJsonId**QT
string
OpportunityCloseDate**QT
string
OpportunityName**QT
string
QuoteBusinessType**QT
string
QuoteNumber**QT
string
QuoteType**QT
string
IntegrationId**NS
string
IntegrationStatus**NS
string
Project**NS
string
SalesOrder**NS
string
SyncDate__NS
string
Update(click to view table)
Field Name
Notes
add
Array of objects
applicationOrder
Array of strings
applyCredit
boolean
applyCreditBalance
boolean
autoRenew
boolean
clearingExistingBillToContactId
boolean
clearingExistingPaymentTerm
boolean
collect
boolean
creditMemoReasonCode
string
currentTerm
integer
currentTermPeriodType
string
documentDate
string
externallyManagedBy
string
includeExistingDraftDocItems
boolean
includeExistingDraftInvoiceItems
boolean
invoice
boolean
invoiceCollect
boolean
invoiceSeparately
boolean
invoiceTargetDate
string
notes
string
preview
boolean
previewType
string
renewalSetting
string
renewalTerm
integer
renewalTermPeriodType
string
runBilling
boolean
targetDate
string
termStartDate
string
termType
string
CpqBundleJsonId__QT
string
OpportunityCloseDate__QT
string
OpportunityName__QT
string
QuoteBusinessType__QT
string
QuoteNumber__QT
string
QuoteType__QT
string
IntegrationId__NS
string
IntegrationStatus__NS
string
Project__NS
string
SalesOrder__NS
string
SyncDate__NS
string
Notes:
Only the fields to be changed should be specified. If an empty field is submitted with this operation, the corresponding field in the account is emptied.