Skip to main content

Microsoft Planner

Read your Planner data — plans, buckets, tasks — and create tasks in bulk straight from a SQL query.

Read​

SELECT * FROM graph_planner_plans();
SELECT * FROM graph_planner_buckets(plan => 'Q2 Launch');
SELECT title, percentComplete, due_date
FROM graph_planner_tasks(plan => 'Q2 Launch');

Bulk-create tasks​

Useful for backfilling work from a spreadsheet or upstream system:

SELECT graph_planner_create_task(
  plan => 'Q2 Launch',
  bucket => 'Engineering',  -- resolved by name, no GUID needed
  title => task_name,
  due_date => due_date
)
FROM new_tasks;

Bucket name resolution is built in — no need to fetch IDs first.