topic Re: Overwrite POST body with Qlik REST Connector in Connectivity & Data Prep

Overwrite POST body with Qlik REST Connector

mlehtola — Mon, 29 Jan 2018 12:09:14 GMT

I'm trying to overwrite the POST request body with Qlik Rest Connector. As in documentation the syntax is WITH CONNECTION(body "<Overwrite>") . This works great as long the body does not contain double quotes (").

My use case sending email with sendgrid API and post body is like this:

{"personalizations": [{

"to": [{"email": "some@example.com"}]}],

"from": {"email": "some@example.com"},

"subject": "Sending with SendGrid is Fun","

content": [{"type": "text/plain", "value": "and easy to do anywhere"}

]}

This works great when creating the connection with Create connection wizard, but when I try to manipulate the body in script with WITH CONNECTION (body "{newBody}") that contains double quotes the script fails.

Is there a way to escape double quotes in the WITH CONNECTION (body "")?

Re: Overwrite POST body with Qlik REST Connector

Anonymous — Mon, 29 Jan 2018 15:41:25 GMT

Hi Markus,

I have also tried the way you are trying, sometimes API functions differently or double quotes need to checked properly.

Try to put it another way,

WITH CONNECTION ( URL "",

QUERY "to" "$(vTo)",

QUERY "from" "$(vfrom)"

next query like this);

Re: Overwrite POST body with Qlik REST Connector

mlehtola — Mon, 29 Jan 2018 16:44:36 GMT

Hi Sandeep,

tried dollar sign expansion and also replacing " with chr(34) with no success. Api does not work without double quotes so that does not hel.

Re: Overwrite POST body with Qlik REST Connector

Anonymous — Tue, 30 Jan 2018 09:13:27 GMT

Hi Markus,

I would suggest then to attach the connection part in your script here and error screenshot also so that to understand the error better.