Web Service connector: Unable To Pull Data From Targeted Database

Hi Everyone,

Im trying to pull data from application database but failed. Web Service connector configuration and setting done. Test connection result success but when I try to preview schema database the table was empty.

Below is the configuration:


<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="[http://www.w3.org/2001/XMLSchema-instance"](http://www.w3.org/2001/XMLSchema-instance%22)
<UserListing xmlns="[http://tempuri.org/"](http://tempuri.org/%22) />

In my response configuration, I’ve tried a million different response mapping combos, trying to retrieve the “id” from this xml. Thank you in advance.

Please post an example of the response for the web service call that contains at least two accounts. Change sensitive information but don’t change the response structure.

Other observations:

  • Refrain from using “id” or “Id” as an account or group schema attribute
  • Add an “Accept” Header that describes the response content that the web service call will return
  • Sometimes for SOAP calls a “SOAPAction” Header is required with a value of “POST”. Pull the web service WSDL into SoapUI, run the web service call and review the sending Headers. Match the Headers with the Operation’s Header config.
  • Add a Root Path to the operation config. If you post an example response, people can assist with this config.
  • Add a Response Code (for example “2**”) to the operation config