The component models Microsoft Planner data like tasks, plans, and buckets as relational tables, allowing you to write SQL to query and modify Microsoft Planner data. Live connectivity to these objects means that any changes to your Microsoft Planner account are immediately reflected in the connection exposed by the component.

Tables

The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Microsoft Planner account.

The following tables and views are shipped with the component:

Table	Description
Buckets	Defines custom columns for tasks, allowing users to categorize work into phases, task types, or departments for better organization.
PlanDetails	Stores metadata and additional settings related to a specific plan, enhancing its customization and management.
Plans	Represents individual plans, each associated with a group, to organize and track project-related tasks.
TaskDetails	Holds detailed information for tasks, including attributes such as priority, due dates, and custom fields.
Tasks	Manages individual tasks, providing functionality for planning, assigning, and tracking initiatives across various projects.
Groups	Represents the groups created automatically when a new plan is initiated, serving as the foundational organizational unit for tasks and plans.
TaskAssignments	Provides a unified view of all tasks assigned to various users, aiding in task tracking and accountability.
TaskComments	Captures discussions, notes, and comments related to tasks within a plan, fostering collaboration and communication.
Users	Tracks user-specific task views and preferences, enabling personalized task management experiences.

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including updating task board formats and retrieving OAuth credentials.