topic Re: REST Request Body dealing with "'s in QlikView

REST Request Body dealing with "'s

prees959 — Thu, 10 May 2018 20:49:31 GMT

I'm having difficulty passing double quotes within the request body to an APUI.

For example, I one of my data items uses a " as a measurement of inches which is failing on that particular call.

{

"Parameters": {

"Key": "xxxxxxxxxxxxx",

"Query": {

"1": "12" Cuff",

"2": "8mm Drills",

"3": "Steel Bearings"

}

As you can see the 12" Cuff is causing the issue..... Is there a workaround which will enable this to work?

Many thanks,

Phil

Re: REST Request Body dealing with "'s

sasiparupudi1 — Fri, 11 May 2018 12:04:43 GMT

May be try

'"12"'&chr(32)&'Cuff"'

Re: REST Request Body dealing with "'s

prees959 — Tue, 15 May 2018 09:11:16 GMT

Hi,

This worked perfectly! Thanks!

I'll need to dynamically loop through a dataset and pass each string to the API within a variable .. is there any way I can test if the description has " and replace with chr(32)?