XML data source with a sequence of URLs? [message #495993] |
Fri, 06 November 2009 22:30 |
Eclipse User |
|
|
|
Originally posted by: rbbnjmn.yahoo.com
Hi,
I have XML data sources, URLs returning XML. Most of these take
start/end date parameters. One very interesting source returns data one
day at a time.
I'd like to set up an XML data source that in effect processes a
sequence of URLs set up as a range of dates. A simple merge of the
resulting documents will be fine.
Is something like this possible?
Should I try using a Scripted data source instead?
Thanks!
Roy
|
|
|
Re: XML data source with a sequence of URLs? [message #496337 is a reply to message #495993] |
Mon, 09 November 2009 18:11 |
|
Roy,
You can do this several ways. One way would be to use a normal data set
or scripted data that iterates over all the urls. If the return columns
are always the same for each url just different values then you could
nest your xml dataset in a table that is tied to the first datatset. If
you are using 2.5.1 you may be able to use xml dataset params or script
in the beforeOpen to modify the query for the nested dataset/table that
is getting the xml data.
Jason
Roy Benjamin wrote:
> Hi,
> I have XML data sources, URLs returning XML. Most of these take
> start/end date parameters. One very interesting source returns data one
> day at a time.
>
> I'd like to set up an XML data source that in effect processes a
> sequence of URLs set up as a range of dates. A simple merge of the
> resulting documents will be fine.
>
> Is something like this possible?
>
> Should I try using a Scripted data source instead?
>
> Thanks!
>
> Roy
|
|
|
Re: XML data source with a sequence of URLs? [message #496686 is a reply to message #496337] |
Tue, 10 November 2009 22:30 |
Eclipse User |
|
|
|
Originally posted by: rbbnjmn.yahoo.com
Thanks Jason,
I've used the beforeOpen() for other XML reports to substitute parameter
values in the URL. I am confused how I could iterate of a set of URLs
in the beforeOpen though...
Thanks
Roy
Jason Weathersby wrote:
> Roy,
>
> You can do this several ways. One way would be to use a normal data set
> or scripted data that iterates over all the urls. If the return columns
> are always the same for each url just different values then you could
> nest your xml dataset in a table that is tied to the first datatset. If
> you are using 2.5.1 you may be able to use xml dataset params or script
> in the beforeOpen to modify the query for the nested dataset/table that
> is getting the xml data.
>
> Jason
>
> Roy Benjamin wrote:
>> Hi,
>> I have XML data sources, URLs returning XML. Most of these take
>> start/end date parameters. One very interesting source returns data
>> one day at a time.
>>
>> I'd like to set up an XML data source that in effect processes a
>> sequence of URLs set up as a range of dates. A simple merge of the
>> resulting documents will be fine.
>>
>> Is something like this possible?
>>
>> Should I try using a Scripted data source instead?
>>
>> Thanks!
>>
>> Roy
|
|
|
Re: XML data source with a sequence of URLs? [message #496896 is a reply to message #496686] |
Wed, 11 November 2009 16:31 |
|
Roy,
You would not iterate in the beforeOpen. You have an outer table that
iterates over a set of URLs(Maybe from a Scripted Dataset). Within you
table you would nest your xml datasource. Its beforeOpen script could
reference a JavaScript var that is created in the outter tables row
onCreate. Does this make sense?
Jason
Roy Benjamin wrote:
> Thanks Jason,
>
> I've used the beforeOpen() for other XML reports to substitute parameter
> values in the URL. I am confused how I could iterate of a set of URLs
> in the beforeOpen though...
>
> Thanks
>
> Roy
>
> Jason Weathersby wrote:
>> Roy,
>>
>> You can do this several ways. One way would be to use a normal data
>> set or scripted data that iterates over all the urls. If the return
>> columns are always the same for each url just different values then
>> you could nest your xml dataset in a table that is tied to the first
>> datatset. If you are using 2.5.1 you may be able to use xml dataset
>> params or script in the beforeOpen to modify the query for the nested
>> dataset/table that is getting the xml data.
>>
>> Jason
>>
>> Roy Benjamin wrote:
>>> Hi,
>>> I have XML data sources, URLs returning XML. Most of these take
>>> start/end date parameters. One very interesting source returns data
>>> one day at a time.
>>>
>>> I'd like to set up an XML data source that in effect processes a
>>> sequence of URLs set up as a range of dates. A simple merge of the
>>> resulting documents will be fine.
>>>
>>> Is something like this possible?
>>>
>>> Should I try using a Scripted data source instead?
>>>
>>> Thanks!
>>>
>>> Roy
|
|
|
Powered by
FUDForum. Page generated in 0.03202 seconds