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