Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Gartner® Magic Quadrant™: 15 YEARS A LEADER - GET THE REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Webservice result as parameter in load script

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.

2 Replies
Not applicable
Author

Could someone help me?

vgutkovsky
Master II
Master II

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,