Integration, Extension & APIs

[arunachalamggg]

Hi,

Im trying to get data from a rest api and I am passing the body paramet with it. I have tested the api in postman and it works.
Below is my script

LIB CONNECT TO 'xxx';

let vBase64String = 'xxxxxxx==';

let vRequestBody = '{"OBID":"1"}' ;

let vRequestBody = replace(vRequestBody,'"',chr(34));
//I have tried this option too
//let vRequestBody = replace(vRequestBody,'"',chr(34)&chr(34));

LET vAuthorization = 'Basic ' & '$(username)' & ':' & '$(password)';

RestConnectorMasterTable:
SQL SELECT
"W"

FROM JSON (wrap on) "root"
WITH CONNECTION (
URL "https://xxxxxk/xxx/v1/xx/xx",
HTTPHEADER "Autorization" "Basic $(vBase64String)",
BODY "$(vRequestBody)"
);

Im getting the following error

[NadiaB]

Hi @arunachalamggg 

Have you seen this already?

https://community.qlik.com/t5/New-to-Qlik-Sense/Connector-reply-error-Unexpected-lexem-From-at-62-5-...

Hope it helps.

[arunachalamggg]

yes, I have tired replacing with chr(34) and im still having the same issue