Hello there @leelingyan and welcome to the community!

I hope you like it here 💪

Which query are you using and which response are you getting exactly?

Which version of the API are you using for your query?

Looking forward to hearing from you 🙂

Cheers,

Matias

Hi Matias, I am now trying to use version 2023-10 to retrieve mirrored column values (item IDs) as 2023-07 will be discontinued. However, the code does not work. I might be doing something wrong.

{ items (ids: [Zap Data Value]) { column_values { ... on ItemIdValue { column { dup__of_employer_pulse_id, dup__of_helper_pulse_id8 } text } } } }

The error message get is: Field ‘dup__of_employer_pulse_id’ doesn’t exist on type ‘Column’. But these 2 columns are mirrored columns.

Best,

Ling Yan

Hello again @leelingyan,

It looks like you are trying to pass “Zap Data Value” as item IDs, when item IDs are supposed to look something like: 4508311111

You are also passing the column IDs when you don’t really need them necessarily.

You can use a query like this one:

query {

  items (ids: 1234567890, 2233445566]) {

    column_values {

      ... on MirrorValue {

        value

        display_value

        column{

          title

          id

        }

      }

    }

  }

}

You can find the documentation about it here 😁

Hope that helps!

Cheers,

Matias

Hi Matias,

Thank you so much. I am looking for a way to retrieve specific column values, which was available in column_values v1 with this code:

{ items (ids: [Zap Data Value]) { name column_values (ids: [phone, email_text, marital_status]) { id text } } }

Is there a way to replicate this with column_values v2?

I believe this is what you are looking for:

query {

  items (ids:[1234567890, 1122334455]) {

    column_values (ids:["text", "date4", "mirror"]) {

      value

      text

      ... on MirrorValue {

        value

        display_value

        column {

          title

          id

        }

      }

    }

  }

}

Please let me know how that goes!

Cheers,

Matias

Hi Matias,

Thank you very much, this works!

I am glad that is the case! Happy to help 😁