topic Webservice result as parameter in load script in QlikView

Webservice result as parameter in load script

Thu, 16 Sep 2010 14:02:28 GMT

Hi.

I need to build a parameterized load script where the parameters will be fetched in a query to a webservice.

The result of this query webservice is in table format.

I'm kinda lost and not knowing where to start. Could someone pass me some tips?

Thks.

Webservice result as parameter in load script

Sun, 19 Sep 2010 13:05:18 GMT

Could someone help me?

Webservice result as parameter in load script

vgutkovsky — Sun, 19 Sep 2010 20:29:08 GMT

Well...this could either be really complicated or very simple. When you enter the URL into a browser, you get the table returned? If so, and the URL is static, then simply add the resulting table through the wizard by opening the URL. On the other hand, if the URL is dynamic, then you need to concatenate the URL string using variable values. First, go through the wizard with a static URL just so a template is generated. Then replace the URL string after "FROM" with the concatenation of the string you created from your variables.

Example: mystring = 'http://www.test.com/' & $(vMonth);

Regards,