topic Re: Connect REST Post with request body in App Development

Connect REST Post with request body

tayariib85 — Fri, 17 Feb 2023 10:02:23 GMT

Hi guys,

I am trying to make Connection REST Post with request body, and here is what I am doing:

First, I created a variable with the body

LET vRequestBody = '{ "where": {}, "index": 0, "count": 1000 }';

Second I used used the variable in WITH CONNECTION ()

Then I get this error

Any advice !

Thank you in advance

Re: Connect REST Post with request body

tayariib85 — Fri, 17 Feb 2023 11:11:27 GMT

I resolved it by adding double quotes to the variable:

LET vRequestBody = replace(vRequestBody,'"',chr(34)&chr(34))

Reference to this post:

https://community.qlik.com/t5/Integration-Extension-APIs/WITH-CONNECTION-statement-BODY-with-Double-quote/m-p/1237636#M6586

Re: Connect REST Post with request body

Benoit_C — Fri, 17 Feb 2023 11:19:27 GMT

Hi @tayariib85,

It seems like the issue in your script is due to the syntax error in the BODY parameter. You are using double quotes for the JSON body, and also using double quotes in the BODY parameter which causes a syntax error. To resolve this, you can either escape the double quotes in the JSON body, or use single quotes to define the JSON body in the LET statement.

Regards,

Benoit

Re: Connect REST Post with request body

Benoit_C — Fri, 17 Feb 2023 11:20:28 GMT

Edit: it seems you already solved the issue yourself, thank you a lot for coming back with your solution.

Re: Connect REST Post with request body

marksouzacosta — Fri, 04 Oct 2024 03:10:40 GMT

Hi,

I have a complete video that covers all the topics related to REST Connections (pagination, with connection, loops, etc) here https://youtu.be/lFwar30BNkQ?si=g-MIwnivViqRDuXK

Regards,

Mark Costa