Versions Compared

Key

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

In this article

Table of Contents
maxLevel2
excludeOlder Versions|Additional Resources|Related Links|Related Information

...

Snap type:

Write

Description:

This Snap calls the SOAP endpoint using the incoming data and writes out a SOAP response.

  • Expected upstream Snaps: References in the generated envelope can be mapped using a Mapper or Structure Snap.
  • Expected downstream Snaps: The Snap will output one document for every SOAP response, hence any document processing Snap can be used downstream.
  • Expected input: Document that conforms to the input view schema of the Snap (the Target Schema column in Mapper or Structure Snap)
  • Expected output: Document which represents the SOAP response (an XML transformed into JSON)


Clicking Customize Envelope will attempt to generate a SOAP envelope based on the information defined in the properties and the selected WSDL. The action will launch the XML Editor.

 

 In general, you will most likely always use Customize Envelope

Note

All files referred to in WSDLs hosted in SLDB must be either explicit URLs or relative in the same project. For example, if the WSDL refers to an XSD "Projects/SomeSchema.xsd", this must be changed (in the WSDL) to refer to the file in the same project "SomeSchema.xsd", and the XSD should be put in that same folder.  

The envelope will be stored in the Snap after clicking OK. Further, the envelope can be exported to SnapLogic's file system using the export action or be imported from there using the import action. The Generate template action will regenerate the template, but the content of the editor must be removed prior to that. The envelope can be customized to meet specific endpoint needs. The Snap is fully configured and executable once the envelope is finalized.  

The generated envelope will have velocity references in it. These references (here, $session_id) will be exposed to the Target Schema column of the upstream Mapper or Structure Snap. However, any changes made by the user in the generated envelope won't be reflected to this Target Schema column. In this case, the user has to remember the references added/modified in the generated envelope to map them in the upstream Snap.

Note

Template generation only works with document-style WSDLs. RPC-style WSDL template generation is currently not supported.

To execute a create request through an NTLM account in the SOAP Execute Snap, use the generic envelope similar to the following sample. This ensures the output is rendered as excepted. See the example for a demo on how this works.

Note
titleOnly a sample envelope

This sample is meant only for reference purposes and must not be replicated.


Paste code macro
languagexml
titleGeneric Customized Envelope
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope 
	xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" 
	xmlns:ns0="http://schemas.microsoft.com/dynamics/2010/01/datacontracts" 
	xmlns:ns2="http://schemas.microsoft.com/dynamics/2008/01/services" 
	xmlns:ns1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" 
	xmlns:ns4="http://schemas.microsoft.com/dynamics/2008/01/sharedtypes" 
	xmlns:ns3="http://schemas.microsoft.com/dynamics/2008/01/documents/Customer">
	<SOAP-ENV:Header/>
	<SOAP-ENV:Body>
		<ns2:CustomerServiceCreateRequest xmlns="http://schemas.microsoft.com/dynamics/2008/01/services">
			<ns3:Customer xmlns="http://schemas.microsoft.com/dynamics/2008/01/documents/Customer">
				<ns3:CustTable class="entity">
					<ns3:Currency>USD</ns3:Currency>
					<ns3:CustGroup>group</ns3:CustGroup>
					<ns3:Name>SL_Name_3123</ns3:Name>
					<ns3:DirParty xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
						class="entity" xsi:type="AxdEntity_DirParty_DirOrganization">
					<ns3:Name>dirparty_SL_3123</ns3:Name>
					</ns3:DirParty>
				</ns3:CustTable>
			</ns3:Customer>
		</ns2:CustomerServiceCreateRequest>
	</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

In the upstream Mapper or Structure Snap, these references can be mapped to static values (such as 1234) or to the references exposed in the Input Schema column. 

We map the reference session_id in the upstream Mapper (Data) Snap in the example below. Note that the content of the editor must be saved prior to selecting the schema upstream.

  

Note

The SOAP Execute Snap is a writing Snap. The Snap can be executed during preview to allow executing the defined request and to retrieve data and schema from the response. The SOAP Snap can be executed during the save operation by enabling the Snap Execution option.


Excerpt


Note

If you receive the following error: "reach the innerElementCountThreshold:50000", perform one of the following tasks:

  • Configure the Global Properties of the Groundplex in the global.properties file ("/opt/snaplogic/etc/global.properties" in Linux; "c:\opt\snaplogic\etc\global.properties" in Windows) to increase the threshold value:
    jcc.jvm_options = -Dorg.apache.cxf.stax.maxChildElements=<value>
    where 'value' is 1000000 or higher. OR
  • Add the same line as a global property in the node.

These properties are available only in a Groundplex.

Image Modified


How to use the default value for substitution

To use the Default value for substitution property of the Snap:

  1. Provide a value for Default value for substitution. This value is placed between the leaf elements—the elements that don't have any child elements.

    Info

    The substitution won't work if these leaf elements are contained within an array that does not exist in the incoming documents.


  2. Select the Use default value for substitution property.

Example


Incoming document:

Here, the session_id element doesn't exist in the incoming document. In this case, using Default value for substitution will give us the following envelope: 

Code Block
<?xml version="1.0" encoding="UTF-8"?> 
	<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" 
					   xmlns:ns0="http://api.clickatell.com/soap/webservice"> 
			<SOAP-ENV:Header /> 
			<SOAP-ENV:Body> 
				<ns0:ping> 
					<session_id>NO VALUE</session_id> 
				</ns0:ping> 
			</SOAP-ENV:Body> 
	</SOAP-ENV:Envelope>


Note
If you don't specify the Default value for substitution and don't select the Use default value for substitution property, the elements will be removed from the envelope recursively.


Prerequisites:

None

Support and
limitations:
  • Works in Ultra Pipelines if timeout is specified.
  • After upgrading your Snaplex to 4.20 GA version, Pipelines with SOAP Execute Snap that uses the Apache CXF library might hang without executing. The Snap using HTTPComponents library executes successfully.
Warning
titleBreaking Change

The HTTP header field's behavior in the SOAP Execute Snap is changed. Specifying only a key is not sufficient. Both key and value must be provided when invoking a task. 


Account: 

This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Configuring SOAP Accounts for information on setting up this type of account.

Views:


InputThis Snap has at most one document input view.
OutputThis Snap has at most one document output view.
ErrorThis Snap has at most one document error view and produces zero or more documents in the view.


Snap Settings

Field NameDescription

Label*

Specify 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.

WSDL Url*



Specify the URL for the WSDL.

Note

WSDL File URL is case sensitive.

Examplehttp://www.webservicex.net/stockquote.asmx?WSDL 

Service Name*


Specify the system function that has been exposed to Web-based protocols.

Example: http://www.webserviceX.NET/}StockQuote

Endpoint*


Specify the endpoint (in WSDL 2.0 terminology)/Port name (in WSDL 1.1 terminology).

Note

Whenever presented with multiple port versions, always select the latest one.

Example{http://www.webserviceX.NET/}StockQuote

Operation*


Specify the operation to invoke

ExampleGetQuote

Timeout*


Specify the timeout for the web service call (in seconds). 0 indicates no timeout.

Default value: 0
Example: 0

Encode Attribute

Select this checkbox to differentiate the attributes from XSD with an '@' prefix in the input schema and "at-" prefix in the template.

Default value: Deselected

Default value for substitution

This value will be used for substitution for the leaf elements which are not objects and/or not enclosed in an array. If nothing is specified and Use default value for substitution is selected, an empty string will be used for substitution.

Use default value for substitution


If you select this checkbox:

  • The value in the Default value for substitution field is used for substitution if the elements don't exist in the incoming documents. If not selected, or if there are no incoming documents, the elements for which the incoming documents don't have any values will be deleted from the SOAP request.
  • The Preserve input empty values field is ignored.

    Default value: Not selected

Preserve input empty values

Select this checkbox to preserve any empty value within the input data in the SOAP request. If you select Use default value for substitution checkbox, then this field is ignored. 

Include root element 

Select this checkbox to include root element in the body or header in the keys generated in the envelope template.

Default value: Not selected

Trust all certificates

Select this checkbox to trust all certificates, such as self-signed certificates.

Default value: Not selected 

Remove illegal characters

Select this checkbox to remove illegal UTF characters based on XML 1.0 standard.

Default value: Not selected

Escape special characters

Select this checkbox to enable the Snap replace the XML special characters  in XML template variable values with the respective character entity references (&gt; &lt;, and so on) while inserting these values into the Apache Velocity template. For example, the Snap replaces < with &It;


Info

The special characters that the Snap escapes are: >, <, &, ', "

Default value: Selected.

Enable MTOM 
Processing


Select this checkbox to enable content processing to multipart, application/xop+xml type.

Note

When Message Transmission Optimization Mechanism (MTOM) processing is enabled, binary files will be transmitted outside the SOAP request envelope as a MIME attachment. XML-binary Optimized Packaging (XOP) should then be used to reference the attachment within the SOAP request envelope.

The following example shows how contents of the file, salesforce_sample.csv, are inserted into the SOAP response and what updates are required to the Snap.

After selecting the Enable MTOM Processing field, the following updates to the Snap are required for successful execution:  

  • Attachments: Specify the Binary filename (salesfoorce_sample.csv), and its Content-ID and Content-Type.



    Note

    With MTOM processing enabled, entering attachment part value to the Part field is:

    • Mandatory if you are using the Apache HttpComponents library.
    • Optional if you are using the Apache CXF library.


  • Customize Envelope: Click Customize Envelope to update the SOAP envelope to import the attached file and its contents.



  • Note that to reference the attached file; you must specify the following line of code in the SOAP envelope:

<xop:Include xmlns:xop="http://www.w3.org/2004/08/xop/include"  
href="cid:<Content-ID_of_the_filename>"/>

Default value: Not selected

Output SOAP envelope

Select this checkbox to output the whole SOAP envelope instead of just the SOAP body
Default value: Not selected

WS Addressing


Creates and configures an addressing feature with the use of addressing requirements. It enables WS-Addressing, that is it supports WS-Addressing but does not require its use. It also configures to accept all the response types.

Default value: Not selected

Output HTTP response headers

Select this checkbox to output the HTTP headers in the response.

Default value: Not selected

SSL Protocol

Advance setting, leave blank to allow Java default.

Response to null SOAP call return value*


Specify an action to be taken when a SOAP call returns an empty response. The default action is Output no documents.

You can handle SOAP call with an empty response in the following ways:

  • Output no documents: The Snap executes successfully and returns no output document.
  • Output empty document: The Snap executes successfully and returns an empty document in the output view.
  • Write error document: The Snap execution fails and returns an error document in the error view. 

Default value: Output no documents
ExampleOutput empty documents

Maximum request attempts


Specify the maximum number of attempts to be made to receive a SOAP response. The SOAP request is terminated if the attempts do not result in a SOAP response. If no value specified, only 1 attempt is made before terminating a SOAP request.

Default value: 3
Example: 5

Retry interval


Specify the interval between two successive SOAP requests. A retry happens only when the previous attempt resulted in an exception. 

Default value2
Example: 5

Success condition


An expression to match success criteria in the SOAP response.

Example: (with expression toggle on) $['SOAP-ENV:Body']['ns2:orderResponse']['ns2:result'] == "success"

This would match the success criteria in this SOAP response:

Code Block
[
  {
    "SOAP-ENV:Body": {
      "@xmlns:SOAP-ENV": "http://schemas.xmlsoap.org/soap/envelope/",
      "ns2:orderResponse": {
        "@xmlns:ns2": "http://www.Snaplogic.com/Snapbox/order",
        "ns2:result": "success",
        "ns2:transactionId": "533822"
      }
    }
  }
]

You can see that the user can find the SOAP output by setting Snap Execution on the SOAP Execute Snap, then seeing what comes out. You can also hook up a Mapper Snap and see the schema there. You can do that on the input view, but not the output view.

Customize envelope


Launches the XML editor which will generate a SOAP envelope based on the defined properties, WSDL URLService namePort name and Operation. The editor will load an envelope if it was defined previously. The editor allows you to save SOAP envelopes in SnapLogic's file system or import existing SOAP envelopes from it. The Apache Velocity template can be used to pass dynamic values from upstream Snaps.

 
Any content that needs escaping from Velocity editor parsing can be enclosed with the following syntax:

#[[ <data> ]]#

See https://velocity.apache.org/engine/1.7/vtl-reference.html#unparsed-content for more information.

HTTP header

Use this field set to define HTTP header key-value pairs.

Note

You must provide both key and value when invoking a task.


Attachments

Use this field set to add attachments.

Allow duplicate headers

Select this checkbox to allow duplicate headers value. If not selected, then the last value of the duplicate header key is used.

Default Value: Not selected

Standardize error output

Select this checkbox to view the document in error view (a standardized error document will show up in the error view)—error, reason, resolution, stack trace and original.

Default value: Not selected

Route all exceptions to error view

Select this checkbox to route the Snap exceptions generated by WSDL Url, Service Name, Endpoint and Operation properties to the error view and successfully execute the pipeline execution.

Default value: Not selected

Import WSDL documents

Select this checkbox to import

WSDL documents are

the external documents while reading the WSDL file. The files that are declared with tag name wsdl:import & xs:import are retrieved and processed.

If it

 If this checkbox is not selected, then the

imported WDSL documents

external documents that are required for WSDL are ignored.

Default value: Selected

Transfer type


The Snap uses each input document as a body of one SOAP request. There are two ways of transferring the request body to the endpoint: 'Chunked transfer encoding' or 'Calculate content length'. If 'Chunked transfer encoding' is selected and when the message size is greater than 4KB, the SOAP request will be sent using chunked transfer encoding. Otherwise, the request will not be chunked and the Content-Length header will be included in the request.

If a SOAP endpoint does not support 'Chunked transfer encoding', this property should be set to 'Calculate content length'. If the endpoint responds with an error of HTTP status code "411 Length Required", the Snap automatically retries the request with 'Calculate content length' mode.

Default value:  Chunked transfer encoding
Example: Calculate content length

Library API

This property enables Snap execution over HTTP. Use the appropriate library to utilize the latest SOAP capabilities. The available options are:

  • Apache HttpComponents
  • Apache CXF

Default value: Apache CXF
Example: Apache HttpComponents

Note

We recommend using HttpComponents, because Apache no longer maintains CXF v2.



Multiexcerpt macro
nameSnap Execution

Snap Execution



Multiexcerpt macro
nameExecution_Detail_Write

Select one of the three modes in which the Snap executes. Available options are:

  • Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.
  • Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.
  • Disabled: Disables the Snap and all Snaps that are downstream from it.

Default value: Execute only
Example: Validate & Execute

...

Below is a snapshot of the output from both output views:


output0 (default output)
debug
Image Modified
Image Modified


...

See Also

...