Hi Guys
I'm just trying to run this simple Rest API call to Azure DevOps. I am getting what appears to be a standard JSON error on here. People say to use a Bearer token but that seems incredibly complicated to just run an API call but really what do I know. Any guidance would be appreciated. I also tried VSTS.Contents and got an even more complicated response.
Source = Json.Document(Web.Contents("https://dev.azure.com/johndacampbell/BIDemo/_apis/wit/workitems/24?api-version=7.0")),
// Convert the retrieved data into a table
#"Converted to Table" = Record.ToTable(Source),
// Expand the columns to access work item details including descriptions
#"Expanded Value" = Table.ExpandRecordColumn(#"Converted to Table", "Value", {"id", "fields"}),
#"Expanded fields" = Table.ExpandRecordColumn(#"Expanded Value", "fields", {"System.Id", "System.Title", "System.Description"})
in
#"Expanded fields"
