Forum Discussion

mr1605's avatar
mr1605
New Member
3 years ago

Connecting TalentLMS API to PowerBI

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

2 Replies