In this article
| Table of Contents | ||||
|---|---|---|---|---|
|
Overview
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.
Prerequisites
None.
Support for Ultra Pipelines
Works in Ultra Pipelines.
Limitations
None.
Known Issues
None.
Snap Input and Output
| Input/Output | Type of View | Number of Views | Examples of Upstream and Downstream Snaps | Description |
|---|---|---|---|---|
| Input | Document |
|
| This Snap has at most one document input view. |
| Output | Document |
|
| This Snap has exactly one document output view. |
Snap Settings
| Note |
|---|
Field names marked with an asterisk ( * ) are mandatory. |
...
Field Name | Data type | Description |
|---|---|---|
Label* | String | Specify a unique label for the account. Default Value: ELT Database Account |
OpenAPI Specification | String | Enter the URL for the OpenAPI specification file. Example: zuora_open_api_spec3.json, sldb:///zuora_open_api_spec3.json |
Zuora Object | String | Required. Enter the desired Zuora object name. Example: Account |
Where Clause | String | Enter the WHERE clause of the Zuora SELECT query without the word ‘WHERE’. Example: name = ‘SnapLogic’ |
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 |
Number of retries | Integer | Enter the maximum number of retry attempts in case of a failure in execution. Example: 3 |
Retry interval (seconds) | Integer | Specify the minimum number of seconds to wait before the next retry. Example: 2 |
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. |
Examples
Download this Pipeline.
Downloads
| Note | ||
|---|---|---|
| ||
|
...
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
...