Query to get all information of a group without knowing the schema, in particular all column names of expandable subelements table

monday Apps & Developers
, , ,
1

A group has these expandable “Unterelemente” (subelements, i.e. a full sub-table attached to each item). I would like to query/mutate these subelements but I am unable to get the full schema of the sub-thing (Generally I find it difficult to retrieve the full schema of a specific board/group with really all IDs, titles, formats etc such that one can thereafter access each value). The following query is what got me at least the row names of the sub-table, but it lacks the column ids/names (hence I don’t know how to access them).

    query = '''
    query {
    boards(ids: %s) {
        groups(ids: %s) {
        items(ids: %i) {
            name
            column_values {
            text
            value
            type
            title
            }
        }
        }
    }
    }
    ''' % (board_id, group_id, item_id)
2

Hello there @charter,

You could use a query like this one to get the board ID of the subitems board:

{
  boards(ids: 1234567890) {
    items_page(limit: 500) {
      items {
        subitems {
          board {
            id
          }
        }
      }
    }
  }
}

Then you could use that to get the column titles and IDs (from the subitems board):

{
  boards(ids: 1122334455) {
    columns {
      id
      title
    }
  }
}

I hope that helps!

Cheers,
Matias

1 Like