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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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