JDBC Driver for Zoho Projects

Build 22.0.8462

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 you can specify the following fields:

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

Update

To update a Tag specify the Id field.

UPDATE Tags SET Name = 'Updated Name', ColorClass = '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] String False

Tag Id.

Name String False

Tag Name.

ColorClass String False

Tag Color Class.

CreatedBy String False

Tag Created By.

CreatedByName String False

Tag Created By Name.

CreatedByEmail String False

Tag Created By Email.

CreatedByFirstName String False

Tag Created By First Name.

CreatedByLastName Unknown False

Tag Created By Last Name.

CreatedByIsClientUser Boolean False

Tag Created By Is Client User.

CreatedByZpuid String False

Tag Created By Zpuid.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Tags String

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462