CData Python Connector for Asana

Build 24.0.9062

TimeTrackingEntries

Returns time tracking entries for a given task.

Table Specific Information

Select

The 本製品 will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

  • Id supports the '=' comparison.
  • TaskId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM TimeTrackingEntries WHERE Id = '1204862911885011'

SELECT * FROM TimeTrackingEntries WHERE TaskId = '1203479447771600'

When executing a query without one of the above filters, due to the Asana API design, time tracking entries must be retrieved per task. The 本製品 will first query the workspace to retrieve a list of projects. A separate request will then be made for each project to retrieve all the applicable tasks. Then requests to get time tracking entries on each task will be made. In theory, this is similar to executing the following query:

SELECT * FROM TimeTrackingEntries WHERE TaskId IN (SELECT Id FROM Tasks)

Insert

TaskId is a mandatory column for inserting into TimeTrackingEntries table. For example:

INSERT INTO TimeTrackingEntries (TaskId, DurationMinutes, EnteredOn) VALUES ('1203125557018947', 3600, '2024-01-01')

Update

Following is an example of how to update a TimeTrackingEntries table:

UPDATE TimeTrackingEntries SET DurationMinutes = 4000, EnteredOn = '2023-01-01' WHERE Id = '1208387811113769'

Delete

Following is an example of how to delete from TimeTrackingEntries table:

DELETE FROM TimeTrackingEntries WHERE Id = '1208387811113769'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Globally unique ID of the team.

ResourceType String True

The base type of this resource.

CreatedBy String True

A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks.

CreatedByResourceType String True

The base type of the CreatedBy user resource.

CreatedByName String True

The user's name.

DurationMinutes Integer False

Time in minutes tracked by the entry.

EnteredOn Date False

The day that this entry is logged on.

CreatedAt Datetime True

The time at which this resource was created.

TaskId String False

The associated Task's object Id. The task is the basic object around which many operations in Asana are centered.

TaskResourceType String True

The base type of the Task resource.

TaskName String True

The name of the task.

TaskResourceSubtype String True

The subtype of the Task resource.

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