Hello everyone,

Currently, I'm trying to set up a connection between an API I've build using Microsoft R server and Klipfolio.

Microsoft R server (MRS) makes use of a so called 'Bearer'. This bearer is acquired through posting to a login URL. The response contains an access token and a refresh token. I know the API works: When I hardcode the access token into my API call in a datasource it works for a short while. But, the token expires. Calls to this API are made like this:

(In this example, the IP is fake)

Where {access_token} in the header should be the access token, preceded by the word Bearer.

I can call the login part of the API in a seperate datasource:


(I've hidden the tokens manually through the browser console for security reasons)

So, I tried several things;

- Setting it up as a dynamic datasource, setting the value of the Login API access_token as a variable value, and try reading that in the getWorklogs API call like this: 'Bearer {access_token}.
- Setting it up as a two-step authentication datasource. But I have no clue on how to get the access_token value and append it to the Bearer.

Does anyone have an idea on how to connect this datasource?