Pass parameters from excel sheet to rest api in Qlikview

sathyamsb — Sat, 16 Nov 2024 20:19:39 GMT

When I am trying to pass parameters from excel sheet into rest api in Qlikview, i am facing the following error ''QVX_UNEXPECTED_END_OF_DATA: The remote server returned an error: (404) Not Found." .

Initially i tried iterating the email id from array and passing to the api and it was working fine., but i need to read the email ids from excel and send to api.

To do that Am loading the emails from excel sheet and creating array of email id's and sending each email id to api in a "for loop".

When loading from excel sheet Am getting error ''QVX_UNEXPECTED_END_OF_DATA: The remote server returned an error: (404) Not Found." as response from api.

below is the script am using to load data from api ;

ExcelData: LOAD A FROM [C:\Users\XXX\Desktop\XXX\Aug'19\02-08-19\EmailDate.xlsx] (ooxml, no labels, table is Sheet1); Noconcatenate Final: Load concat(A,chr(39)&','&chr(39)) as mails //Creating email array Resident ExcelData; set emails1 = Peek('Final.mails'); for each vEmail in $(emails1) CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=<a href="https://api.hubapi.com/contacts/v1/contact/email/$(vEmail)/profile?XXX;timeout=30;method=GET;autoDetectResponseType=true;keyGenerationStrategy=0;useWindowsAuthentication=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;PaginationType=None;XUserId=VBfZceD;XPassword=AYBRQHC" target="_blank">https://api.hubapi.com/contacts/v1/contact/email/$(vEmail)/profile?XXX;timeout=30;method=GET;autoDetectResponseType=true;keyGenerationStrategy=0;useWindowsAuthentication=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;PaginationType=None;XUserId=VBfZceD;XPassword=AYBRQHC</a>;"; RestConnectorMasterTable: SQL SELECT "__KEY_root", (SELECT "__FK_properties", "__KEY_properties", .....

Can anyone help me to solve this error??

Re: Pass parameters from excel sheet to rest api in Qlikview

Brett_Bleess — Fri, 23 Aug 2019 14:56:51 GMT

Sathya, best I have is the Help on things, be sure to check the section on the connection log, as that is likely where you will find further information to help determine what is going wrong here...

https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/REST-connector.htm

On the left side, expand the entire REST section, that way you can see all the subtopics etc. Hopefully this will help you solve things or at least gather some further information that may help us help you.

Regards,
Brett

topic Re: Pass parameters from excel sheet to rest api in Qlikview in QlikView

Pass parameters from excel sheet to rest api in Qlikview

Re: Pass parameters from excel sheet to rest api in Qlikview