Tables through the API

[BIUser22232]

I'm trying to bring tables through the hotmart API but I'm not succeeding, does anyone know how to solve it? I believe my code is wrong

[Anonymous · Accepted solution]

HI @BIUser22232.

You can try to use the following codes if it suitable for your requirement::

let
    url = "api-sec-vlc.hotmart.com",
    token = "xxxxx",
    response = Web.Contents(
        url,
        [
            RelativePath = "/security/oauth/token",
            Headers = [
                Authoraztion = "Basic " & token,
                #"Content-Type" = "application/json"
            ],
            Query = [
                grant_type = "client_credentials",
                client_id = "id string",
                client_secret = "secret string"
            ]
        ]
    ),
    AccessToken = Json.Document(response)[access_token]
in
    AccessToken

Regards,

Xiaoxin Sheng