Why doesn't Monday.com api connection work?

[Jane_Bluebell]

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? 

[Anonymous]

Hi @Jane_Bluebell 

I have never used this API so I cannot tell whether the query is correct. In addition, it gets the 500 Internal Server Error, it seems we are not able to troubleshoot it in Power BI. 

Upon searching topics in the monday Community Forum, I found that several users met this error before. Besides, some users in that forum have experience with relevant issues. So you can also seek help from that forum at the same time. 

Search results for '500 internal server error' - monday Community Forum

Search results for 'Power BI' - monday Community Forum

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!