Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Qlik Connect 2025! Where innovative solutions turn your data visions into reality: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
BouwerQlik
Contributor
Contributor

authSchema Error when trying to download data from API

Hi All

I'm trying to download data via an API but it has parameter that I need to pass in variables.

So I instead of using the normal connection screens I scripted it in the load editor.

But now I'm getting the following error:

The following error occurred:
Invalud Authentication Schema value 'Basic'.
 

Here is my Code:

CUSTOM CONNECT TO "provider=QvRestConnector.exe;
url=https://test;
timeout=300;
method=GET;
autoDetectResponseType=true;
keyGenerationStrategy=0;
authSchema=Basic;
UserId=***;
Password=***;
skipServerCertificateValidation=false;
useCertificate=No;
certificateStoreLocation=LocalMachine;
addMissingQueryParametersToFinalRequest=false;
PaginationType=None;
allowResponseHeaders=false;
allowHttpsOnly=false;
from_date=01-06-2023;
toDate=01-07-2023;";

 

  • What should my authSchema be to match the below setting?

Here is the setup using the normal API Connector (This one is working):

BouwerQlik_0-1688196112664.png

BouwerQlik_1-1688196164229.png

BouwerQlik_3-1688196201955.png

 

 

 

 

Labels (1)
1 Reply
alex_colombo
Employee
Employee

Hi @BouwerQlik , if I understood correctly you have to pass a query param as dynamic value into your reload script, correct? If so, you have to set everything within connector editor (and you already did it seeing your screenshots) and then insert the script generated by the connector editor into your reload script. 
After that, you can use the WITH CONNECTION option for changing query parameter with your variables. Here a guide on how to do this