1 Reply Latest reply: Mar 19, 2017 7:42 PM by Petter Skjolden RSS

    WITH CONNECTION statement - BODY with Double quote

    Jonathan Poyer

      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.