Column_values 2023-10

[justinvandyk]

Since the 2023-10 API update. Our API has no longer been returning the values of connected columns as text. The only way we can retrieve the information is by using value, which only returns the item ID in a list and not the text value.

Am I doing something wrong or is this part of the update?

query {
  items (ids: 12345) {
    column_values {
      value
      text
    }
  }
}

[xatxat (Simon Kusterer @ Spreadsheet Gorilla)]

Hey!

You now have to do it like this:

query {
  items (ids: 12345) {
    column_values {
      value
      text
      ... on MirrorValue {
        display_value
      }
    }
  }
}

The value will be in the display_value property. It’s documented here: Mirror

– Simon

[Matias.Monday (Matias)]

Thank you @xatxat !!

[justinvandyk]

I’m still getting null on the board_relation

[xatxat (Simon Kusterer @ Spreadsheet Gorilla)]

Ah, I thought you were talking about mirror columns. In that case, try:

query {
  items (ids: 12345) {
    column_values {
      value
      text
      ... on BoardRelationValue {
        display_value
      }
    }
  }
}

see Connect boards

[justinvandyk]

@xatxat

query {
  items (ids: 12345) {
    column_values {
      value
      text
      ... on BoardRelationValue {
        display_value
      }
    }
  }
}

THANK YOU!!!