api.monday.com connection stopped working

[TomU]

I had a working connection using monday.com api, but today it stopped working, apparently due to changes in api documentation.
We've managed to change the code and it works perfectly in monday.com developers tool:

But in power query the same thing produces an error. Here's the code:

Json.Document(Web.Contents("https://api.monday.com/" & "v2", [Headers=[Method="POST", #"Content-Type"="application/json", Authorization="Api Token"], Content=Text.ToBinary("{""query"": ""query { boards(ids: [581141334]) { items_page {items { name group{ id } column_values (ids: [name]) { id value } } } } }""}")]))

Error:

I've tried qutation marks and double quotation marks, but that only leads to another error

api.monday.com is accessible with different code, but we need columns and names.

[Anonymous]

Hi @TomU ,

Please try this code:

let
    url = "https://api.monday.com/v2",
    body = "{""query"": ""query { boards(ids: [581141334]) { items { name group { id } column_values { id value } } } }""}",
    apiToken = "your_api_token_here", // Replace with your actual API token
    headers = [
        #"Content-Type"="application/json",
        #"Authorization"="Bearer " & apiToken
    ],
    content = Text.ToBinary(body),
    Source = Json.Document(Web.Contents(url, [Headers=headers, Content=content]))
in
    Source

And if the API has been updated, there may be changes to the endpoint, required headers, or the structure of the requests and responses.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TomU]

Hi @Anonymous. Thanks for advise. 
The code works, but we still have to to limit the number of columns, as this is a pertty large board.
"column_values (ids: [name])" doesn't worsk and just says that
"column_values has invalid value ([Name]).Expected type [String!]"
I tried [""name""] too.