JDBC Driver for Zoho Projects

Build 22.0.8462

Events

Fetches all the tags present in a specific portal.

Select

  • Status supports the following operator =.
For example, the following query is processed server side:
SELECT * FROM Events WHERE Status = 'open'

Insert

To create a new Event you can specify the following fields:

  • Title
  • DurationHour
  • DurationMinutes
  • Location
  • Participants
  • Reminder
  • Repeat
  • ScheduledOn
  • RepeatTimes


INSERT INTO Events (Title, ScheduledOn, DurationHour, DurationMinutes, Participants, Reminder, Repeat, Location)
	VALUES ('SQL Event #2', '2022-03-20T18:00:00', '2', '30', '20081249448', '15 mins', 'only once', 'Test Location 2')

Update

To update an Event specify the Id field.

UPDATE Events
	SET title = 'Updated Title #1', DurationHour = '4', DurationMinutes = '10', ScheduledOn = '2022-05-01T23:12:00', Participants = '20081249448'
	WHERE Id = '123456000000045018'

Delete

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

DELETE FROM Events WHERE Id = '123456000000045018'  

Columns

Name Type ReadOnly Description
Id [KEY] String False

Event Id.

Title String False

Event Title.

CreatedBy String False

Event Created By.

CreatedByZpuid String False

Event Created By ZPUID.

CreatedOn Long False

Event Created On.

DurationHour String False

Event Duration Hour.

DurationMinutes String False

Event Duration Minutes.

Location String False

Event Location.

Occurred Integer False

Event Occurred.

Occurrences Integer False

Event Occurrences.

Participants String False

Event Participants.

ProjectName String False

Event Project Name.

Reminder String False

Event Reminder.

The allowed values are on time, 15 mins, 30 mins, 1 hour, 2 hours, 6 hours, 12 hours, 1 day.

Repeat String False

Event Repeat.

The allowed values are only once, everyday, everyweek, everymonth, everyyear.

ScheduledOn String False

Event Scheduled On.

ScheduledOnLong String False

Event Scheduled On Long.

ScheduledOnTo String False

Event Scheduled On To.

ScheduledOnToLong String False

Event Scheduled On To Long.

RepeatTimes String False

Event Repeat Times.

The allowed values are 2, 3, 4, 5, 6, 7, 8, 9, 10.

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
Status String

Event Status.

The allowed values are open, closed.

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