Hi All

I consumed soap a webservice and was able to call it successfully, however the response returned in outsystem, rows and values are empty.


Checked with the webservice hosting team, they traced their logs and found that value are indeed return in the response xml.


Webservice XML generated at server side:

<?xml version="1.0"?>

<QAS_GETQUERYRESULTS_RESP_MSG xmlns="http://xmlns.oracle.com/Enterprise/Tools/schemas/QAS_GETQUERYRESULTS_RESP_MSG.VERSION_1">

<query numrows="1" queryname="BNF_HELLO_TEST_QRY" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="">

<row rownumber="1">

<EXPR2_2>

<![CDATA[Hello]]>

</EXPR2_2>

</row>

</query>

</QAS_GETQUERYRESULTS_RESP_MSG>


Webservice XML generated at outsystems integration logs:

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope
    xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Body>
        <QAS_GETQUERYRESULTS_RESP_MSG
            xmlns="http://xmlns.oracle.com/Enterprise/Tools/schemas/QAS_GETQUERYRESULTS_RESP_MSG.VERSION_1">
            <query numrows="1" queryname="BNF_HELLO_TEST_QRY"
                xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="">
                <row rownumber="1">
                    <EXPR2_2></EXPR2_2>
                </row>
            </query>
        </QAS_GETQUERYRESULTS_RESP_MSG>
    </soapenv:Body>
</soapenv:Envelope>


Why do I receive a response that does not have the value when the webservice server sends a response with value.


Please give your advice and help. Thanks!

Hi Michael Chua,

have you tested your api using google chrome postman tool?

are you getting the proper response?

response structure is same?

do you have test data to check your api response, if you have then test it using postman.

Regards,

MJ

Manish Jawla wrote:

Hi Michael Chua,

have you tested your api using google chrome postman tool?

are you getting the proper response?

response structure is same?

do you have test data to check your api response, if you have then test it using postman.

Regards,

MJ

Hi Manish, i'm unable to use postman to call the SOAP webservice. Chrome gives me 

ERR_SSL_PROTOCOL_ERROR


is there any other way to troubleshoot this?



Hi Michael,

Please watch some tutorials on how to use postman for testing webservice on utube.

It will definitely help you and for future purpose also it will be helpful once you become comfortable with postman.

I know in beginning some people find challenges using it but its not that much tough.

Give another shot i hope it will help in identifying the root cause.

Regards,

MJ