Using a Web Service Data Source

Hi,

I followed the example in the book "Le BIRT Expert's Guide to BIRT Best Practice" to create a Web Service data source. Everything worked fine when I did exactly what was described in the book. But then I tried to use a Sample SOAP response message and I get a HTTP response code 500. Here is what I have done:

It is a connection to a currency converter using

URL: http://www.webservicex.net/CurrencyConvertor.asmx?WSDL
SOAP End point: http://www.webservicex.net/CurrencyConvertor.asmx

For the DataSet I used

WSDL Operation: Currency Converter --> CurrencyConverterSOAP --> ConversionRate
SOAP Request: default SOAP Request
SOAP Response: This is the tricky part. I would like to "use the schema from response" as a "SOAP response schema" (second option in BIRT 3.7.2.)

For "Select Sample SOAP response message" I used the "Query Web Service at SOAP end point" option with "http://www.webservicex.net/CurrencyConvertor.asmx"

When I try to "Conntect now" I get the following error message:

"Server returned HTTP response code: 500 for URL: http://www.webservicex.net/CurrencyConvertor.asmx"

I also tried using "http://www.webservicex.net/CurrencyConvertor.asmx/ConversionRate?FromCurrency=USD&ToCurrency=EUR" which actually gives a result in the web browser but when trying to "connect now" it fails with the same error message:

"Server returned HTTP response code: 500 for URL: http://www.webservicex.net/CurrencyConvertor.asmx/ConversionRate?FromCurrency=USD&ToCurrency=EUR"

I tried to find a similar problem by searching in the internet but I coundn't find anything.

Any advise is greatly appreciated. Thank you in advance!

Find more posts tagged with

Comments

mwilliams

Are you sure you have access to this web service? I haven't looked at the book you're referencing, so I don't know if this is the web service used in it.

Let me know!

JanaF

Hi Michael,

I am pretty sure that I have access to the web service:

If I type the following URL in the web browser "http://www.webservicex.net/CurrencyConvertor.asmx/ConversionRate?FromCurrency=AUD&ToCurrency=EUR" I get a result.
Furthermore, the web service works at the runtime of BIRT (when I am using the preview-tab in the designer).

Like I described in the previous post, it just does not work when I press "connect now" in the data set tab.

mwilliams

When on the soap request step where you leave the default, if you choose the "Edit Parameter" button and set default values for the two parameters, you won't get the error when you choose the connect now button.

JanaF

Hi,

thank you for the help - the default parameter section was the solution.

JanaF

Hi,

I have got a follow-up question for this topic. In the example for the currency converter it is not necessary to use the option "use the schema from response", because "Use operation response schema defined in data source WSDL" works fine here. Is there an example where it is necessary to use "use the schema from response"? Maybe because the schema from the response is different from the schema defined in the data source WSDL?

The background of my question is the following:

For our company we would like to implement a web service which supplies the data for the report. As every report has different columns, the idea was to set up a request with the parameter "reportname" and the response then returns the sturcture/schema of that specific report (by using the option "use the schema from response").
We cannot use the option "Use operation response schema defined in data source WSDL" here, because the response schema may be different for every report and therefore cannot be contained in the static data source WSDL.
To successfully implement such a web service it would be great to get an example for something similar.

Thank you in advance

Jana