Zuora Select

On this Page

Snap type:

Read


Description:

This Snap provides the ability to retrieve records by defining output fields and optional conditions. The output fields are the fields returned by the query. The condition can be defined to only return a specific set of records.

The conditions can either be combined with <and> or <or> operator. This is a limitation by Zuora: http://knowledgecenter.zuora.com/D_Zuora_APIs/SOAP_API/C_SOAP_API_Reference/A_SOAP_Basics/A_Zuora_Object_Query_Language/Filter_Statements

  • Expected upstream Snaps: [None] or any Snap that provides a document output view, such as Data or a JSON Generator Snap.

  • Expected downstream Snaps: Any Snap that has a document input view, such as Filter or Data or JSON Formatter.
  • Expected input: [None], or documents that provide fields that are used in one or more conditions of the Snap.
  • Expected output: This Snap provides records for all fields of the selected Zuora object.
Prerequisites:

[None]


Support and limitations:Works in Ultra Task Pipelines.
Account: 

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:
InputThis Snap has at most one document input view.
OutputThis Snap has exactly one document output view.
ErrorThis 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, 0 means no timeout
Example: 0
Default value: 0


Object

Required. The Zuora Object being queried. The field is suggestable once the Zuora account is defined

Example: Account
Default value: [None] 


Output fields


Required. The fields to be returned by the query. The return field is suggestable after selecting the + icon and after the Object property is defined. At least one output field must be defined.

Example: AccountNumber

Default value: [[None]


Conditions

The conditions defined in the where clause if any. Each predicate has access to the schema on the input view if any. The example shows the usage of a condition that is enabled as an expression.

Example: (with expression toggle (=) on) "AccountNumber = '" + $accNumber + "'"

The second example shows the usage of a condition that is not enabled as an expression.

Example: (with expression toggle (=) off) Id = '2c92c0f8427e89d8014291c9609131ee'

Default value: [[None]


Condition operator

The operator to concatenate each condition. It can either be all AND or all OR. Zuora does not support mixing both. 
http://knowledgecenter.zuora.com/D_Zuora_APIs/SOAP_API/C_SOAP_API_Reference/A_SOAP_Basics/A_Zuora_Object_Query_Language/Filter_Statements

Example: and


Default value: and


Remove namespace prefixes

Select this option to remove any residual XML namespace prefixes from the output JSON. For example, "ns2:Id" becomes "Id".

Default value: Not selected.


Examples

Downloads

  File Modified

File Zuora select sample.slp

Aug 03, 2017 by Diane Miller




Snap Pack History

 Click to view/expand
Release Snap Pack VersionDateType  Updates
4.27main12833 StableUpgraded with the latest SnapLogic Platform release.
4.26main11181 Stable

Added the following Snaps and account types to connect these Snaps with the Zuora REST API. 

4.25main9554
 
StableUpgraded with the latest SnapLogic Platform release.
4.24main8556
StableUpgraded with the latest SnapLogic Platform release.
4.23main7430
 
StableUpgraded with the latest SnapLogic Platform release.
4.22main6403
 
StableUpgraded with the latest SnapLogic Platform release.
4.21snapsmrc542

 

StableUpgraded with the latest SnapLogic Platform release.
4.20snapsmrc535
 
StableUpgraded with the latest SnapLogic Platform release.
4.19snaprsmrc528
 
StableUpgraded with the latest SnapLogic Platform release.
4.18snapsmrc523
 
StableUpgraded with the latest SnapLogic Platform release.
4.17ALL7402
 
Latest

Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

4.17snapsmrc515
 
Latest

Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.

4.16snapsmrc508
 
StableUpgraded with the latest SnapLogic Platform release.
4.15snapsmrc500
 
StableUpgraded with the latest SnapLogic Platform release.
4.14snapsmrc490
 
StableUpgraded with the latest SnapLogic Platform release.
4.13

snapsmrc486

 
StableUpgraded with the latest SnapLogic Platform release.
4.12

snapsmrc480

 
StableUpgraded with the latest SnapLogic Platform release.
4.11snapsmrc465
 
StableUpgraded with the latest SnapLogic Platform release.
4.10

snapsmrc414

 
StableUpgraded with the latest SnapLogic Platform release.
4.9snapsmrc405
 
StableUpgraded with the latest SnapLogic Platform release.
4.8

snapsmrc398

 
StableUpgraded with the latest SnapLogic Platform release.
4.7 Patchzuora2593 Latest

Add additional retry logic for connection to server.

4.7 Patch zuora2521 Latest

Retry added for failed login.


4.7

snapsmrc382

 
StableUpgraded with the latest SnapLogic Platform release.
4.6snapsmrc362
 
StableUpgraded with the latest SnapLogic Platform release.
4.5.1

snapsmrc344

 
Stable

Zuora Read Snap now has an option to remove the namespace prefixes from the Snap output.

4.4.1
 Stable

Zuora Read Snap updated to include ProductRatePlan added to Object list.