Issue: webservices on view form, does not return field as null or blank. 1. Is this because its a view form or bug? Should return in example below, U1 and T1 = NULL, vs not return the complete string.
Local Installs : ARS 7.5.p4. on Oracle 11g on UNIX aiv 6.1.7 Websphere 6 on UNIX MT 7.5p4 Developer Studio 7.6. sp 4 Process: 1. We have created a view form to read the Status History Table, H Table called Test_StatusHistory 2. Then create a getlist WebService to Test_StatusHistory called WS_Test_VeiwForm_StatusHistory 3. Using Soap UI to consume this webservice. If the incident status history that is being querries, did not contain a Re-Assigned information, the webservices does not return that field. example : of not returning U1, T1 <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> <soapenv:Body> <ns0:New_GetList_Operation_0Response xmlns:ns0="urn:WS_Test_VeiwForm_StatusHistory"> <ns0:getListValues> <ns0:Request_ID>004288730</ns0:Request_ID> <ns0:T0>1348170746</ns0:T0> <ns0:T2>1348253668</ns0:T2> <ns0:T3>1349717925</ns0:T3> <ns0:U0>tivoli</ns0:U0> <ns0:U2>AR_ESCALATOR</ns0:U2> <ns0:U3>user1</ns0:U3> </ns0:getListValues> </ns0:New_GetList_Operation_0Response> </soapenv:Body> </soapenv:Envelope> example: Returning all entries in the H table <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> <soapenv:Body> <ns0:New_GetList_Operation_0Response xmlns:ns0="urn:WS_Test_VeiwForm_StatusHistory"> <ns0:getListValues> <ns0:Request_ID>004288880</ns0:Request_ID> <ns0:T0>1350330494</ns0:T0> <ns0:T1>1350330549</ns0:T1> <ns0:T2>1350330562</ns0:T2> <ns0:T3>1350330599</ns0:T3> <ns0:T4>1350330575</ns0:T4> <ns0:U0>dad00q0</ns0:U0> <ns0:U1>dad00q0</ns0:U1> <ns0:U2>dad00q0</ns0:U2> <ns0:U3>dad00q0</ns0:U3> <ns0:U4>dad00q0</ns0:U4> </ns0:getListValues> </ns0:New_GetList_Operation_0Response> </soapenv:Body> </soapenv:Envelope> WSDL ----------------------------------------------------------------------------- <?xml version="1.0" encoding="UTF-8" ?> - <wsdl:definitions targetNamespace="urn:WS_Test_VeiwForm_StatusHistory" xmlns:s0="urn:WS_Test_VeiwForm_StatusHistory" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"; xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"; xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"; xmlns:xsd="http://www.w3.org/2001/XMLSchema";> - <wsdl:types> - <xsd:schema elementFormDefault="qualified" targetNamespace="urn:WS_Test_VeiwForm_StatusHistory"> <xsd:element name="New_GetList_Operation_0" type="s0:InputMapping1" /> - <xsd:complexType name="InputMapping1"> - <xsd:sequence> <xsd:element name="Qualification" type="xsd:string" /> <xsd:element name="startRecord" type="xsd:string" /> <xsd:element name="maxLimit" type="xsd:string" /> </xsd:sequence> </xsd:complexType> <xsd:element name="New_GetList_Operation_0Response" type="s0:OutputMapping1" /> - <xsd:complexType name="OutputMapping1"> - <xsd:sequence> - <xsd:element maxOccurs="unbounded" name="getListValues"> - <xsd:complexType> - <xsd:sequence> <xsd:element name="Request_ID" type="xsd:string" /> <xsd:element minOccurs="0" name="T0" type="xsd:int" /> <xsd:element minOccurs="0" name="T1" type="xsd:int" /> <xsd:element minOccurs="0" name="T2" type="xsd:int" /> <xsd:element minOccurs="0" name="T3" type="xsd:int" /> <xsd:element minOccurs="0" name="T4" type="xsd:int" /> <xsd:element minOccurs="0" name="U0" type="xsd:string" /> <xsd:element minOccurs="0" name="U1" type="xsd:string" /> <xsd:element minOccurs="0" name="U2" type="xsd:string" /> <xsd:element minOccurs="0" name="U3" type="xsd:string" /> <xsd:element minOccurs="0" name="U4" type="xsd:string" /> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> <xsd:element name="AuthenticationInfo" type="s0:AuthenticationInfo" /> - <xsd:complexType name="AuthenticationInfo"> - <xsd:sequence> <xsd:element name="userName" type="xsd:string" /> <xsd:element name="password" type="xsd:string" /> <xsd:element minOccurs="0" name="authentication" type="xsd:string" /> <xsd:element minOccurs="0" name="locale" type="xsd:string" /> <xsd:element minOccurs="0" name="timeZone" type="xsd:string" /> </xsd:sequence> </xsd:complexType> </xsd:schema> </wsdl:types> - <wsdl:message name="ARAuthenticate"> <wsdl:part element="s0:AuthenticationInfo" name="parameters" /> </wsdl:message> - <wsdl:message name="New_GetList_Operation_0SoapOut"> <wsdl:part element="s0:New_GetList_Operation_0Response" name="parameters" /> </wsdl:message> - <wsdl:message name="New_GetList_Operation_0SoapIn"> <wsdl:part element="s0:New_GetList_Operation_0" name="parameters" /> </wsdl:message> - <wsdl:portType name="TestPortType"> - <wsdl:operation name="New_GetList_Operation_0"> <wsdl:input message="s0:New_GetList_Operation_0SoapIn" /> <wsdl:output message="s0:New_GetList_Operation_0SoapOut" /> </wsdl:operation> </wsdl:portType> - <wsdl:binding name="TestSoapBinding" type="s0:TestPortType"> <soap:binding style="document" transport="http://schemas.xmlsoap.org/soap/http"; /> - <wsdl:operation name="New_GetList_Operation_0"> <soap:operation soapAction="urn:WS_Test_VeiwForm_StatusHistory/New_GetList_Operation_0" style="document" /> - <wsdl:input> <soap:header message="s0:ARAuthenticate" part="parameters" use="literal" /> <soap:body use="literal" /> </wsdl:input> - <wsdl:output> <soap:body use="literal" /> </wsdl:output> </wsdl:operation> </wsdl:binding> - <wsdl:service name="WS_Test_VeiwForm_StatusHistoryService"> - <wsdl:port binding="s0:TestSoapBinding" name="TestSoap"> <soap:address location="http://<domain>/arsys/services/ARServiceserver=<server>&webService=WS_Test_VeiwForm_StatusHistory" /> </wsdl:port> </wsdl:service> </wsdl:definitions> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
