Create a REST API connection to JAMS Scheduler API (bearer authentication)

mjperreault — Fri, 15 Nov 2024 23:43:30 GMT

Hi All,

I am hoping to create a REST API connection to JAMS Scheduler's REST API. The API uses bearer token authentication so I believe I will first need to send a Post Request to get a token and can then use that token in Get requests to pull data into Qlik Sense. They have pretty good documentation on how to do it using Python here

https://www.jamsscheduler.com/doc/JAMSHelp/JAMSRESTAPIwithPython.html

I think this is likely possible by utilizing a generic JSON server connection and then updating the WITH CONNECTION string as described in this and several other community posts but I have not been able to get a token back. One difference I noticed between this and other examples I have seen is that this requires username and pw to be sent via payload, is that possible within Qlik REST API?

https://community.qlik.com/t5/Connectivity-Data-Prep/REST-CONNECTOR-locate-the-Authorization-token/td-p/950208

Any thoughts are much appreciated!

@Bjorn_Wedbratt

Thanks,
Mark

Re: Create a REST API connection to JAMS Scheduler API (bearer authentication)

Bjorn_Wedbratt — Mon, 20 Sep 2021 21:20:21 GMT

Hi @mjperreault ,

Have you tried sending the payload in the body, using WITH CONNECTION (BODY "<your json body>") ?

https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Load-REST-data/Load-data.htm

Something along the following in the script:

let MsgBody='{"username": "#Your JAMS Username", "password": "#Your JAMS Password"}';
let MsgBody=replace(MsgBody,'"',chr(34) & chr(34));

SQL SELECT ...

FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION (
HTTPHEADER "content-type" "application/json"
BODY "$(MsgBody)"
);

Then you need the bearer token to be sent in a second GET request as outlined in the documentation you linked to. I think this would be possible.

Best,

Bjorn

topic Create a REST API connection to JAMS Scheduler API (bearer authentication) in Integration, Extension & APIs

Create a REST API connection to JAMS Scheduler API (bearer authentication)

Re: Create a REST API connection to JAMS Scheduler API (bearer authentication)