Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Integration, Extension & APIs

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now

Who Me Too'd this topic

Anonymous
Not applicable

WITH CONNECTION statement - BODY with Double quote

I am trying to POST a REST connection with a Body.

While there is no issue when it is a static BODY (in the connection edition), I can't do it right now in the BODY parameter of the "WITH CONNECTION" statement.

Would you know if there is any escape character or any other solution?

I can't replace double quote by nothing nor by single quote as per the API requirements.

Here is the exemple:

...

Let vBody = '{["ids":[10001,10002]]}';

Load

...

FROM JSON (wrap off) "root" PK "__KEY_root"

WITH CONNECTION(URL "$(vUrl)",

HEADER "$(vHeaderName)" "$(vHeaderParameter",

BODY "$(vBody)");

Thank you in advance for your help.

Who Me Too'd this topic