Skip to main content

Data Query Release Notes

Zuora

Data Query Release Notes

We publish Data Query Release Notes when customer-facing features, enhancements, or resolved issues of Data Query are deployed to Zuora Sandbox environments. See the Data Query Release Notes below:

August 10, 2021

End-of-life columns heads-up

The following impactful changes for Data Query objects will take place in January 2023. To minimize any impact on your queries, please make changes as soon as possible in your existing queries. For any assistance please contact Zuora Global Support.

End-of-life columns in the "invoiceitem" object

The following columns in the invoiceitem object will be end-of-life:

  • accountid
  • parentaccountid
  • billtocontactid
  • soldtocontactid
  • defaultpaymentmethodid
  • productrateplanchargeid
  • rateplanid
  • productrateplanid
  • amendmentid
  • Productid

End-of-life column in the "PaymentPart" object

The amount column in the PaymentPart object will be end-of-life.

End-of-life column in the "ProductRatePlanCharge" object

The accountingcode column in the ProductRatePlanCharge object will be end-of-life.

End-of-life columns in the "ProductRatePlanChargeTier" object

The following columns in the ProductRatePlanChargeTier object will be end-of-life:

  • price
  • priceformat

"journalentryId" column deprecation

The journalentryId column in the following objects will be end-of-life: 

  • CreditBalanceAdjustment
  • CreditMemoApplicationItem
  • CreditMemoItem
  • CreditTaxationItem
  • DebitMemoItem
  • DebitTaxationItem
  • InvoiceAdjustment
  • InvoiceItem
  • InvoiceItemAdjustment
  • InvoicePayment
  • JournalEntryItem
  • NonSubscriptionInvoiceItem
  • PaymentApplicationItem
  • PaymentApplication
  • RefundApplication
  • RefundApplicationItem
  • RefundInvoicePayment
  • RevenueEventItem
  • RevenueEventItemCreditMemoItem
  • RevenueEventItemDebitMemoItem
  • RevenueEventItemInvoiceItem
  • RevenueEventItemInvoiceItemAdjustment
  • TaxationItem

End-of-life notes

  • Zuora will no longer return the above columns in the Data Query schema.
  • These changes will not impact any active queries. However, for better support, it is highly recommended to review your queries now and remove these columns. 
  • The official deprecation of these columns will be announced at a future date in January 2023.

From now on, use the JOIN syntax to add these columns to your queries. See Data Query FAQs for an example.

April 6, 2021

Workflow tables viewable to Schema Browser

You can now use Schema Browser to view the following Workflow tables:

  • workflow
  • workflow_api_call
  • workflow_linkage
  • workflow_task
  • workflow_task_usage

See View objects in Schema Browser for how to access Schema Browser.

March 27, 2021

Table attachment available

The attachment table is available for you to retrieve the attached file information records for the following Zuora objects:

  • debitmemo
  • creditmemo
  • account
  • subscription
  • invoice

See Best-practice samples for an attachment query sample.

March 16, 2021

The updatedDate field has been added to the following objects since this release:

  • PaymentReconciliationLog
  • PaymentGatewayReconciliationEventLog

March 3, 2021

Data Query Schema Browser available

Data Query Schema Browser provides the capability for viewing schemas of all tables available in your tenants. With Schema Browser, you have the ability to get a custom view into all Zuora data, optimize an external warehouse, and gather a better understanding of the Zuora Billing object model.

See View objects in Schema Browser for more information.

Data Query Unlimited available as an Early Adopter feature

Data Query Unlimited is an Early Adopter feature.

In addition to run data queries against the live transactional databases at Zuora, you can now use the Data Query Unlimited feature to query against the optimized, replicated database at 12 hours freshness for high volume extraction.

You can use the Data Query Unlimited feature through Data Query UI and Submit data query API.

Deleted records can be filtered using WHERE clause

Deleted records are by default included in the output of Data Query Unlimited but not in that of Data Query Live, when deleted records exist in the tables. However, you can always filter deleted records using WHERE clause in both Data Query Unlimited and Data Query Live.

Data Query Unlimited is an Early Adopter feature.

See Filter Deleted Records using WHERE clause for more information.

Resolved issue: converting query result into JSON file failed

Previously, when you used aggregation functions with Row type inputs in your SQL statements, Data Query failed to convert query results into JSON files. This issue has been resolved since this release.

February 3, 2021

Previously, when you queried objects with custom fields of date type, the date custom fields were actually retrieved as varchar type. This issue has been resolved since this release and you can now perform date functions on the custom fields of date type.