Timeouts occur in nearly every request after approximately 1 minute when extracting all data from a single board

Platform discussions monday apps & integrations
1

Hi!
I’m experiencing a critical issue with one of my customers where data extraction from Monday often results in a timeout. I am attempting to extract all data from one board using the following body:
{
“query”:“query {boards (ids: 1111122223333){items {name column_values{ description title value text}}}}”
}

The board comprises approximately 400 rows and 50 columns. Does anyone know how to address the timeout problem?

2

Hi @Ludwe

I would start with transforming this API call to the 2023-10 version, as the current one will stop working in January 15th. The new API version gives you better control with cursor based pagination. See Items page

3

Something like:

query getItemValuesInBoard ($boardId: ID!, $columnId: [String!], $rules: [ItemsQueryRule!], $order: [ItemsQueryOrderBy!])  {
        complexity {
          reset_in_x_seconds
          before
          after
        }
        boards (ids: [$boardId]) {
          items_page (limit:100, query_params: {rules: $rules, order_by: $order}) {
            cursor
            items {
              id
              name
              column_values (ids: $columnId) {
                id
                value
                text
                ... on DependencyValue {
                  id
                  value
                  linked_item_ids
                }
              }
            }
          }
        }
      }

Followed by (in case you got a cursor that is not null) a loop to retrieve the rest of the data

query getItemValuesInBoard ($columnId: [String!], $cursor: String!) {
          complexity {
            reset_in_x_seconds
            before
            after
          }
          next_items_page (limit:100, cursor: $cursor) {
            cursor
            items {
              id
              name
              column_values (ids: $columnId) {
                id
                value
                text
                ... on DependencyValue {
                  id
                  value
                  linked_item_ids
                }
              }
            }
          }
        }