Not able to insert data into db through REST API from qlikview

djaykumar — Sat, 16 Nov 2024 18:45:50 GMT

Hi All,

I am trying to store data from qlikview to db through REST API by using Post method.

Please find below my code.

vuser_slug= 'Jay';
vfeedback_type = 'Running';
vfeedback = 'Test';
Let vURL = 'my url';

LET vRequestBody ='{';

//Let vRequestBody = vRequestBody&'"id":"$(vid)",';

Let vRequestBody = vRequestBody&'"user_slug":"$(vuser_slug)",';

Let vRequestBody = vRequestBody&'"feedback_type":"$(vfeedback_type)"';
Let vRequestBody = vRequestBody&'"feedback":"$(vfeedback)",';

Let vRequestBody = vRequestBody&'}';

let vRequestBody = replace(vRequestBody,'"', chr(34)&chr(34));

CUSTOM CONNECT TO (My Connection)

RestConnectorMasterTable:

SQL SELECT

//"id",

"user_slug",
"feedback_type",
"feedback"

FROM JSON (wrap on) "root"
WITH CONNECTION(URL "$(vURL)",BODY "$(vRequestBody)");;

From the above code I am able to store empty row into database.

But the above defined row along with data not able to store.

I am deeply stuck in this as it is required urgently.

Please help me in resolving this issue.

Thanks & Regards,

Jay

topic Not able to insert data into db through REST API from qlikview in QlikView