WITH CONNECTION error issue (QlikView)

Peony — Wed, 20 Nov 2024 11:00:25 GMT

Hi everyone. I'll be really appreciate if somene goit give me a hint what is wrong with my WITH CONNECTION script
I have first connection to json source that looks like this

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=https://www.somelink.com/gw/v3/results/list?tagId%13&limit%20&offset%20;timeout=300;method=POST;requestBody={

%3items%3: [

{

%3sourceItemKey%3: %3SUBMIT_DATE%3,

%3operator%3: %3BETWEEN%3,

%3operand%3: {

%3from%3: %32012-11-01%3,

%3to%3: %32013-11-01%3

}

{

%3sourceItemKey%3: %3STATUS%3,

%3operator%3: %3IN%3,

%3operand%3: {

%3selected%3: [

%3STATUS.COMPLETE%3

]

}

]

}

;sendExpect100Continue=True;autoDetectResponseType=true;checkResponseTypeOnTestConnection=true;keyGenerationStrategy=0;authSchema=anonymous;skipServerCertificateValidation=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;queryHeaders=Authorization%2Bearer 1111111%1Content-Type%2application/json;PaginationType=None;allowResponseHeaders=false;allowHttpsOnly=false;XUserId=cfcfcf;XPassword=mkmkmk;";

Than I want to use this connection to get new data and create WITH CONNECTION that does not work. It returns error "Select statement parser error at (16,14): Multi-line literals are not supported." this new connection looks like this

RestConnectorMasterTable:
SQL SELECT
(SELECT
"taglisttId",
"__KEY_results",
"__FK_results"
FROM "results" PK "__KEY_results" FK "__FK_results")
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION
(
URL "https://www.somelink.com/gw/v3/results/list",
QUERY "tagId" "13",
QUERY "limit" "0",
QUERY "offset" "0",
HTTPHEADER "Authorization" "Bearer 1111111",
HTTPHEADER "Content-Type" "application/json",
BODY "{
"items": [
{
"sourceItemKey": "SUBMIT_DATE",
"operator": "BETWEEN",
"operand": {
"from": "2012-11-01",
"to": "2013-01-01"
}
},
{
"sourceItemKey": "STATUS",
"operator": "IN",
"operand": {
"selected": [
"STATUS.COMPLETE"
]
}
}
]
}
"
);

I understand that without chance to test connection "by hand" it is really hard to guess what is wrong. But still have a hope that maybe someone may help with advice or lucky guess.

Re: WITH CONNECTION create issue (QlikView)

Anil_Babu_Samineni — Tue, 19 Nov 2024 10:17:24 GMT

Perhaps share the error message to identify the issue.

Re: WITH CONNECTION create issue (QlikView)

Peony — Wed, 20 Nov 2024 10:58:45 GMT

Hi @Anil_Babu_Samineni Sure. Here it is.

Re: WITH CONNECTION create issue (QlikView)

Anil_Babu_Samineni — Fri, 06 Dec 2024 12:01:32 GMT

Can you please share the setup how you have done? It sounds like, you have not given any authentication in API.

topic WITH CONNECTION error issue (QlikView) in App Development

WITH CONNECTION error issue (QlikView)

Re: WITH CONNECTION create issue (QlikView)

Re: WITH CONNECTION create issue (QlikView)

Re: WITH CONNECTION create issue (QlikView)