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: 
hannan_t
Partner - Contributor III
Partner - Contributor III

Need to pass Variables in Web URL using Open URL Action.

Hi,

I need to pass variables in the web service url using Open URL Action.

What I am trying to do is that I have input field A and B. I edit the data in the fields and pass that updated data through webservice back to the Database. It is basically a write back to data base functionality that i am trying to achieve.

I have a webservice URL as

http://localhost:9090/QVDataPost/api/QVData?EmployeeName=qwe&EmployeeSalary=800

But I don't want to hard code the values of fields EmployeeName=qwe and EmployeeSalary=800

I want these fields to get the value from a variable e.g EmployeeName=$(vName) and EmployeeSalary=$(vSalary)

I tried doing this using the following syntax in Open URL action:

='http://localhost:9090/QVDataPost/api/QVData?EmployeeName=&'$(vName)'&&EmployeeSalary=&'$(vSalary)&'

But it's still not working. Can anyone help me to pass variable in a URL?

Regards,

Hannan Tariq

5 Replies
buzzy996
Master II
Master II

petter
Partner - Champion III
Partner - Champion III

This document show the other direction - from outside into QlikView....

petter
Partner - Champion III
Partner - Champion III

Do you really run your webservice on the same computer as QlikView Web Service (or IIS)? I see you use localhost as hostname?

hannan_t
Partner - Contributor III
Partner - Contributor III
Author

I am in testing/developing phase of the functionality that's why i have hosted everything on my laptop meanwhile. Later it will obviously be on servers and all.

petter
Partner - Champion III
Partner - Champion III

If the expressions you gave originally are accurate then you have a problem ... it should be more like this:

='http://localhost:9090/QVDataPost/api/QVData?EmployeeName=$(vName)&EmployeeSalary=$(vSalary)'