This discussion is archived
0 Replies Latest reply: Jun 14, 2013 2:35 AM by user980230 RSS

Name Space problem

user980230 Newbie
Currently Being Moderated

Hello everyone,

 

I have a problem with my BI system.

 

I have a web service from where I have to take the data to make some reports. I have designed a report, I have a designed the data set properly, and I can get the data correctly when I need the "data sample" as an XML. But when I try to view the report as a PDF the report seems empty (I only see an empty data table) although I can see the data inside the interactive view.

 

The source of the problem seems to be the name space used in the XML of the SOAP response.

The XML has this format (I have checked it with the soapUI):

 

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

   <soap:Body>

      <ns2:getDailyRevenueReconciliationResponse xmlns:ns2="http://transactions.services.rpt.tolling.telvent.com/">

         <return>

            <rows>

               <row>

                  <dayOfRevenueReconciliation>2013-06-13T19:56:04.998+02:00</dayOfRevenueReconciliation>

                  <type>TAG</type>

                  <collected>1100.0</collected>

                  <reconcilied>1090.0</reconcilied>

                  <difference>10.0</difference>

               </row>

               <row>

                  <dayOfRevenueReconciliation>2013-06-13T19:56:04.998+02:00</dayOfRevenueReconciliation>

                  <type>TAG</type>

                  <collected>100.0</collected>

                  <reconcilied>100.0</reconcilied>

                  <difference>0.0</difference>

               </row>

               <row>

                  <dayOfRevenueReconciliation>2013-06-13T19:56:04.998+02:00</dayOfRevenueReconciliation>

                  <type>TAG</type>

                  <collected>230.0</collected>

                  <reconcilied>110.0</reconcilied>

                  <difference>120.0</difference>

               </row>

               <row>

                  <dayOfRevenueReconciliation>2013-06-13T19:56:04.998+02:00</dayOfRevenueReconciliation>

                  <type>TAG</type>

                  <collected>100.0</collected>

                  <reconcilied>90.0</reconcilied>

                  <difference>10.0</difference>

               </row>

               <row>

                  <dayOfRevenueReconciliation>2013-06-13T19:56:04.998+02:00</dayOfRevenueReconciliation>

                  <type>TAG</type>

                  collected>340.0</collected>

                  <reconcilied>340.0</reconcilied>

                  <difference>0.0</difference>

               </row>

              </rows>

         </return>

      </ns2:getDailyRevenueReconciliationResponse>

   </soap:Body>

</soap:Envelope>

 

I have tried to give to BI publisher the XML file with the response as a dataset, changing this tag:

 

<ns2:getDailyRevenueReconciliationResponse xmlns:ns2="http://transactions.services.rpt.tolling.telvent.com/">


with this one:


<getDailyRevenueReconciliationResponse">


And it works, but I cant change the response of the web service.


I have done another test, I have tried to solve it with the XPATH parameter when I make the dataset with the web service, but it looks like it only recognizes the '/' like XPATH, so if I use something like '/ns2:getDailyRevenueReconciliationResponse' or '//rows' it doesn´t work.

 

Thanks in advance...