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 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.

Need Help

2 Replies

  • 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.