SSIS Components for Zoho Projects

Build 26.0.9770

Tags

Fetches all the tags present in a specific portal.

Select

You can use the below query to get all Tags:
SELECT * FROM Tags

Insert

To create a new Tag, Name is required. You can specify the following fields to create a tag:

INSERT INTO Tags (Name, ColorHexcode) VALUES ('New Tag', 'bg-tag16') 

Update

To update a Tag specify the Id field.

UPDATE Tags SET Name = 'Updated Name', ColorHexcode = 'bg-tag99' WHERE Id = '123456000000043057'

Delete

Tags can be deleted by providing the Id and issuing a DELETE statement.

DELETE FROM Tags WHERE Id = '123456000000043057' 

Columns

Name Type ReadOnly Description
Id [KEY] Long True

Tag Id.

Name String False

Tag Name.

ColorHexcode String False

Tag Color Hexcode.

UsageCount Integer True

Tag Usage Count.

CreatedById Long True

Tag Created By Id.

CreatedByName String True

Tag Created By Name.

CreatedByEmail String True

Tag Created By Email.

CreatedByFirstName String True

Tag Created By First Name.

CreatedByLastName String True

Tag Created By Last Name.

CreatedByFullName String True

Tag Created By Full Name.

CreatedByZpuid String True

Tag Created By Zpuid.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770