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
| |||||||
Prerequisites: | [None] | |||||||
Support and limitations: | Works in Ultra Tasks. | |||||||
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: |
| |||||||
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 | |||||||
Object | Required. The Zuora Object being queried. The field is suggestable once the Zuora account is defined Example: Account | |||||||
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. Example: 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. |
Downloads
Important steps to successfully reuse Pipelines
Snap Pack History
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.