TimePeriods
To query time period records or full record for a single time period.
Table Specific Information
Select
The add-in uses the Asana API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the add-in.
- Id supports the '=' comparison.
- WorkspaceId supports the '=' comparison.
For example, the following queries are processed server-side:
SELECT * FROM TimePeriods where Id = '1200585294122707' SELECT * FROM TimePeriods where WorkspaceId = '1126938837961835'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Globally unique ID of the user. | |
| ResourceType | String | The base type of this resource. | |
| EndOn | String | The localized end date of the time period in YYYY-MM-DD format. | |
| StartOn | String | The localized start date of the time period in YYYY-MM-DD format. | |
| Period | String | The cadence and index of the time period. The value is one of: FY, H1, H2, Q1, Q2, Q3, or Q4. | |
| DisplayName | String | A string representing the cadence code and the fiscal year. | |
| ParentId | String | Globally unique ID of the user. | |
| ParentResourceType | String | The base type of this resource. | |
| ParentEndOn | String | The localized end date of the time period in YYYY-MM-DD format. | |
| ParentStartOn | String | The localized start date of the time period in YYYY-MM-DD format. | |
| ParentPeriod | String | The cadence and index of the time period. The value is one of: FY, H1, H2, Q1, Q2, Q3, or Q4. | |
| ParentDisplayName | String | A string representing the cadence code and the fiscal year. | |
| WorkspaceId | String |
Workspaces.Id | Globally unique ID of the workspace. |