Forum Discussion
Power BI - Monday.com: Seeking Suggestions on Enhancing My Super Simple API Query
My 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"
1 Reply
Hi Redraidas10 ,
What does "returns group names" refer to, and what does the data display look like on the PQ page, and is it possible to get the group name field directly by clicking on the drill down or pivot/reverse pivot, and then the data conversion button on the interface after getting the data?
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
