topic Re: Need to pass Variables in Web URL using Open URL Action. in QlikView

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

hannan_t — Thu, 19 Mar 2015 12:18:23 GMT

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

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

buzzy996 — Thu, 19 Mar 2015 17:41:21 GMT

try this,

AJAX and URL parameters

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

petter — Thu, 19 Mar 2015 17:46:45 GMT

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

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

petter — Thu, 19 Mar 2015 17:47:56 GMT

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

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

hannan_t — Thu, 19 Mar 2015 18:11:46 GMT

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.

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

petter — Thu, 19 Mar 2015 18:57:57 GMT

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