SSRS Webservice Data Source and ElementPath Question

• irtaza

  SSC Rookie

  Points: 39

  More actions

  December 14, 2012 at 4:54 am

  #266104

  I am using http://www.webservicex.com/stockquote.asmx webservice to test how webservice source works in SSRS. I can't figure out how to parse the webservice result using Elementpath. I am getting two columns: xmlns and GetQuoteResult if I use <ElementPath>*</ElementPath>.

  The query is:

  <Query>

  <Method Name="GetQuote" Namespace="http://www.webserviceX.NET/" >

  <Parameters>

  <Parameter Name="symbol">

  <DefaultValue>RBS.L</DefaultValue>

  </Parameter>

  </Parameters>

  </Method>

  <SoapAction>http://www.webserviceX.NET/GetQuote</SoapAction>

  <ElementPath xmlns="http://www.webserviceX.NET/">*</ElementPath>

  </Query>

  The webservice returns:

  <string xmlns="http://www.webserviceX.NET/">

  <StockQuotes><Stock><Symbol>RBS.L</Symbol>

  <Last>302.107</Last><Date>12/14/2012</Date><Time>6:32am</Time>

  <Change>+1.907</Change><Open>300.00</Open><High>303.20</High><Low>299.55</Low>

  <Volume>2735550</Volume><MktCap>19.592B</MktCap><PreviousClose>300.20</PreviousClose>

  <PercentageChange>+0.64%</PercentageChange><AnnRange>185.08 - 302.284</AnnRange>

  <Earns>-0.457</Earns><P-E>N/A</P-E><Name>ROYAL BK SCOTL GR</Name></Stock></StockQuotes>

  </string>

  However in SSRS query designer I get two columns:

  Column=xmlns;Value="http://www.webserviceX.NET/"

  and

  Column=GetQuoteResult; value ="<StockQuotes><Stock><Symbol>RBS.L</Symbol>......</Stock></StockQuotes>