Layer2 Data Provider for SOAP Web Services - Specification

 

SOAP Web Services data can be connected and synchronized with almost any other data sources, including SharePoint, Office 365, Exchange, Dynamics, SQL and others codeless using the Layer2 Cloud Connector via the Layer2 Data Provider for SOAP Web Services. The article below gives a short specification and usage samples of the data provider.

 

The Layer2 Data Provider for SOAP Web Services is included in the Layer2 Cloud Connector distribution package. It connects to SAOP web services based on their WSDL. It only supports read operations.

 

soap codeless data integration synchronization layer2

Layer2 Data Provider for SOAP Web Services - Data Queries

 

The Layer2 Data Provider for SOAP Web Services supports a slightly different syntax than SQL to query the items from the web service as described below.

 

SELECT [Fields] FROM [Operation]([Parameters])

 

 

  • The list of fields can either contain a wildcard (*) or a comma-separated list of property names returned by the web service method. Furthermore it is possible to rename the fields by using the SQL alias-syntax, i.e. SELECT Companyname AS cname, would select the contents of property Companyname and populate it as a field named cname in the result set.
  • The operation part specifies the operation to to use for item retrieval.
  • The parameters part, which is enclosed in parentheses, is optional and contains a comma-separated list of the parameters the operation expects.

Layer2 Data Provider for SOAP Web Services - Restrictions

 

​The Layer2 Data Provider for SOAP Web Services is still BETA and supports web services only under the following conditions:

 

  • The WSDL has to be compliant to WS-I Basic Profile.
  • The web services requires no authentication or windows authentication (username and password). Custom authentication mechanisms (i.e. session-id or token based) are not supported at this time. Please contact [email protected], if you have any specific requirements to implement and add.
  • Operation parameters are of simple type (i.e. string, integer, etc.). Parameters of complex types defined in the WSDL or of type “any” are not supported.
  • The result returned from the operation does not contain multi-occurrence properties. If it does, these properties will be skipped (omitted) and a warning will be raised.
  • The service cannot have defined Policies to be followed as these are not supported.

Note that the provider only supports read operations. It could be used for uni-directional synchronization with other supported systems.

Layer2 Data Provider for SOAP Web Services - Connection Strings

 

​A typical connection string for the Layer2 Data Provider for SOAP Web Services looks like:

 

Url=myUrlToWebService;User=MyUsername;Password=myPassword;Protocol=mySoapVersion

 

 

With this connection string, the provider will automatically connect with the given credentials to discover the WSDL by the given url. Full list of connection string parameters for the provider:

 

  • URL: This is the URL of the web service. This setting is mandatory.
  • USER: The name of the user to authenticate with against the web service. This setting is optional.
  • PASSWORD: The password of the user to authenticate with against the web service. This setting is optional.
  • PROTOCOL: This settings specifies the SOAP protocol version to use. It is optional, if it isn’t set, the protocol version Soap12 is used by default. You can determine the protocol from the namespace definitions in the web service’s WSDL.

Layer2 Data Provider for SOAP Web Services - Sample Usage

 

Note that all samples are public web services not related to Layer2 in any way and they are possibly not available at any time.

 

Simple SOAP sample:

 

Connection String:

 

url=http://www.predic8.com:8080/crm/CustomerService;Protocol=Soap

 

Data Query:

 

select person.id as PersonNo,* from getAll

 

 

SOAP-Web-Services-Integration-Synchronization-Layer2-3.png

 

Fig. Layer2 Cloud Connector example configuration to connect to a SOAP Web Service.

 

 

SOAP Sample with Parameters:

 

Connection String:

url=http://www.thomas-bayer.com/axis2/services/BLZService

 

Data Query:

Select bezeichnung, bic, ort from getBank(23051610)

 

 

SOAP-Web-Services-Integration-Synchronization-Layer2-2.png

 

Fig. Layer2 Cloud Connector example configuration to connect to a SOAP Web Service using parameters.

 

Can't find what you are looking for? Please contact [email protected] for free pre-sales support.

Layer2 Data Provider for SOAP Web Services - Next Steps

 

​The Layer2 Data Provider for SOAP Web Services can be downloaded after registration as part of the Layer2 Cloud Connector package from the Layer2 Cloud Connector home page.

Ready to go next steps?

Icon for Product Regsitration - Layer2 leading solutions

Register for free download.

Keep your Sharepoint in sync. Download and try today.

Contact Us Icon for Layer2 leading solutions

Questions? Contact us.

We are here to help. Contact us and our consulting will be happy to answer your questions.