Skip to main content

Problem retrieving all results from board

  • October 23, 2022
  • 4 replies
  • 1053 views
W

Hi, I have connected via API with my board in which contains 600 row entries + 800 subtasks. I want to retrieve only the rows of course but since there is a timeout of 60 seconds, i am only able to retrieve 300 at a time.

  1. how can i run the script a 2nd time to retrieve rows 301-600 for example?
  2. is there a way i can filter the results so that i can limit the number in results, for example, I want all the ones where in column A = status 123?

I use the below query
query { boards (ids: 123456789) { name id items { name column_values{id type text }} }}';

This topic has been closed for replies.

4 replies

Matias.Monday
Forum|alt.badge.img
  • Matias.Monday
  • monday.com Team Member
  • October 24, 2022

Hello there @webwizny!

You can use pagination to go through the items. It would look like this:
query { boards (ids: 123456789) { name id items (limit: 300, page: 1) { name column_values{id type text }} }}

Then once you get the response to that, you change the “page: 1” for “page: 2” to get the second page (items 301 to 600) and you continue iterating until the response gives you less than 300 items.

Regarding the second question, you can use item_by_column_values as explained here.

I hope that helps!

Cheers,
Matias

    W
    • webwizny
    • Author
    • New Participant
    • October 24, 2022

    Thank you very much @Matias.Monday !! it worked perfectly

      Matias.Monday
      Forum|alt.badge.img
      • Matias.Monday
      • monday.com Team Member
      • October 25, 2022

      Glad to help @webwizny !

      A
      • Anonymous
      • November 1, 2022

      This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

      Terms & ConditionsCookie settingsAccessibility statement