TaskAssignments
Displays a consolidated list of tasks assigned.
Table Specific Information
Select
The connector uses the Microsoft Planner 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.
If Scope = NoAdminConsent, List the data related to the groups that the user is a member of.
If Scope = AdminConsent, List all the data related to groups.
- TaskId supports the '=' operator.
- PlanId supports the '=' and 'IN' operators.
- BucketId supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM TaskAssignments WHERE TaskId = 'BCrvyMoiLEafem-3RxIESmUAHbLK'
SELECT * FROM TaskAssignments WHERE PlanId = 'nETc1IDpYk3r3e317w8TxGmUAGFWC'
SELECT * FROM TaskAssignments WHERE PlanId IN ('nETc1IDpYk3r3e317w8TxGmUAGFWC', 'v8iK3uCb30C5I_ocMGu3SGUAHQLI', 't2eNwoPxpEqhZs38GwT1HWUADwjN')
SELECT * FROM TaskAssignments WHERE BucketId = 'qIguxctMLEGHYhmgSVGSNGUAAZOZ'
Columns
| Name | Type | Description |
| TaskId [KEY] | String | The unique identifier for the task. |
| PlanId [KEY] | String | The unique identifier for the plan. |
| BucketId | String | The plan for the task assignment. |
| AssignedToUser [KEY] | String | The label assigned to User corresponds to this field. |
| AssignedByUserId | String | The label assigned by User ID corresponds to this field. |
| AssignedByUserName | String | The label assigned by User Name corresponds to this field. |
| AssignedDateTime | String | The time when the task was assigned. |
| OrderHint | String | The hint used to order assignees in a task. |