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

road_12333444 · 03/11/24

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 · 03/12/24

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.

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

Answers

Categories