Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
khaotangs
Contributor
Contributor

Calling a REST API

Hi,

Very very new on Qlik, but experienced with development and APIs.

I'm trying to query data from a REST API.

The process is twofold, first authenticate, grab a token in the response, then query the other APIs.

On postman I can authenticate fine, and grab a success json object with the session token I can use to query other APIs.

On click, I get a success=false and an empty token.

The query is super simple, POST to the api url with a json {"Login":"yadayada","Password":"password"} payload.

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=http://url/api/login;timeout=30;method=POST;requestBody={%3Login%3:%3yadda%3,%3Password%3:%3password%3};autoDetectResponseType=true;keyGenerationStrategy=0;authSchema=basic;skipServerCertificateValidation=1;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;PaginationType=None;allowResponseHeaders=false;allowHttpsOnly=false;XUserId=;XPassword=;";

I've tried authSchema=anonymous as well without success.

Any help would be greatly appreciated.

Labels (1)
2 Replies
mikaelsc
Specialist
Specialist

create a connection first

mikaelsc_0-1694287542902.png

needs to be defined before using it. 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

This question looks to be about  QlikVIew, not Qlik Sense. No predefined connections in QlikView. 

-Rob