Endpoint Update [Dynamic Endpoint]

Name

put_[dynamic_endpoint_name]

Description

No description available

Related Tables

[Dynamic Table]

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Zoho CRM Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Destination

This Endpoint belongs to the [Dynamic Table] table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to update [dynamic endpoint]:

API Destination - Zoho CRM

Zoho CRM Connector can be used to integrate Zoho CRM API in your App / BI Tools. You can exchange data on Accounts, Leads, Contacts and many other modules.

Zoho CRM

[Dynamic Table]

Update

Optional Parameters
Triggers	"approval","workflow","blueprint"

ODBC application

Use these SQL queries in your ODBC application data source:

Update Owner of the record(s) - Account, Contacts, Deals, Leads (Update Lookup field)

This examples shows how to update a lookup type fields (e.g. Account, Contact, Owner) for any module. Lookup fields are jsonobject type of fields which has id, name and sometimes email (only for Owner). This example shows how to update using unique field (E.g. email, id or name). Below example shows how to set Owner of the Account (e.g.) 1558554000137221573. We will set owner to bob-the-salesman@abc.com (or you can set by id)

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

Update Account or Contact (Lookup field) by Name or Id for Deals

This examples shows how to update Account and Contact field on Deals module. We used name for account and id for contact just to show how unique field can be used.

UPDATE Deals 
SET Account_Name='{"name": "Company ABCD"}',    --by name or id 
    Contact_Name='{"id": "1558554000186378001"}'  --by id 
Where Id='1558554000137221573'

Update table for specific record

Update Leads SET Designation='VP Sales', Company='Test' Where id=1558554000012181009

Update table for specific record (older version)

Update Leads SET id='1558554000012181009' /* id must be supplied */, Designation='VP Sales', Company='Test'

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Update Owner of the record(s) - Account, Contacts, Deals, Leads (Update Lookup field)

This examples shows how to update a lookup type fields (e.g. Account, Contact, Owner) for any module. Lookup fields are jsonobject type of fields which has id, name and sometimes email (only for Owner). This example shows how to update using unique field (E.g. email, id or name). Below example shows how to set Owner of the Account (e.g.) 1558554000137221573. We will set owner to bob-the-salesman@abc.com (or you can set by id)

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

EXEC (@MyQuery) AT [LS_TO_ZOHO_CRM_IN_GATEWAY];

Update Account or Contact (Lookup field) by Name or Id for Deals

This examples shows how to update Account and Contact field on Deals module. We used name for account and id for contact just to show how unique field can be used.

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Deals 
SET Account_Name=''{"name": "Company ABCD"}'',    --by name or id 
    Contact_Name=''{"id": "1558554000186378001"}''  --by id 
Where Id=''1558554000137221573''';

EXEC (@MyQuery) AT [LS_TO_ZOHO_CRM_IN_GATEWAY];

Update table for specific record

DECLARE @MyQuery NVARCHAR(MAX) = 'Update Leads SET Designation=''VP Sales'', Company=''Test'' Where id=1558554000012181009';

EXEC (@MyQuery) AT [LS_TO_ZOHO_CRM_IN_GATEWAY];

Update table for specific record (older version)

DECLARE @MyQuery NVARCHAR(MAX) = 'Update Leads SET id=''1558554000012181009'' /* id must be supplied */, Designation=''VP Sales'', Company=''Test''';

EXEC (@MyQuery) AT [LS_TO_ZOHO_CRM_IN_GATEWAY];