Setting Contact column to Placeholder using the API

hiker360
hiker360 ✭✭
edited 04/02/24 in API & Developers

I am programmatically updating a sheet using the SmartSheets API. I need to set a column that is a CONTACT type to a Resource Manager placeholder. When I do, I get the error message "The value for cell in column 6143599851818884, did not conform to the strict requirements for type CONTACT." Typically a contact can be set using the email address. However placeholders do not have email addresses so I attempt to set the placeholder text.

As an FYI, the field I'm trying to set is the Assigned To which is used in the RM integration.

When I look at the raw data for an existing value containing a placeholder it looks like

{

          "columnId": 6143599851818884,

          "value": ".NET Placeholder"

   }

Where as a typical user looks like

{

          "columnId": 6143599851818884,

          "value": "joshua.user@company.com",

          "displayValue": "Josh User"

        },


Using the APIs, how can I set the column value to the placeholder text?

Answers

  • Leibel S
    Leibel S ✭✭✭✭✭✭

    Try adding the overrideValidation = true in the query parameters, and within the cell object add strict = false

  • Good idea. Unfortunately still didn't work. Still get the error: The value for cell in column 6143599851818884, did not conform to the strict requirements for type CONTACT. Smartsheet support said that what I wanted to do was not supported.