SSIS Components for Zoho Projects

Build 26.0.9770

TaskActivities

Retrieve details of who modified a specific task and when.

Select

  • TaskId is required to retrieve Task Activities.
You can use the below query to get all Activities for a given Task:
SELECT * FROM TaskActivities WHERE TaskId = '123456789' 

Columns

Name Type Description
Id [KEY] Long Task Activity Id.
TaskId Long Task Id.
Name String Task Activity Name.
OldValue String Task Activity Old Value.
NewValue String Task Activity New Value.
State String Task Activity State.
ActionTime Datetime Task Activity Action Time.
ActionByZpuid Long Task Activity Action By Zpuid.
ActionByZuid Long Task Activity Action By Zuid.
ActionByFirstName String Task Activity Action By First Name.
ActionByLastName String Task Activity Action By Last Name.
ActionByName String Task Activity Action By Display Name.
ActionByEmail String Task Activity Action By Email.

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