Skip to main content

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

  • February 6, 2024
  • 7 replies
  • 1364 views

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.

gist.github.com

7 replies

Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • February 7, 2024

Thank you for sharing your script!


  • New Participant
  • February 7, 2024

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?


  • Participating Frequently
  • February 7, 2024

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


  • New Participant
  • February 28, 2024

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


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • February 28, 2024

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


  • New Participant
  • March 1, 2024

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?


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • March 7, 2024

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