topic HttpGet into Script in QlikView

HttpGet into Script

lucpechali — Wed, 03 Jun 2015 10:55:04 GMT

Hello,

I use this macro to get the information I need in a variable. It works prefectly. But now, I want to make a loop into script to get the response into a field . How can I achieve this ?

function httpGet

Set val=ActiveDocument.Fields("Url").GetPossibleValues

sStockID = val.Item(0).Text

vURL = sStockID

'Create xmlhttp opject

Set xmlhttp = CreateObject("Microsoft.XMLHTTP")

xmlhttp.open "GET", vURL, false

xmlhttp.setRequestHeader "Content-Type", "text/xml"

xmlhttp.send ""

result = xmlhttp.responseText

result = replace(result, ">", ">")

result = replace(result, "<", "<")

set txt = ActiveDocument.Variables("vXMLReceived")

txt.setContent result, true

end function

Thks for your help.

Re: HttpGet into Script

petter — Wed, 03 Jun 2015 15:38:45 GMT

What you could do in the load script as a replacement for your VBScript you have is:

LOAD

result

FROM [ http : // someurl ? abc=123 & def=456 ] (XmlSimple, Table is [string]);

Is that QlikView is in fact doing an HTTP GET. And what you specify as (XmlSimple .... )

is that the return will be an XML-file. You could do similar Replace() functions in your load script to pull out the data you want.

The interactivity will not be directly possible - but what you could do is write the values to a server-side text-file or Excel-file and read that in before the load from HTTP and make variables that you will use as $-expansion in the final load.

Re: HttpGet into Script

hectorgarcia — Fri, 19 Jun 2015 00:21:05 GMT

have you checked wget? i use it and it works very well

Re: HttpGet into Script

lucpechali — Fri, 19 Jun 2015 07:01:39 GMT

Thank you but I decided to use the load from web file in a loop.

Here is what I did : https://community.qlik.com/docs/DOC-8955#comment-35868