Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Problem with Web Service Data Source
twizansk
I am creating a report using a web service data source. The service works fine (as confirmed with soapUI) but BIRT does not retreive the data. Specifically, when referencing the data set in a report element, no data is displayed and, after creating the data set, if I click "Show Sample Data" an empty column is displayed.<br />
<br />
The WSDL for my service is <br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
<wsdl:definitions xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:sch="http://www.mycompany.com/ws" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tns="http://www.mycompany.com/ws" targetNamespace="http://www.mycompany.com/ws">
<wsdl:types>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.mycompany.com/ws">
<xs:element name="ReportRequest">
<xs:complexType>
<xs:all>
<xs:element name="id" type="xs:long"/>
</xs:all>
</xs:complexType>
</xs:element>
<xs:element name="ReportResponse">
<xs:complexType>
<xs:all>
<xs:element name="status" type="xs:string"/>
</xs:all>
</xs:complexType>
</xs:element>
</xs:schema>
</wsdl:types>
<wsdl:message name="ReportResponse">
<wsdl:part element="tns:ReportResponse" name="ReportResponse">
</wsdl:part>
</wsdl:message>
<wsdl:message name="ReportRequest">
<wsdl:part element="tns:ReportRequest" name="ReportRequest">
</wsdl:part>
</wsdl:message>
<wsdl:portType name="Report">
<wsdl:operation name="Report">
<wsdl:input message="tns:ReportRequest" name="ReportRequest">
</wsdl:input>
<wsdl:output message="tns:ReportResponse" name="ReportResponse">
</wsdl:output>
</wsdl:operation>
</wsdl:portType>
<wsdl:binding name="ReportSoap11" type="tns:Report">
<soap:binding style="document" transport="http://schemas.xmlsoap.org/soap/http"/>
<wsdl:operation name="Report">
<soap:operation soapAction=""/>
<wsdl:input name="ReportRequest">
<soap:body use="literal"/>
</wsdl:input>
<wsdl:output name="ReportResponse">
<soap:body use="literal"/>
</wsdl:output>
</wsdl:operation>
</wsdl:binding>
<wsdl:service name="ReportService">
<wsdl:port binding="tns:ReportSoap11" name="ReportSoap11">
<soap:address location="http://localhost:8080/api/reportService/"/>
</wsdl:port>
</wsdl:service>
</wsdl:definitions></pre>
<br />
A sample request sent via soapUI:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
<?xml version="1.0"?>
<SOAP-ENV:Envelope
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<m:ReportRequest xmlns:m="http://www.mycompany.com/ws">
<m:id xsi:type="xsd:long">8</m:id>
</m:ReportRequest>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
</pre>
<br />
The response:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Header/>
<SOAP-ENV:Body>
<ns2:ReportResponse xmlns:ns2="http://www.mycompany.com/ws">
<ns2:status>passed</ns2:status>
</ns2:ReportResponse>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
</pre>
<br />
My Data set properties are:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
row XPath: /SOAP-ENV:Envelope/SOAP-ENV:Body/ReportResponse
column XPath: ?/status?
</pre>
<br />
Any one know what's going on?<br />
<br />
Thanks
Find more posts tagged with
Comments
There are no comments yet