Skip to main content

Hi Community

Since October 12th I have been experiencing following error in my Power Query API call:

The purpose of the Power Query-code is to collect data and boards from my organization’s Monday-account via an API-key and thereby create Power BI reports. The code bellow has been working flawlessly until recently. I have already tried changing authorization method (anonumous etc.), removed API-version and regenereated the API key. Please let me know if you have any suggestions on how to solve the issue - any help is appreciated!

let 
Key = "xxxxx",

Source = Web.Contents( "https://api.monday.com/v2", [ Headers = [ #"Method" = "POST", #"Content-Type" = "application/json", #"Authorization" = "Bearer " & Key, #"API-Version" = "2024-01" ],


Content = Text.ToBinary( "{""query"": ""query { boards(ids: [xxx, xxx]) { id name workspace_id owner { id name } items_page(limit: 500) { items { id name updated_at group { title } column_values { column { title } text ...on DependencyValue { display_value } ...on MirrorValue { display_value } ...on BoardRelationValue { display_value } } subitems { id name updated_at group {title} column_values { column { title } text ...on DependencyValue { display_value } ...on MirrorValue { display_value } ...on BoardRelationValue { display_value } } } } } } }""}" ) ] ),


Boards = Json.Document(Source)[data][boards],

CombinedItems = List.Combine(
List.Transform(Boards, each
let...........
Be the first to reply!