ODBC guide

Update record owner


Updates the owner of a record (e.g., Account, Contact, Deal, Lead). This example shows how to update a lookup field like Owner using a unique identifier such as email or ID. In this case, the owner of a specific Account is updated by email.

UPDATE Accounts 
SET Owner='{email: "bob-the-salesman@abc.com"}'
--SET Owner='{id: "1558554000186378001"}' --you can also use Id
Where Id='1558554000137221573'