Skip to content

Set Field Value

PATCH
/fields/{column_id}/values

Write a custom column value to a single contact or company row.

Resolves column_id to the underlying column_name_db from dynamic_columns, then performs an INSERT ... ON CONFLICT DO UPDATE against mashup_contact_attrs (or mashup_company_attrs for companies).

Pass value=null (or omit it) to clear the column for that row.

Notes: - The column must exist in dynamic_columns (not soft-deleted) for this org and the matching entity. Returns 404 otherwise. - The record (contact or company) must exist - the underlying foreign key constraint enforces this; a missing record yields a 404. - Custom column writes do NOT trigger view recreation; only column creation does (see CdpMashupContactRepository.create_column).

Authorizations

Parameters

Path Parameters

column_id
required

Column ID from g8_list_fields or g8_create_field

integer

Column ID from g8_list_fields or g8_create_field

Header Parameters

X-Target-Org-Id
Any of:
string

Request Body required

Request body for writing a custom column value to a single contact or company row.

object
entity

Target entity: ‘contacts’ or ‘companies’

string
default: contacts
record_id
required

Contact ID (entity=‘contacts’) or company ID (entity=‘companies’)

integer
value
Any of:
string

Responses

200

Successful Response

object
data
required
object
column_id
required
integer
record_id
required
integer
updated
boolean
default: true
pagination
Any of:
object
has_next
required

Whether there are more pages

boolean
limit
required

Items per page

integer
next_cursor
Any of:
string
page
required

Current page number (1-indexed)

integer
total
required

Total number of items

integer

422

Validation Error

object
detail
Array<object>
object
loc
required
Array
msg
required
string
type
required
string