EndPoint Add / Update Tags for records

Name

post_tags

Description

Add tags for specified module and specified record id(s). [API reference]

Parameters

Parameter

Label

Required

Options

Description

module

YES

Option	Value
Accounts	Accounts
Activities	Activities
Calls	Calls
Campaigns	Campaigns
Cases	Cases
Contacts	Contacts
Deals	Deals
Events	Events
Invoices	Invoices
Leads	Leads
Price_Books	Price_Books
Products	Products
Purchase_Orders	Purchase_Orders
Quotes	Quotes
Sales_Orders	Sales_Orders
Solutions	Solutions
Tasks	Tasks
Vendors	Vendors
Your_Custom_Module_Name	Your_Custom_Module_Name

Module name for which you like to get settings

ids

Record Id(s) (comma seperated list)

YES

List of Record Id(s) you like to update

tag_names

Tag Id

YES

List of Tag(s) you like to add

over_write

Overwrite

Option	Value
true	true
false	false

Set this to overwrite exising tags for the record(s)

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_WSTR`	`nvarchar(255)`	255	`False`
code	`DT_WSTR`	`nvarchar(255)`	255	`False`
message	`DT_WSTR`	`nvarchar(1000)`	1000	`False`
status	`DT_WSTR`	`nvarchar(255)`	255	`False`
tags	`DT_WSTR`	`nvarchar(1000)`	1000	`True`

If the column you are looking for is missing, consider customizing Zoho CRM Connector.

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Zoho CRM Connector in API Source component to read data or in API Destination component to read/write data:

Add / Update Tags for records using API Source

Zoho CRM

Add / Update Tags for records

SSIS API Source - Read from table or endpoint

Add / Update Tags for records using API Destination

Zoho CRM

Add / Update Tags for records

SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Update Tag(s) for exising records (add or overwrite)

SELECT * FROM post_tags
WITH(
	  module='Accounts'
	, ids='1558554000105151002'
	, tag_names='mytag1,mytag2'
  , over_write='true'
)

SQL Server

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

Update Tag(s) for exising records (add or overwrite)

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM post_tags
WITH(
	  module=''Accounts''
	, ids=''1558554000105151002''
	, tag_names=''mytag1,mytag2''
  , over_write=''true''
)';

EXEC (@MyQuery) AT [LS_TO_ZOHO_CRM_IN_GATEWAY];