How do I query and return only two or three column values?

monday Apps & Developers
,
1

I want to return two column values (not just one).

This code get’s me one column value for ship_date but I cannot figure out how to get another column like text4.

items { id name column_values (ids: “ship_date” ) { id value }

the above works but the following does not:

items { id name column_values (ids: “ship_date” “text4” ) { id value }

2

@dborgnino You need to put those column ids in an array – ["ship_date","text4"] – & specify either the board ids or the item ids too:

Querying one (or more) board(s):

query {
  boards(ids: ["1642425449"]) {
    items_page {
      items {
        id
        name
        column_values(ids: ["ship_date","text4"]) {
          id
          value
        }
      }
    }
  }

Querying one (or more) item(s):

query {
  items(ids: ["1904901462"]) {
    id
    name
    column_values(
      ids: ["ship_date","text4"]
    ) {
      id
      value
    }
  }
}