Monday.com API and pagination

[Richard_Halsall]

Hi,

Hoping somebody can help as I am sruggling with the Monday.com API and pagination. After research I have 2 queries 

GetBoardPages:

(PageNo as number) =>

let

    Key = MondayKey,

    Board = id_board,

    Source = Web.Contents(

MondayBaseURL,

[ RelativePath = "v2",

Headers=[

#"Method"="POST",

#"Content-Type"="application/json",

#"Authorization"="Bearer " & Key

],

Content=Text.ToBinary("{""query"": ""query { boards(ids: " & Board & ") { items (limit:10, page: Number.ToText (PageNo)) { name, updated_at, group { title }, columns: column_values { title, text } } } }""}")

]

    )

in

Source

Query 2:

let 

    Records = List.Generate(()=> 

            [Source = GetBoardPages(1), Page=1],

            each List.Count([Source][Monday]) > 0,

            each [Source = GetBoardPages([Page]+1), Page=[Page] +1],

            each [Source])

in

    Records

But Query 2 errors I believe at the List.Count line as follows:

Expression.Error: We cannot apply field access to the type Binary.

Details:

    Value=[Binary]

    Key=Monday

Can anybody help. Many thanks

[dk_dk · Accepted solution]

Hi Richard,

I am struggling with Monday.com API as well and do not really know the answer to your question, just wanted to make you aware that the API will introduce breaking changes from January 1st and you will anyway need to re-write this query to keep it working. So I would suggest that you try to make your query and pagination work properly with the new API version. You can pass an argument in the headers to use the stable 2023-10 version, you will see that you will have more errors.

Here are the links that talk about the API changes and how to migrate:

https://community.monday.com/t/api-version-2023-10-is-stable-remember-to-migrate-your-applications/6...

https://developer.monday.com/api-reference/docs/migrating-to-v-2023-10