I am hoping somebody can help as I just keep hitting a dead end ... I must of tried 10 variations of the code but no success.
I have attached the m query which works fine when the number of items to retrieve is hardcoded i.e. limit:10
I do not know the total number of items as it is not passed by the API, but I believe I need to loop through these records and then join all of them thus avoiding the time out issues I am currently experiencing
If anybody could provide guidance i would be grateful. Thanks
let
Key = "abcde",
Board = "9595687423",
Source = Web.Contents(
[ RelativePath = "v2",
Headers=[
#"Method"="POST",
#"Content-Type"="application/json",
#"Authorization"="Bearer " & Key
],
Content=Text.ToBinary("{""query"": ""query { boards(ids: " & Board & ") { items (limit:10) { name, updated_at, group { title }, columns: column_values { title, text } } } }""}")
]
),
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]) )
))
in
Monday
