Calling a REST API

khaotangs — Sat, 09 Sep 2023 15:15:23 GMT

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.

Re: Calling a REST API

mikaelsc — Sat, 09 Sep 2023 19:26:33 GMT

create a connection first

needs to be defined before using it.

Re: Calling a REST API

rwunderlich — Mon, 11 Sep 2023 00:14:37 GMT

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

-Rob

topic Calling a REST API in Qlik Automate

Calling a REST API

Re: Calling a REST API

Re: Calling a REST API