Using a Cross Reference Sheet to update column using API

Jen K.

I'm looking to update a dropdown list referencing a column on another sheet using API. Reading through API documentation, it looked like I needed to create a cross reference sheet. How do I now use this new Cross Reference Sheet to update the column dropdown in my target sheet? Thank you!

Paul Newcome

You need to create an array from the values listed in the reference column and update the target column properties with that array.