Add Row with a CONTACT_LIST column [ANSWERED]

AES Corp Apps
edited 09/14/21 in API & Developers


We have a sheet with a column of type CONTACT_LIST. We have a form that populates this field with a name the user enters, rather than an email. The form populates the sheet even if the name doesn't exist in our contacts list.

We want to use an API call to insert a new row into the sheet in the same way the form does. However, we are getting error code 1042 because of strict requirements for CONTACT_LIST if we try to insert a name, but succeeds if we put in an email.

Is there a way to add a row with a name in the CONTACT_LIST column via API call?

Thank you.