Update a contact
Updates an existing contact by ID. Set the properties you want to change in the SET clause; uncomment other lines to update additional custom properties.
UPDATE Contacts
SET firstname='Brian',
lastname='Halligan (Sample Contact)'
--, custom_number=12.12
--, custom_date='2023-01-01'
--, custom_string='My Test<<FUN_NOW>>'
--, custom_richtext='<p><span style="color: #b5b5b5;">##-Please reply-##</span></p>'
--, custom_multi_select='Blue;Yellow;Black'
--, custom_pickuser=45581955
--, custom_dropdown='BB'
--, custom_checkbox='true'
WHERE Id=51