Excel Add-In for Zoho Projects

Build 23.0.8839

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Tags String

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839