Planner Export Programmatically

%3CLINGO-SUB%20id%3D%22lingo-sub-1483687%22%20slang%3D%22en-US%22%3EPlanner%20Export%20Programmatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1483687%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20wondering%20if%20there%20is%20a%20way%20to%20have%20planner%20run%20the%20%3CEM%3E%22Export%20Plan%20to%20Excel%22%3C%2FEM%3E%26nbsp%3B%20programmatically.%20I've%20searched%20and%20the%20recommended%20way%20seems%20to%20be%20MS%20Graph%2C%20which%20I%20have%20done%2C%20but%20it's%20kind%20of%20cumbersome%20since%20not%20every%20field%20is%20available%20in%20the%20standard%20Flow%20connectors.%20We%20had%20to%20use%20an%20Azure%20HTTP%20connector%20and%20the%20BETA%20endpoint%20to%20pull%20additional%20fields.%20If%20I%20recall%20Labels%20was%20one%20of%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3EUsing%20a%20developer%20tab%2C%20it%20looks%20like%20when%20you%20are%20in%20planner%20and%20run%20the%20export%20it%20uses%26nbsp%3B%3CSTRONG%3Ehttps%3A%2F%2Ftasks.office.com%2FTenant.onmicrosoft.com%2FTasksApiV1%2FGetTasksForPlan%3FplanId%3Dxxx_xxxxxxxxxxxxxxxxxx%20%3C%2FSTRONG%3Efor%20the%20download.%20I've%20tried%20looking%20for%20anything%20on%20the%26nbsp%3B%3CEM%3ETasksApiV1%20%3C%2FEM%3Eendpoint%20but%20I%20cannot%20find%20anything.%20I'm%20assuming%20it's%20not%20an%20open%20endpoint%20and%20perhaps%20strictly%20tied%20to%20Planner%20web.%20Curious%20if%20anyone%20knows%20a%20way%20to%20use%20this%20to%20generate%20this%20report%2C%20through%20Flow%20or%20even%20PowerShell%20would%20be%20great.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I was wondering if there is a way to have planner run the "Export Plan to Excel"  programmatically. I've searched and the recommended way seems to be MS Graph, which I have done, but it's kind of cumbersome since not every field is available in the standard Flow connectors. We had to use an Azure HTTP connector and the BETA endpoint to pull additional fields. If I recall Labels was one of them.

 

Using a developer tab, it looks like when you are in planner and run the export it uses https://tasks.office.com/Tenant.onmicrosoft.com/TasksApiV1/GetTasksForPlan?planId=xxx_xxxxxxxxxxxxxxxxxx for the download. I've tried looking for anything on the TasksApiV1 endpoint but I cannot find anything. I'm assuming it's not an open endpoint and perhaps strictly tied to Planner web. Curious if anyone knows a way to use this to generate this report, through Flow or even PowerShell would be great.

0 Replies