API query for items/boards based on owner?

monday Apps & Developers
1

I’m trying to retrieve a small set of Items for team capacity planning. It can be based on the board owners, subscribers, or just Item task owners. Currently, if I query all open tasks across my org, it will result in tens of thousands of record requests which feels wasteful considering API limits. I’ve tried to limit the query using “owner:‘John Doe’” as an argument in both the Boards and Items fields. Neither works.

Example:
{
items (owner:“john doe”, state:active)
{
…
}
}

Is there a way to accomplish this or must I export the large data set of the entire company and filter it down to just my team known members?

2

Hey @myounger – you can use the “items_by_column_values” query to filter a board to only the items that match a given column value. However, this query only works for exact matches and does not support every column.

Do try it out! Here’s the documentation for that particular query: items_by_column_values