Field Values in Export ZOQL Data Sources
Each data source provides objects that are also available through the SOAP API.
Prior to version 79 of the Zuora WSDL, the following fields in data sources had different values from the corresponding SOAP API fields:
InvoiceItem.ProcessingType
JournalEntry.TransactionType
RatePlanCharge.BillingPeriod
RatePlanCharge.BillingTiming
RatePlanCharge.EndDateCondition
RatePlanCharge.ListPriceBase
RatePlanCharge.TriggerEvent
RatePlanCharge.UpToPeriodsType
RatePlanChargeTier.PriceFormat
ProductRatePlanCharge.BillingPeriod
ProductRatePlanCharge.BillingTiming
ProductRatePlanCharge.EndDateCondition
ProductRatePlanCharge.ListPriceBase
ProductRatePlanCharge.SmoothingModel
ProductRatePlanCharge.TriggerEvent
ProductRatePlanCharge.UpToPeriodsType
ProductRatePlanChargeTier.PriceFormat
Guidance
In version 79 and higher of the Zuora WSDL, the values of the above data source fields match the values of the corresponding SOAP API fields. If you are using version 79 or higher of the Zuora WSDL, you do not need to consider this guidance.
If you are using an earlier version of the Zuora WSDL, your Export ZOQL queries must use data source field values, not SOAP API field values. For example, in version 78 of the Zuora WSDL, the possible values of the RatePlanCharge.TriggerEvent
field are:
TriggerEvent Values in RatePlanCharge Data Source | TriggerEvent Values in RatePlanCharge SOAP API Object |
---|---|
UCE | ContractEffective |
USA | ServiceActivation |
UCA | CustomerAcceptance |
USD | SpecificDate |
This means that, for example, in version 78 of the Zuora WSDL the correct way to filter by a value of RatePlanCharge.TriggerEvent
is:
select RatePlanCharge.TriggerEvent from RatePlanCharge where RatePlanCharge.TriggerEvent = 'UCE'
You can use the "Describe object" API call to compare the values of data source fields in different versions of the Zuora WSDL. See the Zuora API Reference for information about the "Describe object" API call. For example:
RatePlanCharge.TriggerEvent Values in WSDL 78 | RatePlanCharge.TriggerEvent Values in WSDL 79 |
---|---|
To view the possible values of the
The response body contains the possible field values: <field> <name>TriggerEvent</name> ... <options> <option>UCE</option> <option>USA</option> <option>UCA</option> <option>USD</option> </options> | To view the possible values of the
The response body contains the possible field values: <field> <name>TriggerEvent</name> ... <options> <option>ContractEffective</option> <option>ServiceActivation</option> <option>CustomerAcceptance</option> <option>SpecificDate</option> </options> |