How to retrieve mirrored column values with v2 in Zapier Webhooks?

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 😁