Get Monday Board Data to Power BI Report via API 2024-01

monday Apps & Developers
, , ,
1

Hi.

I improved the souce code from Guilherme Chaguri to add a Recursive Function to get all the data from the Monday board via API 2024-01.

I use this function for my work. and are happy to share it for everyone to use.

Download this function code from my post in Guichaguri’s Github.

2

Thank you for sharing your script!

4

HI Wora2024, is there a reason it it limited to 500 items? I had tried to increase it but it wont let me, do you know how to increase?

5

500 items is the maximum number of items the monday.com API can return from a board in a single API call.

2 Likes
7

How can this code be updated to account for expiring cursors? I’ve been using this for about a month but now am getting the following error, and I can’t figure out how to fix it: error_message=CursorExpiredError: The cursor provided for pagination has expired. Please refresh your query and obtain a new cursor to continue fetching items

8

Hello there @cgl775 and welcome to the community!

Would you be able to please fill this form so our team can take a look into this? Please add as much detail about your case as possible.

Looking forward to hearing from you via the form!

Cheers,
Matias

9

Hello I used this script unfortunately I encountered an error stating

Expression.Error: There weren’t enough elements in the enumeration to complete the operation.
Details:
[List]

Wondering if you guys can help? Is this a problem with API or what could this be?

10

Hello there @rhiannec and welcome to the community!

That error message does not look like an issue with the API. It looks like an issue with the script. Since we did not create this script, I can not comment on it.

Cheers,
Matias