Connecting TalentLMS API to PowerBI

[mr1605]

Hello,

I've been trying to connect the TalentLMS API to PowerBI but I'm getting a few errors when authenticating. I don't have any experience with APIs as it is my first time trying to connect to one.

This is what I have so far (companyname is the subdomain and the token is an alphanumeric value):

let
    rooturl = "https://companyname.talentlms.com/api",
    token = "xxxxxxxxxxxxxxxxxxx",
    relativeURL = "/v1/users",
    Result =
        Web.Contents(
            rooturl,
            [
                Headers = [
                    #"Content-Type" = "application/json",
                    Authorization = "setApiKey()" & token,
                    RelativePath = "/v1/users"
                ],
                RelativePath = relativeURL
            ]
        )
in
    Result

 Then I get prompted to add my credentials, which should be anonymous since I'm connecting with a token, but when trying to connect anonimously I get the message "It was not possible to connect with the informed credentials"

I have tried a few different codes and I've tried connecting as a Web source but nothing worked.

If it helps, here's the link to the website's API documentation: https://www.talentlms.com/pages/docs/TalentLMS-API-Documentation.pdf

[boyceonmission]

Did you ever resolve this @mr1605 ? Also, what was you planning on doing once connected? I'm hoping to display our course catalogue on our training departments sharepoint site

[amitchandak]

@mr1605 , refer if these can help

Token based Auth
https://www.youtube.com/watch?v=f7HLyiAk-lQ
https://community.powerbi.com/t5/Desktop/Connect-to-data-with-API-token/td-p/731867
https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/
https://docs.microsoft.com/en-us/rest/api/power-bi/embedtoken
https://docs.microsoft.com/en-us/power-bi/developer/embedded/get-azuread-access-token
https://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data-get-token