SSIS Components for Microsoft Planner

Build 24.0.9175

PlanDetails

Stores metadata and additional settings related to a specific plan, enhancing its customization and management.

Table Specific Information

Select

The component will use 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 component.

  • PlanId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM PlanDetails WHERE planId = 'nETc1IDpYkmb1E17w8TxGmUAGFWC'

INSERT

INSERT is not supported for this table.

Update

Microsoft Planner allows updates for the title, bucketId, percentComplete, assigneePriority, conversationThreadId, orderHint, dueDateTime and startDateTime columns.

UPDATE PlanDetails SET categoryDescriptions_category1 = 'Cat#1', categoryDescriptions_category2 = 'Cat#2', categoryDescriptions_category3 = 'Cat#3', categoryDescriptions_category4 = 'Cat#4', categoryDescriptions_category5 = 'Cat#5', categoryDescriptions_category6 = 'Cat#6'  WHERE PlanId = 'nETc1IDpYkmb1E17w8TxGmUAGFWC'

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
PlanId [KEY] String False

Unique identifier for the plan, used to distinguish it from other plans in the system.

categoryDescriptions_category1 String False

Indicates if the task is associated with the pink category, commonly used for color-coded task organization.

categoryDescriptions_category10 String False

Indicates if the task is associated with the gray category.

categoryDescriptions_category11 String False

Indicates if the task is associated with the silver category.

categoryDescriptions_category12 String False

Indicates if the task is associated with the brown category.

categoryDescriptions_category13 String False

Indicates if the task is associated with the cranberry category.

categoryDescriptions_category14 String False

Indicates if the task is associated with the orange category.

categoryDescriptions_category15 String False

Indicates if the task is associated with the peach category.

categoryDescriptions_category16 String False

Indicates if the task is associated with the marigold category.

categoryDescriptions_category17 String False

Indicates if the task is associated with the light green category.

categoryDescriptions_category18 String False

Indicates if the task is associated with the dark green category.

categoryDescriptions_category19 String False

Indicates if the task is associated with the teal category.

categoryDescriptions_category2 String False

Indicates if the task is associated with the red category, often symbolizing high-priority or critical tasks.

categoryDescriptions_category20 String False

Indicates if the task is associated with the light blue category.

categoryDescriptions_category21 String False

Indicates if the task is associated with the dark blue category.

categoryDescriptions_category22 String False

Indicates if the task is associated with the lavender category.

categoryDescriptions_category23 String False

Indicates if the task is associated with the plum category.

categoryDescriptions_category24 String False

Indicates if the task is associated with the light gray category.

categoryDescriptions_category25 String False

Indicates if the task is associated with the dark gray category.

categoryDescriptions_category3 String False

Indicates if the task is associated with the yellow category, often symbolizing caution or tasks requiring attention.

categoryDescriptions_category4 String False

Indicates if the task is associated with the green category, commonly used for tasks signaling progress or success.

categoryDescriptions_category5 String False

Indicates if the task is associated with the blue category, often representing trust or stability.

categoryDescriptions_category6 String False

Indicates if the task is associated with the purple category, typically used for strategic or creative tasks.

categoryDescriptions_category7 String False

Indicates if the task is associated with the bronze category.

categoryDescriptions_category8 String False

Indicates if the task is associated with the lime category.

categoryDescriptions_category9 String False

Indicates if the task is associated with the aqua category.

sharedWith String False

Lists the files or entities with which the plan is shared, enabling collaboration and visibility.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175