New API: Seeking Suggestions on Enhancing My Super Simple API Query for Power BI

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.

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/”,
[
RelativePath=“v2”,
Headers=
[
#“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[data],
boards = data[boards],
#“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 :muscle:

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

1 Like

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