Dear PowerBi community
I have the following problem. My experience in API's is quite devil.
My current problem is how can I connect JWT API's through PowerBi.
I have the following data;
(The documentation of API usage--> https://automation.trendmicro.com/apex-central/api )
| Application name: |
| | |
| Application ID: | XXXXXX-XXXX-4F8A-XXXXX-XXXXXD5BE6 |
| API key: | XXXXXX-4A7B-XXXXX-81C9-XXXXXE58623D |
| API type: | Isolate/Restore endpoint connections |
| Communication time-out: | 120 S. |
I have tried the following scripts and have not achieved positive results.
let
GetJson = Web.Contents("https://mydomain.co.uk/api/token",
[
Headers = [#"Content-Type"="application/x-www-form-urlencoded"],
Content = Text.ToBinary("grant_type=password&username=" &Username&"&password="&Password&"&clienttype=User")
]
),
FormatAsJson = Json.Document(GetJson),
#"Converted to Table" = Record.ToTable(FormatAsJson),
access_token = #"Converted to Table"{0}[Value]
in
access_token
let
//URLs
api_url = "", //Insert your API endpoint
token_url ="", //Insert your token URL
//Client credentials
client_credentials = "grant_type=" &grant_type& "&username=" &username& "&password="&password&"&clienttype=User",
//Get JSON Web Token via API
EncodedCredentials = "Basic "& Binary.ToText(Text.ToBinary(client_id & ":" & client_secret), BinaryEncoding.Base64),
Token_Response = Web.Contents(token_url, [Headers=
[Authorization=EncodedCredentials, #"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"],
Content=Text.ToBinary(client_credentials)]),
//Get Access Token and Token Type
FormatAsJson = Json.Document(Token_Response),
TypeToken = FormatAsJson[token_type],
AccessToken = FormatAsJson[access_token],
//Format Token
AccessTokenHeader = TypeToken & " " & AccessToken,
//Get Data
GetJsonQueryAPI = Csv.Document(Web.Contents(api_url, [Headers=[Authorization=AccessTokenHeader]]),[Delimiter=";",
Encoding=1252, QuoteStyle=QuoteStyle.None])
in
GetJsonQueryAPI
I am grateful for any help.
