Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
stjernvd
Partner - Creator
Partner - Creator

Using web-services interactively?

Hi,

I have been trying to make the 'get stock quote' from this website be dynamic in my dashboard...

StockQuote Web Service

Which method out of SOAP, GET, and POST is the best to use? and how do I use them in QV to get the stock quote to be dynamic?

I tried copying the xml file, pasting in to notepad, and then loading the script from web file/xml file in QlikView. Is that the correct way to do it? But then how do I get it to change for the next day when the quote changes?

Here is the xml file I used for Goldman Sachs 'GS':

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

<StockQuotes><Stock><Symbol>GS</Symbol><Last>209.34</Last><Date>6/30/2015</Date><Time>11:05am</Time><Change>+1.69</Change><Open>210.08</Open><High>210.79</High><Low>208.42</Low><Volume>769467</Volume><MktCap>94.39B</MktCap><PreviousClose>207.65</PreviousClose><PercentageChange>+0.81%</PercentageChange><AnnRange>161.53 - 218.77</AnnRange><Earns>18.98</Earns><P-E>11.03</P-E><Name>Goldman Sachs Group</Name></Stock></StockQuotes>

</string>


Thank you in advance!!


0 Replies