Data sources from SOAP/xml web services

Data sources from SOAP/xml web services

Summary

The SOAP/XML web services connector offers all the necessary capabilities to connect to these types of sources. This option allows collecting data from SOAP/XML web services or configuring writing actions, for then creating data views and exhibiting them in the API methods.

To connect to a web service, you must go to Data Sources > From Web Service > SOAP/XML



Basic configuration

It is mandatory to complete the following data:

  1. Origin: is the URL or endpoint of your web service
  2. Method: Name of the method. It is the label below the Body label.
  3. Namespace: It is the nameSpace of your web service. It is indicated in the xmlns attribute of the method.
  4. Parameters: These are the referral parameters to the web service. They are the labels within the requested method, the label name is the parameter name, while their value is the parameter value. You can define these parameters as editable for exposing them in the method, or non-editable to avoid their exposure.
    Some web services have a list of values within a parameter. This is identified by new labels within the label representing the parameter. To work with value lists, you should enter the top label as a parameter name and its values under the structure LIST({"VALOR1","VALOR2"})


You can obtain this data from the web service "wsdl" (Web Services Description Language). In general, you can access the wsdl by adding "?wsdl" to your endpoint or URL.



Advanced configuration


In Advanced configuration, you can add other parameters in the case where they are necessary to access the service.

Route to data

Allows you to access the requested data table by indicating the XML attribute name.

To assemble the route, the XPath standard with its nodes for example: /bookstore/book/title. You can use online tools to identify your path to data:https://www.freeformatter.com/xpath-tester.html



Authentication

If authentication is necessary, you could enter the user name and contrast. These parameters must be entered in accordance with case studies.



This information is usually found on the same site from where it is desired obtain information or in the WSDL. You can also consult the administratorof the system responsible for web services.

Consider that SOAP may require user submission and contradictory as parameters of the query, and not as authentication credentials.


Effective advice

For SOAP/XML-type web services take into account:
The answer should be a swift XML. We support SOAP 1.2 web services. The default tables should be informed in the item, although if you wish you can specify a different item name in the path-to-data field.


    • Related Articles

    • Data sources from REST/json web services

      Summary The REST/JSON web services connector offers all the capabilities needed to connect to such sources. This option allows you to collect data from REST/JSON web services or configure writing actions, and then create data views and exhibit them ...
    • What are data sources

      Summary Data sources are the starting point for the data flow, from which data views and APIs methods are created. Below you can find data sources characteristics. Some basic concepts When we talk about data sources, we must consider the following: ...
    • Data sources from URLs

      Summary The URL connector allows you to collect data from HTTP(s) and FTP protocols. To collect data from a file hosted in a URL, you must go to Data sources > From URLs Configuration Enter a URL with a clear link from where you want to collect. ...
    • What is a data view

      Summary The platform does not require an off-line ETL process to extract data from the origins, but associated with the view, find a set of rules that the data engine interprets for check the source on demand or periodically, extract the data updated ...
    • Databases from Databases

      Summary The Databases connector offers all the capabilities needed to connect to such sources. This option allows you to collect data from different types of databases or configure writing actions, then create data views and exhibit them in your API. ...