How to get email value from a column that is a multi-select contact list?

road_12333444

For some reason, in my sheet when a column is a multi-select contact list it doesn't pull back the email value via api. What is the best approach to fix this?

Lee Joramo

You probably need to specify these parameters in your request:

 include: "objectValue",
 level: "2"

By default, Smartsheet returns Multi-contact and Multi-picklists as simple Text/Numbers to maintain backward compatibility. Therefore, you must ask for the columns object and level.

https://smartsheet.redoc.ly/#section/API-Basics/Multi-contact-or-Multi-picklist:-Working-with-Complex-Objects

More more details about how to access these objects there was a Developer Blog Post about this:

https://developers.smartsheet.com/blog/leveling-up-understanding-multi-contact-and-multi-picklist-columns-in-the-smartsheet-api

And note there are some differences in the levels used between getting sheets and reports.