This Snap provides the ability to retrieve records by defining a custom query. Export functionality is used to retrieve a larger set of records, which can be done across multiple objects, where as Zuora Query can retrieve a smaller set of records.
Expected upstream Snaps:  Any Snap that provides a document output view such as a Structure or a JSON Generator Snap.Â
Expected downstream Snaps: [None] or any Snap that has a document input view such as Filter, Data, or a JSON Formatter.
Expected input:Â Â This Snap currently does not provide a schema on its input view. Â Instead, the fields need to be provided manually.Â
Expected output:Â Â This Snap provides the result of the Execute operation on the output view. Errors can be routed to the error view if enabled or cause the Snap to fail during execution.
This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Zuora Account for information on setting up this type of account.
Views:
Input
This Snap has at most one document input view.
Output
This Snap has exactly one document output view.
Error
This Snap has at most one document error view and produces zero or more documents in the view.
Settings
Label
Required. The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.
Request timeout
Required. Defines the timeout value for the SOAP request (in seconds). A value of 0 indicates no timeout.
Example:Â 0
Default value:Â 0Â
Query
Required. The Zuora query being executed. The query can contain pipeline parameters or variables from the input field, such as:
"Select Id from Account where Id = ' " + $Id + " ' "Â
The expression toggle (=) must be enabled.
Example:Â Select ID From Account Default value:Â [None]
Encrypted
Required. Enables you to encrypt fields such as credit card numbers, which are returned in the export. The encryption is performed by Zuora before the records are retrieved by the Snap.
Execute name
An optional property to define the name of the export in Zuora.
Snap execution
Select one of the three modes in which the Snap executes. Available options are:
Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.
Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.
Disabled: Disables the Snap and all Snaps that are downstream from it.
 Â
Downloads
Important steps to successfully reuse Pipelines
Download and import the pipeline into the SnapLogic application.