topic API REST connector for QV 11.20 SR10 ? in QlikView

API REST connector for QV 11.20 SR10 ?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi !

I am trying to get data from Elasticsearch with the API REST Connector into my QV application.

I am able to connect to my elasticsearch base but I can't reach all data.

When I use custom pagination or offset i have an error message .

With the offset my custom connection is like this :

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=http://hostname/index/_search;timeout=1000;method=GET;autoDetectResponseType=true;keyGenerationStrategy=0;useWindowsAuthentication=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;queryHeaders=startAt%20%1maxResults%21000;PaginationType=Offset;OffsetStartField=startAt;IsOffsetStartFieldHeader=;OffsetStartFieldValue=0;OffsetCountFieldName=maxResults;IsOffsetCountFieldHeader=;OffsetCountValue=1000;OffsetTotalPath=root/total;IsOffsetTotalPathHeader=;XUserId=HESCMIC;XPassword=VAOFVPA;";

With the custom pagination i have this:

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=http://hostname/index/F_search;timeout=30;method=GET;autoDetectResponseType=true;keyGenerationStrategy=-1;useWindowsAuthentication=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;queryParameters=scroll%225m%1from%20%1size%250;PaginationType=Custom;XUserId=AaWRbJD;XPassword=cMJcQHD;";

Thank you in advance for your help

Ce message a été modifié par : Sitrakiniaina JAUNET