Web Service connector: Unable To Pull Data From Targeted Database

[dausfadzlon (Muhammad Firdaus Norfadzlon)]

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:

Body:

<?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)
xmlns:xsd="[http://www.w3.org/2001/XMLSchema"](http://www.w3.org/2001/XMLSchema%22)
xmlns:soap12="[http://www.w3.org/2003/05/soap-envelope">](http://www.w3.org/2003/05/soap-envelope%22>)
<soap12:Body>
<UserListing xmlns="[http://tempuri.org/"](http://tempuri.org/%22) />
</soap12:Body>
</soap12:Envelope>

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.

[Paul_Meyer]

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