Workato docs Return to Workato
Edit this page
GitHub (opens new window)
  • Introduction
  • Getting started
  • Product Updates (opens new window)
  • Concepts
  • Connecting apps
  • Building recipes

  • Running recipes

  • Troubleshooting

  • Data types and formulas

  • Tools
  • Files and attachments

  • Batch processing

  • Teams and collaboration
  • People Task by Workato
  • Recipe lifecycle management
  • On-prem connectivity
  • Key features
  • Workbot for Slack
  • Workbot for MS Teams
  • Workbot for Workplace
  • API Platform
  • Connectors

  • Universal connectors
  • Community connectors
  • Connector SDK
  • Custom OAuth profiles
  • Workato API
  • Security
  • Training & Certification
  • Contact us

# Zuora - Query record action

# Query record action

This action queries records in Zuora using Zuora Object Query Language (opens new window). The Zuora Object Query Language (ZOQL) is a simple SQL-like query language used to construct query calls in the SOAP API.

Basic knowledge and experience with SQL is required to work with ZOQL

Query record action Query records

# Input fields

Field Description
Object Select the object type in Zuora you hope to query for.
ZOQL Query A valid ZOQL query. i.e. select field_names from object where filter_statements
Batch size The size of the query result to be returned. Maximum is 2000.

# Output fields

Field Description
Array of records An array of records where the attributes returned for each record change dynamically based on the object you have selected.

# ZOQL details

  • No Complex Queries​ Zuora does not support complex queries and joining for query().

  • No Aggregate Functions Nested aggregate functions are not supported for query().

  • No Wild Card Support You cannot use the asterisk wild card (*) for field names with a query() call. You must explicitly specify a field name.

  • No Order By Support ZOQL does not support sorting results in ascending or descending order.

  • Conditions Allowed A maximum of 200 conditions are allowed in a WHERE clause of a query() call. For example, you can have up to 200 distinct AND or OR clauses.

For more details check out the ZOQL documentation here (opens new window)

← Search record Custom actions →

Didn’t find what you are looking for?
Search our resource library View getting started guides, tutorials, training videos, webinars and FAQ Ask our community View questions and answers from other users and Workato experts. File a support ticket File a support ticket for critical issues that require a higher level of support.
Privacy Terms (844) 469-6752 Workato 2021