Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am completely new to APIs, PowerBI, and M (literally just found out the name for this programming language last week while frantically googling). I've managed to incorporate one public API into my dashboard project, but now the second data source requires a new authentication token daily. The site provided a python example on how to get the token, is there a way of re-writing it for the M language?
import requests auth_url = 'https://api.citeline.com/token' email = 'YOUR EMAIL' password = 'YOUR PASSWORD' def get_token(): data = { 'email': email, 'password': password } headers = { "Content-Type": "application/json", } response = requests.request("POST", auth_url, json=data, headers=headers) response_json = response.json() access_token = 'Bearer {}'.format(response_json['access_token']) return access_token get_token()
Solved! Go to Solution.
@tiannie here is the M code for your scenario.
let
auth_url = "https://api.citeline.com/token",
email = "YOUR EMAIL",
password = "YOUR PASSWORD",
get_token = () =>
let
data = "{""email"": """ & email & """, ""password"": """ & password & """}",
headers = [
#"Content-Type" = "application/json"
],
// Make the HTTP request
response = Web.Contents(
auth_url,
[
Headers = headers,
Content = Text.ToBinary(data),
Timeout=#duration(0,0,30,0) // Set the timeout value as needed
]
),
// Parse the JSON response
response_json = Json.Document(response),
access_token = "Bearer " & response_json[access_token]
in
access_token
in
get_token()
Here's what this code does:
To use this code in Power BI, follow these steps:
@tiannie here is the M code for your scenario.
let
auth_url = "https://api.citeline.com/token",
email = "YOUR EMAIL",
password = "YOUR PASSWORD",
get_token = () =>
let
data = "{""email"": """ & email & """, ""password"": """ & password & """}",
headers = [
#"Content-Type" = "application/json"
],
// Make the HTTP request
response = Web.Contents(
auth_url,
[
Headers = headers,
Content = Text.ToBinary(data),
Timeout=#duration(0,0,30,0) // Set the timeout value as needed
]
),
// Parse the JSON response
response_json = Json.Document(response),
access_token = "Bearer " & response_json[access_token]
in
access_token
in
get_token()
Here's what this code does:
To use this code in Power BI, follow these steps:
Amazing, thank you so much!!!
@tiannie glad it helped you. 🙂
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!