Hi,
I’m struggling to replicate my old extraction in the new API, where I could extract the sub-items this way.
Old query.
let
MondayKey = “Key”,
BoardId = “24718676xx”,
GET_DATA = “”,
MondayGraphQLBinaryResult = Json.Document(Web.Contents(“https://api.monday.com/v2”, [
Headers=[Method=“POST”, #“Content-Type”=“application/json”, Authorization=MondayKey],
Content=Text.ToBinary(
“{”“query”": ““query { boards(ids: " & BoardId & “) {”&
“id name items (limit: 200) { id name group { title }”&
“subitems { id name column_values { id value text } } } } }””}”
)
])),
data = MondayGraphQLBinaryResult[data],
boards = data[boards],
boards1 = boards{0},
items = boards1[items],
In the new query (below is working)
let
MondayKey = “Key”,
BoardId = “24718676xx”,
GET_DATA = “”,
MondayGraphQLBinaryResult = Json.Document(Web.Contents(“https://api.monday.com/v2”, [
Headers=[Method=“POST”, #“Content-Type”=“application/json”, Authorization=MondayKey],
Content=Text.ToBinary("{""query"": ""query { boards(ids: " & BoardId & ") { items_page(limit: 500) { items { name, id, columns: column_values { ...on MirrorValue { display_value } } } } } }""}")
])),
data = MondayGraphQLBinaryResult[data],
boards = data[boards],
boards1 = boards{0},
items_page = boards1[items_page],
items = items_page[items],
MondayRawTable = Table.FromList(items, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#“Expanded Column1” = Table.ExpandRecordColumn(MondayRawTable, “Column1”, {“name”, “id”, “group”, “columns”}, {“Column1.name”, “Column1.updated_at”, “Column1.group”, “Column1.columns”}),
#“Expanded Column1.columns2” = Table.ExpandListColumn(#“Expanded Column1”, “Column1.columns”),
#“Expanded Column1.columns3” = Table.ExpandRecordColumn(#“Expanded Column1.columns2”, “Column1.columns”, {“display_value”}, {“Column1.columns.display_value”})
in
#“Expanded Column1.columns3”^
I’m having trouble finding the structure to extract subitem data, any suggestion to rewrite similar to above?