TimePeriods
To query time period records or full record for a single time period.
Table Specific Information
Select
The connector 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 connector.
- 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. |