User Profile
Jane_Bluebell
Regular Visitor
Joined 2 years ago
User Widgets
Contributions
Why doesn't Monday.com api connection work?
Here's the code I use that works: Json.Document(Web.Contents("https://api.monday.com/ " & "v2", [Headers=[Method="POST", #"Content-Type"="application/json", Authorization="Bearer <Api token>", #"API-Version"="2023-10"], Content=Text.ToBinary("{""query"": ""query { boards(ids: <board id>) { items_page {items {name group { title} column_values { id text} } } } }""}")])) But as soon as I put in any column id: Json.Document(Web.Contents("https://api.monday.com/ " & "v2", [Headers=[Method="POST", #"Content-Type"="application/json", Authorization="Bearer <Api token>", #"API-Version"="2023-10"], Content=Text.ToBinary("{""query"": ""query { boards(ids: <board id>) { items_page {items {name group { title} column_values (ids: [""name""]) { id text} } } } }""}")])) It shows the following error: What am I doing wrong?
