nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Dynamic Web Service (XML) query

mfgjens

Hi @ all, 
 
I have now a Problem that I have to work with XML web service to retrieve Data for my Chart. 
My problem is that I have to work with a variable Data Source, which means that I have to find a information after a variable path. 
I am not sure if you know what I mean so I will give a example. 
 
<a class='bbc_url' href='http://example/example/123456'>http://example/example/123456</a> 
 
behind this path I can find a detailed information like: 
 
<a class='bbc_url' href='http://example/example/123456/link_nr'>http://example/example/123456/link_nr</a> 
 
so far so clear, but now I run into problems, because for the next information I need in my Chart I have to use another link like: 
 
<a class='bbc_url' href='http://example/example/234567'>http://example/example/234567</a> 
 
to get the next "link_nr" 
Has anyone a idea how i can handle this?? 
Maybe with a scripting Data Source or ....... 
I have right know not the right starting point to search for a solution :-( 
 
Thanks in advance, 
mfgjens

Find more posts tagged with

Comments

JasonW

mfgjens,

Are you saying you need to changes the wsdl url for different runs of the report?

Jason

mfgjens

Yes true, 
as i tried to described it in the example. 
 
But to make it clear.... 
 
info1 I find under: 
<a class='bbc_url' href='http://example/example/123456/link_nr'>http://example/example/123456/link_nr</a> 
 
info2 under: 
<a class='bbc_url' href='http://example/example/234567/link_nr'>http://example/example/234567/link_nr</a> 
 
The nr (123456) I try to receive from a normal SQL query which came from another MySQL DB.

JasonW

I am not sure I understand the issue, but have you tried to use the property binding expression. Open the web service data source. Select property binding and choose the wsdl url field and put an expression in like:

if( params["myselectionparameter"].value == "firstwsdl" ){
"http://www.webservicex.net/uszip.asmx?WSDL"
}else{
"http://www.webservicex.net/euzip.asmx?WSDL
}

mfgjens

Ok,
the property binding expression sound like a solution.
But I understand your code not completely and also, regarding the wsdl, it can by that I have to use 100 of different wsdl's.
I have to query a MySQL DB first to get a list of the numbers (123456 or 234567.........) and after this I have to use the numbers to create the wsdl.
Do you think, you can describe it more in Detail??
Sorry!!!

Regards,
mfgjens

JasonW

Does the WSDL change or just a parameter to the call?

mfgjens

Not the complete WSDL, as you can see the example, only one parameter (the number) will be changed (If I understand the meaning of WSDL right)

JasonW

Take a look at this article: 
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/461-birt-web-service-oda-article/'>BIRT Web Service ODA Article - Articles - BIRT Exchange</a> 
 
and this example in the wiki 
<a class='bbc_url' href='http://wiki.eclipse.org/Web_Service_Data_Source_(BIRT)'>Web Service Data Source (BIRT) - Eclipsepedia</a> 
 
Specifically look at parameters.

mfgjens

Ok,
I had a look to the two articles, but I can't find
a solution for my Problem out of the information
from this two articles :-(

Maybe you can give me a Code example or something like this???
Sorry :-(

Regards,
Jens

bhanley

In the parameter binding you have access to an expression editor. This gives you the power to construct the WSDL used in any number of ways. You do not need to simply select the WSDL from a list, you could in fact build the WSDL out in real time. 
 
Where and when are you getting the unique string that allows you to build out the WSDL? Is that a parameter selected by the user at run time? Is it determined as a part of an additional data set on the report? 
 
The following Java Script sample roughly walks you through building the WSDL out dynamically in the property binding expression editor. It assumes at some point you are assigning the unique string you need as a property on the report. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>var sWSDLRoot = "http://example/example/";
var sWSDLSuffix = "/n1";
var sUniqueWSDLID = this.getUserProperty("ID");

sWSDLRoot + sUniqueWSDLID + sWSDLSuffix;</pre>

mfgjens

Hi,
thanks for the answer.

The parameter is defined by an additional Dataset on the report.
The User has in this case nothing to the select during runtime.
In this case the script will be changed or??

Regards,
mfgjens