Experts,
we have an interface between oracle Sales cloud and EBS through SOA middle ware. SOA was able to Process sales cloud standard web service outputs and push to EBS. We are trying to use an Oracle BI answer Report web service out put to SOA using this service.
The Method am getting this out put is execute XML query, Is this an XML output? I am able to process standard webservice output in XML format.
below the sample SOAP UI response and can someone tell me how to process this?
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:sawsoap="urn://oracle.bi.webservices/v7">
<soap:Body>
\<sawsoap:executeXMLQueryResult>
\<sawsoap:return xsi:type="sawsoap:QueryResults">
\<sawsoap:rowset xsi:type="xsd:string">\<!\[CDATA\[\<rowset xmlns="urn:schemas-microsoft-com:xml-analysis:rowset">
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:saw-sql="urn:saw-sql" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset">
<xsd:complexType name="Row">
<xsd:sequence>
<xsd:element name="Column0" type="xsd:string" minOccurs="0" maxOccurs="1" saw-sql:type="varchar" saw-sql:sqlFormula=""Sales - CRM Opportunities and Products Real Time"."Opportunity Extension"."Extension Attribute Character 034"" saw-sql:displayFormula=""Opportunity Extension"."Sales Order #"" saw-sql:aggregationRule="none" saw-sql:aggregationType="nonAgg" saw-sql:tableHeading="Opportunity Extension" saw-sql:columnHeading="Sales Order #" saw-sql:isDoubleColumn="false" saw-sql:columnID="cfac6979348661726"/>
<xsd:element name="Column1" type="xsd:string" minOccurs="0" maxOccurs="1" saw-sql:type="varchar" saw-sql:sqlFormula=""Sales - CRM Opportunities and Products Real Time"."Opportunity Extension"."Extension Attribute LOV 035"" saw-sql:displayFormula=""Opportunity Extension"."Sales Order Status"" saw-sql:aggregationRule="none" saw-sql:aggregationType="nonAgg" saw-sql:tableHeading="Opportunity Extension" saw-sql:columnHeading="Sales Order Status" saw-sql:isDoubleColumn="true" saw-sql:columnID="c5145badbbb965706"/>
</xsd:sequence>
</xsd:complexType>
</xsd:schema>
<Row>
<Column0>123</Column0>
<Column1>won</Column1>
</Row>
<Row>
<Column0>567</Column0>
<Column1>closed</Column1>
</Row>
</rowset>]]></sawsoap:rowset>
\<sawsoap:queryID xsi:type="xsd:string">RSXS2\_1\</sawsoap:queryID>
\<sawsoap:finished xsi:type="xsd:boolean">true\</sawsoap:finished>
\</sawsoap:return>
\</sawsoap:executeXMLQueryResult>
</soap:Body>
</soap:Envelope>
The below format is having issue to parse the XML to process.
currently it can process the out put as below format
Thanks
Matt