Skip to main content

Data Query Release Notes


Data Query Release Notes

This page is no longer maintained. Please visit Zuora Release Notes for the latest release notes.

October 22, 2021

Revision to end-of-life columns

In the release note dated August 10, 2021, we advised that the following columns would become unavailable in the Data Query schema in January 2023. We have revised this plan. The following columns will continue to be available in the Data Query schema after January 2023.

  • The amount column in the PaymentPart object.
  • The accountingcode column in the ProductRatePlanCharge object.
  • The price and priceformat columns in the ProductRatePlanChargeTier object.

The release note dated August 10, 2021 has been updated accordingly.

October 8, 2021

Tables for Collections features available Edit section

The following tables are available for you to retrieve records for Collections features:

  • Collections_ApmPaymentRuns
  • Collections_CollectionsWindowInfo
  • Collections_ConnectorExecutions
  • Collections_LockboxRecords
  • Collections_Lockboxes
  • Collections_LockboxPayment
  • Collections_RetryAttempts
  • Collections_CustomerGroups
  • Collections_MetricSnapshots
  • Collections_RetryCycles
  • Collections_Groups
  • Collections_Note
  • Collections_Replies
  • Collections_Commentables

See Use Data Query to report on Collections features for more information.

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

"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.