Thank you for sharing this with us. Do you have any ideas on how I can modify the suggested API query to also include group names (e.g., Q1, Q2, Q3)? As it stands, the suggested query focuses solely on returning columns. I appreciate 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(“monday.com | A new way of working,
[
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”