Endpoint Delete [Dynamic Endpoint]

Name

delete_[dynamic_endpoint_name]

Description

No description available [API reference]

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 Source

API Source - 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

Delete [Dynamic Endpoint]

Required Parameters
Record ID(s) - Use Comma for multiple (e.g. 111,222)	Fill-in the parameter...
Optional Parameters
Fire Wordflow Trigger

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 delete [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]

Delete

Required Parameters
Record ID(s) - Use Comma for multiple (e.g. 111,222)	Fill-in the parameter...
Optional Parameters
Fire Wordflow Trigger

ODBC application

Use these SQL queries in your ODBC application data source:

Delete single record by Id

Delete exising record by Id (single row). You can supply upto 100 comma seperated Ids

DELETE FROM Accounts WHERE id=11111111111

Delete multiple records by Ids

This example shows how to delete Account Records by multiple Ids. You can supply upto 100 comma seperated Ids

DELETE FROM Accounts WITH(Id='11111,22222,33333')

SQL Server

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

Delete single record by Id

Delete exising record by Id (single row). You can supply upto 100 comma seperated Ids

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Accounts WHERE id=11111111111';

EXEC (@MyQuery) AT [LS_TO_ZOHO_CRM_IN_GATEWAY];

Delete multiple records by Ids

This example shows how to delete Account Records by multiple Ids. You can supply upto 100 comma seperated Ids

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Accounts WITH(Id=''11111,22222,33333'')';

EXEC (@MyQuery) AT [LS_TO_ZOHO_CRM_IN_GATEWAY];