Zuora is an end-to-end subscription management platform that brings your entire subscription business under one roof, with the capabilities and insights you need to grow your business and create customers for life. This article will give you an overview of the Zuora/Grow integration.
NOTE: We are no longer actively supporting this integration as of March 1, 2020. If you have previously authenticated this data source, it will still appear in the list of your data sources. We will not be improving this integration further. However, Zuora is supported by a third-party ETL called StitchData. To learn more, click here.
How to Connect
- Log in to Grow and select ‘Settings’ under your name in the top-right corner
- Select ‘Data Sources’ from the menu on the left and click on ‘+ Connect Data Sources`
- Search for Zuora, and select ‘+ Connect’
- Next, you’ll be asked to enter your Zuora login credentials
- And that’s it! You’re ready to start visualizing some awesome finance metrics!
Instead of having set endpoints, Zuora uses ZOQL (Zuora Object Query Language) to pull data. When you connect your account to Grow, you will be given one endpoint called ZOQL Query.
ZOQL, or Zuora Object Query Language, is a query language similar to SQL. It is used to construct query calls in Zuora’s SOAP API. Zuora suggests you have basic knowledge and experience with SQL in order to work with ZOQL effectively.
ZOQL’s basic query syntax is as follows:
select [field_names] from object where [filter_statements]
When you first start building a metric in Grow, it gives an example query:
select [accountnumber] from account where status = "Active"
FAQs + Tips and Tricks
(Note: If you want to use that query, you will need to type it manually into Grow. It is only shown there as an example query.)
When writing a ZOQL Query, be sure to note the following:
- All keywords must be written in lowercase.
- ZOQL doesn’t support parentheses to indicate order of operations in a query. However, you can use the operators and and or. (Note that the operator and takes priority in the order of operations over or.)
Zuora’s documentation of ZOQL goes into more detail about how to write queries, as well as the constraints ZOQL has. It is fairly comprehensive and easy to understand.
If you want to see what object references are allowed in Zuora's SOAP API, check out this article. This will help you write your queries with fields that are allowed in Zuora.