Excel power bi query

I am trying to load a board including the subitems to the excel from Monday.

I’ve used the following code to do so and recieved the following error:
Code:
[
Headers=[
#“Method”=“POST”,
#“Content-Type”=“application/json”,
#“Authorization”=“Bearer " & Key
],
Content=Text.ToBinary(”{““query””: ““query { boards(ids: " & Board & “) { items { name, updated_at, group { title }, columns: column_values { title, text } subitems { name } } } }””}”)
]
),
Data = Table.FromList(Json.Document(Source)[data][boards]{0}[items], Record.FieldValues, {“Title”, “UpdatedAt”, “Group”, “Columns”}),
#“Monday” = Table.FromRecords(Table.TransformRows(Data, each
List.Accumulate([Columns], [
Title = [Title],
UpdateDate = [UpdatedAt],
Group = [Group][title]
], (state, current) => Record.AddField(state, current[title], current[text]) )
))

Error:
DataFormat.Error: There were more columns in the result than expected.
Details:
Count=4

Thank you in advance.

Hello there,

Matias here!

As we are currently talking about this issue via email, let’s continue this over there to have all the information in one place :slightly_smiling_face:

Cheers,
Matias