Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dears,
I have 10 Student ID in a table and basicly I want to do post call that will call an API to retrive t he token for all these students.
the call like this:
let
url = "https://api.SchoolXXX/oauth/token",
body = "{""School_id"" :""XXXXX-XXXXXXX-XXXXXXX"", ""School_secret"" : ""XXXXXXXXXXX"", ""grant_type"" : ""client_credentials"", ""Student"" :XXXXXX}" ,Source = Json.Document(Web.Contents(url, [Headers=[Method="POST", #"Content-Type"="application/json", Accept="application/json"], Content=Text.ToBinary(body)])),
#"Converted to Table" = Record.ToTable(Source)
in
#"Converted to Table"
So i want to pass the Students ID that in another table to the POST CAL so i will get the token for each student.
Is that possible? @mahoneypat
Solved! Go to Solution.
Yes. You can start with a table with a column of student IDs and pass those into the API call. Please see this video to see an example, but basically you can conacenate it in your code as follows:
let
url = "https://api.SchoolXXX/oauth/token",
body = "{""School_id"" :""XXXXX-XXXXXXX-XXXXXXX"", ""School_secret"" : ""XXXXXXXXXXX"", ""grant_type"" : ""client_credentials"", ""Student"" :" & [StudentIDColumn] & "}" ,Source = Json.Document(Web.Contents(url, [Headers=[Method="POST", #"Content-Type"="application/json", Accept="application/json"], Content=Text.ToBinary(body)])),
#"Converted to Table" = Record.ToTable(Source)
in
#"Converted to Table"
Power BI - Tales From The Front - REST APIs - YouTube
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Yes. You can start with a table with a column of student IDs and pass those into the API call. Please see this video to see an example, but basically you can conacenate it in your code as follows:
let
url = "https://api.SchoolXXX/oauth/token",
body = "{""School_id"" :""XXXXX-XXXXXXX-XXXXXXX"", ""School_secret"" : ""XXXXXXXXXXX"", ""grant_type"" : ""client_credentials"", ""Student"" :" & [StudentIDColumn] & "}" ,Source = Json.Document(Web.Contents(url, [Headers=[Method="POST", #"Content-Type"="application/json", Accept="application/json"], Content=Text.ToBinary(body)])),
#"Converted to Table" = Record.ToTable(Source)
in
#"Converted to Table"
Power BI - Tales From The Front - REST APIs - YouTube
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.