Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

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
Master II
Master II

MVP
MVP

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

MVP
MVP

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

Partner
Partner

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.

MVP
MVP

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)'