Author Message
cooki
Joined: May 18, 2015
Messages: 16
Offline
Hi All,

we are trying to import WSDL of simple web service to DIW of ACCS. The web service has one input parameter of string and 3 output params of string. We import it successfully but it creates function with 3 params:

CALL Test.GetData("?","?","?")

So we test the call of this function by replacing the first question mark and delete those two remaining (qotest left there):

CALL Test.GetData("123","","")

The test is successfull but the response which should return 3 values is bad:

TEST EXECUTE THE SQL STATEMENT ON DSN: WebServices...
Set test Statement in Registry - Successful.
Execute SQL - Successful.
Returned Data: SUCCESS; 11111111111111; ; ; ; ; ; ; ;
RESULT: PASSED!

The SOAP ui which we uses as MOCK service shows that request comes OK:


<?xml version="1.0" encoding="UTF-8" ?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:s='http://www.w3.org/2001/XMLSchema'>
<SOAP-ENV:Body><Get_Data xmlns="Data2CC"><CLID>1</CLID></Get_Data></SOAP-ENV:Body>
</SOAP-ENV:Envelope>


And response goes out ok too:


<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dat="Data2CC">
<soapenv:Header/>
<soapenv:Body>
<Get_DataResponse>
<Priorita>11111111111111</Priorita>
<Ref1>9999999999</Ref1>
<Ref2>888888888888</Ref2>
</Get_DataResponse>
</soapenv:Body>
</soapenv:Envelope>


We thought that this is and issue of DIW but when we use this WS call in OD, it behaves the same, just 1st value of response is returned... :/

Here is the WSDL:


<?xml version="1.0" encoding="UTF-8"?>

-<wsdl:definitions xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" xmlns:tns="Data2CC" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" targetNamespace="Data2CC">


-<wsdl:types>


-<s:schema targetNamespace="Data2CC" elementFormDefault="qualified">


-<s:element name="Get_Data">


-<s:complexType>


-<s:sequence>

<s:element name="CLID" type="s:string"/>

</s:sequence>

</s:complexType>

</s:element>


-<s:element name="Get_DataResponse">


-<s:complexType>


-<s:sequence>

<s:element name="Priorita" type="s:string"/>

<s:element name="Ref1" type="s:string"/>

<s:element name="Ref2" type="s:string"/>

</s:sequence>

</s:complexType>

</s:element>

</s:schema>

</wsdl:types>


-<wsdl:message name="Get_DataSoapIn">

<wsdl:part name="parameters" element="tns:Get_Data"> </wsdl:part>

</wsdl:message>


-<wsdl:message name="Get_DataSoapOut">

<wsdl:part name="parameters" element="tns:Get_DataResponse"> </wsdl:part>

</wsdl:message>


-<wsdl:portType name="2CCDataSoap">


-<wsdl:operation name="Get_Data">

<wsdl:documentation>Exchange of data - CC</wsdl:documentation>

<wsdl:input message="tns:Get_DataSoapIn"> </wsdl:input>

<wsdl:output message="tns:Get_DataSoapOut"> </wsdl:output>

</wsdl:operation>

</wsdl:portType>


-<wsdl:binding name="2CCDataSoap" type="tns:2CCDataSoap">

<soap:binding transport="http://schemas.xmlsoap.org/soap/http"/>


-<wsdl:operation name="Get_Data">

<soap:operation style="document" soapAction="2CCDataSoap/Get_Data"/>


-<wsdl:input>

<soap:body use="literal"/>

</wsdl:input>


-<wsdl:output>

<soap:body use="literal"/>

</wsdl:output>

</wsdl:operation>

</wsdl:binding>


-<wsdl:service name="2CCData">


-<wsdl:port name="2CCDataSoap" binding="tns:2CCDataSoap">

<soap:address location="http://IP:8088/mock2CCDataSoap"/>

</wsdl:port>

</wsdl:service>

</wsdl:definitions>


Anyone has expirience with WS in ACCS?

Thanks
JohnMcLoughlin
Joined: Nov 3, 2010
Messages: 131
Offline
Hello,
I recommend you experiment with Provider.exe on ACCS.
The best way to get more detailed analysis of your specific issue would be to log a DevConnect ticket.
John
cooki
Joined: May 18, 2015
Messages: 16
Offline
Hi John,

we figure this out finally. The problem is that if you have more than 1 req/resp params, you have to wrap them inside an object.
Now it works :)

c.
WillardC
Joined: May 29, 2019
Messages: 1
Offline
Hello team, I need help with connecting ACCS DB to a third party system for data collection. The objective is to get more detailed and easy to use reports with more analysis. What is the default password to connect to the ACCS DB.
Go to:   
Mobile view