Skip to main content

I have rewritten my old API query to prepare it for the new API version.


While my new query is functioning correctly, it currently only returns the columns from my boards. How can I modify it to ensure that it also returns group names such as Q1, Q2, Q3, etc. (example attached)? Thank you for your assistance.


Board example


My API code that needs tweaking to include groups:


let

MondayQuery1 = “{”“query”“: “”{boards(ids: “,

MondayQuery2 = “MY BOARD ID”,

MondayQuery3 = “) {items_page(limit: 100) {cursor items {id name column_values {text column {title}}}}}}””}”,

MondayFullQuery = MondayQuery1 & MondayQuery2 & MondayQuery3,

Source = Web.Contents(“https://api.monday.com/”,

i

RelativePath=“v2”,

Headers=

v

#“Method”=“POST”,

#“Content-Type”=“application/json”,

#“Authorization”=“MY API TOKEN”,

#“API-Version”=“2023-10”

],

Content=Text.ToBinary(MondayFullQuery)

]

),

#“JSON” = Json.Document(Source, 65001),

data = JSON
boards = dataeboards],

#“Converted to Table” = Table.FromList(boards, Splitter.SplitByNothing(), null, null, ExtraValues.Error)

in

#“Converted to Table”

Hello there @SMac and welcome to the community!


I hope you like it here 💪


You can use a query like this one:


{

  boards(ids: 1234567890) {

    groups {

      title

      id

    }

    items_page(limit: 100) {

      cursor

      items {

        id

        name

        column_values {

          text

          column {

            title

          }

        }

      }

    }

  }

}

I hope that helps!


Cheers,

Matias

Hello Sean Mac, i’m stuck with the same issue, have you been able to find a solution for the groups ?

Reply


Terms & ConditionsCookie settings