Forum Discussion

TomU's avatar
TomU
Frequent Visitor
2 years ago

api.monday.com connection stopped working

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 d...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
TomU
Frequent Visitor
2 years ago

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.