Pass parameters from excel sheet to rest api in Qlikview

[sathyamsb]

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??

[Brett_Bleess]

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-c...

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