topic Re: Rest Connection Error in Integration, Extension & APIs

Rest Connection Error

arunachalamggg — Wed, 08 Sep 2021 10:06:00 GMT

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

Re: Rest Connection Error

NadiaB — Mon, 13 Sep 2021 19:36:24 GMT

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-Expected-lt/td-p/1698870

Hope it helps.

Re: Rest Connection Error

arunachalamggg — Wed, 15 Sep 2021 23:08:08 GMT

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