JDBC Driver for Asana

Build 24.0.9062

ProjectTemplates

TO get ProjectTemplates in the Team or workspace.

Columns

Name Type References Description
Id [KEY] String Globally unique identifier of the resource, as a string.
Color String Color of the project template.
Description String Free-form textual information associated with the project template.
Html_description String The description of the project template with formatting as HTML.
Name String Name of the project template.
OwnerId String

Users.Id

A user object. Globally unique identifier of the resource, as a string.
OwnerName String A user object. The base type of this resource.
OwnerResourceType String A user object. Read-only except when same user as requester. The name of the User.
IsPublic Boolean True if the project template is public to its team.
RequestedDates String Array of date variables in this project template. Calendar dates must be provided for these variables when instantiating a project.
ResourceType String The base type of this resource.
TeamId String

Teams.Id

A team is used to group related projects and people together within an organization. Globally unique identifier of the resource, as a string.
TeamName String A team is used to group related projects and people together within an organization. The name of the team.
TeamResourceType String A team is used to group related projects and people together within an organization. The base type of this resource.

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
WorkspaceId String The workspace Id to filter results on.

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