Paginated REST API Unknown Records

Richard_Halsall · ‎10-10-2023

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(

"https://api.monday.com/",

[ 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