Update deal account or contact
Updates the Account and Contact lookup fields for a Deal record. This example demonstrates setting the Account_Name by name and Contact_Name by ID for a specific Deal.
UPDATE Deals
SET Account_Name='{"name": "Company ABCD"}', --by name or id
Contact_Name='{"id": "1558554000186378001"}' --by id
Where Id='1558554000137221573'