Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


In this article

Table of Contents
maxLevel2
absoluteUrltrue

...

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 Snap uses /v1/action/query for them.

...

Field Name

Data type

Description

Label

String

Specify a unique label for the account.

Default ValueZuora REST Read
ExampleRead Account data

OpenAPI Specification

String

Enter the URL for the OpenAPI specification file.

Example: zuora_open_api_spec3.json, sldb:///zuora_open_api_spec3.json
Default value: [None]

Zuora Object

String

Required.  Enter the desired Zuora object name. Click the Suggestions icon to see the available object names. The Snap executes and fetches the data for the object specified.

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] 

Limit ClauseString

Enter the maximum number of output records.

Example: 10000
Default value: [None]

Note

This property does not support Zuora Objects: export, import and communicationprofile. Use Where Clause to limit the number of records. For more information, refer to the Zuora documentation on Zuora Query Processing Limitations.


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

Pass Through

Checkbox

If selected, the input document will be passed through to the output view under the key 'original'. 

Default value: Selected

Snap Execution

N/A

Indicates how the Snap must be executed. Available options are:

  • Validate & Execute: Performs limited execution of the Snap (up to 50 records) during Pipeline validation; performs full execution of the Snap (unlimited records) during Pipeline execution.
  • Execute only: Performs full execution of the Snap during Pipeline execution; does not execute the Snap during Pipeline validation.
  • Disabled: Disables the Snap and, by extension, its downstream Snaps.

Default value: Validate & Execute

Troubleshooting

ErrorReasonResolution
SOAP ExceptionSOAP request failedPlease 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 ExceptionThe 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 typeThe provided input is not a document of type MapPlease ensure the input document type is of type Map.

Examples

...


In the following use case example, the Pipeline uses Zuora Rest Read Snap and Zuora Open API Snap to create an account with a unique ID from the Mapper Snap, link it to a contact.

Image Added

The data is added to the Mapper Snap and sent to the Open API Snap.

Settings

Output view

Image Added

Image Added

The details created are sent from the upstream Snap to create a unique account ID using Open API Snap. Following are the Snap settings and the output view:


Settings

Output view

Image Added

Image Added

Using Mapper Snap, we are sending data to create a contact for an account by mapping a unique account ID. The details of the data created can be seen under Expression and Target Path. The Output view for the Mapper Snap is as follows:


Settings

Output view

Image Added

Image Added

The contact for an account is created and a unique contact ID is generated. The Settings and Output view are as follows:

Settings

Output view

Image Added

Image Added

The contact details can be fetched by passing a unique contact ID using Zuora Rest Read by passing $entity.Id.


Settings

Output view

Image Added

Image Added


Download this Pipeline

Downloads

...