Power BI - Monday.com: Seeking Suggestions on Enhancing My Super Simple API Query

Redraidas10 — Wed, 10 Jan 2024 20:39:01 GMT

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"

Re: Power BI - Monday.com: Seeking Suggestions on Enhancing My Super Simple API Query

Anonymous — Thu, 11 Jan 2024 07:57:36 GMT

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.

topic Power BI - Monday.com: Seeking Suggestions on Enhancing My Super Simple API Query in Developer

Power BI - Monday.com: Seeking Suggestions on Enhancing My Super Simple API Query

Re: Power BI - Monday.com: Seeking Suggestions on Enhancing My Super Simple API Query