Forums BIRT Reports Webservice Data Source

This topic contains 2 replies, has 2 voices, and was last updated by  debbie_harry 2 years, 6 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #133

    debbie_harry
    Participant

    Hi All,
    Need help for one of the use case. I am using WebService Data Source and have multiple table to map with webservice response.
    Problem Statement:
    I am using multiple data set to map for diff tables. The issue is each data set uses same data source (webservice datasource) and fires multiple webservice request to fetch the same data.
    Sample resposne:
    <test>
    <Miti>
    <Factors>
    <Factor>testFactor1</Factor>
    <Remarks>Factor Remarks</Remarks>
    </Factors>
    <Factors>
    <Factor>testFactor2</Factor>
    <Remarks>Factor Remarks</Remarks>
    </Factors>
    </Miti>
    <Aggr>
    <Factors>
    <Factor>testFactor3</Factor>
    <Remarks>Factor Remarks</Remarks>
    </Factors>
    <Factors>
    <Factor>testFactor4</Factor>
    <Remarks>Factor Remarks</Remarks>
    </Factors>
    <Factors>
    <Factor>testFactor3</Factor>
    <Remarks>Factor Remarks</Remarks>
    </Factors>
    <Factors>
    <Factor>testFactor4</Factor>
    <Remarks>Factor Remarks</Remarks>
    </Factors>
    </Aggr>
    </test>
    From above response the nested xml is mapped to table . How i can achieve this using only one SOAP Request. Also i would like to understand how i can store the nested XML part in variable. i tried lot of options but didn’t find much on this.
    Request help with any sample code or link .

    I am using BIRT with eclipse plugin

    -Thanks

    #134

    joe_dallesandro
    Participant

    You can easily read in your XML into an XML primitive data type once, and reuse it in scripted data sources / data sets.

    #135

    debbie_harry
    Participant

    Thanks. I will go through the link and give a try in my code.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.