You can use this Snap to retrieve all fields for a Zuora object. It uses POST, query and, jobs for most of the Zuora Objects except Export, Import and Communicationprofile. The Snape uses /v1/action/query for them.
Expected upstream Snaps: [Optional] If none, the Snap executes once. If there are input documents, the Snap executes once for each input document.
Expected downstream Snaps: Any Snap that has a document input view, such as Filter or Mapper or JSON Formatter.
Expected output: This Snap provides records for all fields of the selected Zuora object if the Output Fields property is empty.
Required. Enter the desired Zuora object name. Click the Suggestions icon to see the available object(table) names. The Snap executes Show Tables query to get the list of table names.
Example: Account Default value: [None]
Where Clause
String
Enter the WHERE clause of the Zuora SELECT query without the word ‘WHERE’.
Example: name = ‘SnapLogic’ Default value: [None]
Output Fields
String
Enter the SELECT field names, one field name for each row. If empty, the Snap attempts to select all fields.
Example: id Default value: [None]
Number of retries
Integer
Enter the maximum number of retry attempts in case of a failure in execution.
Example: 3 Default value: 0
Retry interval (seconds)
Integer
Specify the minimum number of seconds to wait before the next retry.
Example: 2 Default value: 1
Troubleshooting
Error
Reason
Resolution
SOAP Exception
SOAP request failed
Please verify the template is correct. the substituted values are valid and the provided envelope matches the namespaces that are required by the targeted service.
Authorization Exception
The provided credentials are not authorized to request the export from Zuora. Please make sure that the credentials match either Zuora's sandbox or production environment.
You can switch between sandbox and production by dis/enabling the production property on the Zuora account.
Error finding subscribes a node in the template
Please ensure that the template has a subscribes node under the subscribe node parent.
Unexpected input type
The provided input is not a document of type Map
Please ensure the input document type is of type Map.