How to get email value from a column that is a multi-select contact list?
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?
Answers
-
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.
More more details about how to access these objects there was a Developer Blog Post about this:
And note there are some differences in the
levels
used between getting sheets and reports.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives