How to set the value via Python APIs for simple CONTACT_LIST column ?

Hi,

i have the column where the type is CONTACT_LIST (single value only, not multiple values) ...

here is the code snippet:

case_owner_email = "owner.name@company.com"

new_row.cells.append({

'column_id': project_metadata_column_map["Case Owner"],

'value': case_owner_email

})

all my email addresses are correct, and all my owners are registered users in Smartsheet, but sometimes, when i open the sheet, i get correct user (pic + name), but other times i get only email address ...

i need that this is always user ...

so, is there any specific formatting for the value ?

thx & rgrds,

ljk

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @lkrobot

    I'm not sure why it will sometimes show as an email and sometimes show as the full contact with the name, however if you're using the API you can standardize this by providing the name for the contact as the displayValue in your API call.

    I hope that helps!

    Genevieve

  • Parker Oxford
    Parker Oxford ✭✭✭✭✭

    Have the people who don't show up correctly have all their information filled out? I don't think this is an API issue as the email will link to the account so as long as the user has all their information populated on their smartsheet account it will show up in the cells when the email is inserted.


    ( @ me in your replies or I'll lose your response! )