Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Peony
Creator III
Creator III

WITH CONNECTION error issue (QlikView)

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;requ...{

    %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.
 
Labels (3)
3 Replies
Anil_Babu_Samineni

Perhaps share the error message to identify the issue. 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Peony
Creator III
Creator III
Author

Hi @Anil_Babu_Samineni  Sure. Here it is.

Peony_0-1732100309209.png

 

 

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful