SOLVED

Planner API

%3CLINGO-SUB%20id%3D%22lingo-sub-159083%22%20slang%3D%22en-US%22%3EPlanner%20API%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-159083%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20list%20all%20plans%20in%20the%20planner%20hub%20using%20the%20API%3F%26nbsp%3B%20It%20looks%20like%20it%20wants%20a%20group%20id.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fgraph.microsoft.com%2Fv1.0%2Fgroups%2F%7Bgroup-id-with-plan%7D%2Fplanner%2Fplans%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgraph.microsoft.com%2Fv1.0%2Fgroups%2F%7Bgroup-id-with-plan%7D%2Fplanner%2Fplans%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-159083%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAPI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPlanner%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-161975%22%20slang%3D%22en-US%22%3ERe%3A%20Planner%20API%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-161975%22%20slang%3D%22en-US%22%3E%3CP%3Et%20is%20possible%20-%20but%20there%20is%20an%20assumption%20that%20you%20have%20permission%20on%20all%20the%20plans%20-%20sounds%20like%20this%20might%20not%20be%20the%20case%20if%20you%20get%20a%20401.%26nbsp%3B%20I%20think%20there%20are%20plans%20for%20a%20reporting%20API%20at%20some%20point%20that%20will%20help%20with%20a%20lot%20of%20these%20types%20of%20requests.%26nbsp%3B%20UserVoice%20is%20a%20good%20place%20to%20register%20your%20interest.%20%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fplanner.uservoice.com%2Fforums%2F330525-microsoft-planner-feedback-forum%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fplanner.uservoice.com%2Fforums%2F330525-microsoft-planner-feedback-forum%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EBest%20regards%2C%3C%2FP%3E%0A%3CP%3EBrian%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-161173%22%20slang%3D%22en-US%22%3ERe%3A%20Planner%20API%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-161173%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20requirement%20is%20the%20pull%20the%20report%20of%20Assignee%20..%20Task%20Name%20and%20ID%20when%20I%20give%20the%20Planner%20Name.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn-order%20to%20achieve%2C%20i%20found%20that%20we%20need%20to%20iterate%20the%20Group%20ID..%20then%20Plan%20ID...%20and%20then%20get%20all%20task%20details.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20was%20trying%20to%20iterate%20the%20Group%20ID%20from%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgraph.microsoft.com%2Fv1.0%2Fgroups%3F%24filter%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgraph.microsoft.com%2Fv1.0%2Fgroups%3F%24filter%3C%2FA%3E%20%3D%20displayName%20eq%20'Planner%20Name'%20where%20I%20got%20the%20details.%20From%20this%20query%2C%20i%26nbsp%3Bgave%20my%20input%20for%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgraph.microsoft.com%2Fv1.0%2Fgroups%2FGroupID%2Fplanner%2Fplans%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgraph.microsoft.com%2Fv1.0%2Fgroups%2FGroupID%2Fplanner%2Fplans%3C%2FA%3E.%20where%20it%20works%20in%20Graph%20Explorer%20API%20but%20when%20i%20tried%20through%20PowerShell%20IDE.%20It%20throws%20401%20unauthorized.%20I%20tried%20to%20re-authorize%20again%20through%20Connect-PNPOnline%20it%20works%20but%20didn't%20help%20me%20in%20PowerShell%20IDE.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%26nbsp%3Bsomeone%20help%20me%20out.%20whether%20nested%20looping%20group%20ID%2C%20Plan%20ID%20is%20possible.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-159427%22%20slang%3D%22en-US%22%3ERe%3A%20Planner%20API%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-159427%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20article%20by%20Brian%20Smith%20looks%20like%20it%20has%20everything%20I%20need.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20title%3D%22Microsoft%20Planner%3A%20Considerations%20for%20Reporting%E2%80%93Part%201%22%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fbrismith%2F2017%2F08%2F02%2Fmicrosoft-planner-considerations-for-reporting-part-1%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20Planner%3A%20Considerations%20for%20Reporting%E2%80%93Part%201%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20again%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-159421%22%20slang%3D%22en-US%22%3ERe%3A%20Planner%20API%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-159421%22%20slang%3D%22en-US%22%3E%3CP%3EThanks.%26nbsp%3B%20I%20was%20asked%20to%20get%20all%20the%20plans%20out%20to%20do%20some%20reporting.%26nbsp%3B%20Would%20I%20be%20able%20to%20use%20flow%20to%20capture%20certain%20aspects%20of%20the%20plan%20and%20send%20it%20into%20another%20source%20that%20I%20could%20use%20for%20this%20kind%20of%20reporting%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-159232%22%20slang%3D%22en-US%22%3ERe%3A%20Planner%20API%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-159232%22%20slang%3D%22en-US%22%3EIt%20is%20not%20possible%20to%20retrieve%20all%20the%20plans%20directly%20without%20using%20group-id.%20But%20you%20can%20reterive%20the%20user's%20favorite%20plans%20using%20the%20below%20API.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdeveloper.microsoft.com%2Fen-us%2Fgraph%2Fdocs%2Fapi-reference%2Fbeta%2Fapi%2Fplanneruser_list_favoriteplans%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.microsoft.com%2Fen-us%2Fgraph%2Fdocs%2Fapi-reference%2Fbeta%2Fapi%2Fplanneruser_list_favoriteplans%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Is it possible to list all plans in the planner hub using the API?  It looks like it wants a group id.

 

https://graph.microsoft.com/v1.0/groups/{group-id-with-plan}/planner/plans

 

Thanks.

5 Replies
Highlighted
Best Response confirmed by Juan Carlos González Martín (MVP)
Solution
It is not possible to retrieve all the plans directly without using group-id. But you can reterive the user's favorite plans using the below API.

https://developer.microsoft.com/en-us/graph/docs/api-reference/beta/api/planneruser_list_favoritepla...
Highlighted

Thanks.  I was asked to get all the plans out to do some reporting.  Would I be able to use flow to capture certain aspects of the plan and send it into another source that I could use for this kind of reporting?

Highlighted

This article by Brian Smith looks like it has everything I need.

 

Microsoft Planner: Considerations for Reporting–Part 1

 

Thanks again for your help.

My requirement is the pull the report of Assignee .. Task Name and ID when I give the Planner Name. 

 

In-order to achieve, i found that we need to iterate the Group ID.. then Plan ID... and then get all task details.

 

I was trying to iterate the Group ID from https://graph.microsoft.com/v1.0/groups?$filter = displayName eq 'Planner Name' where I got the details. From this query, i gave my input for https://graph.microsoft.com/v1.0/groups/GroupID/planner/plans. where it works in Graph Explorer API but when i tried through PowerShell IDE. It throws 401 unauthorized. I tried to re-authorize again through Connect-PNPOnline it works but didn't help me in PowerShell IDE. 

 

Could you someone help me out. whether nested looping group ID, Plan ID is possible.

Highlighted

t is possible - but there is an assumption that you have permission on all the plans - sounds like this might not be the case if you get a 401.  I think there are plans for a reporting API at some point that will help with a lot of these types of requests.  UserVoice is a good place to register your interest.  https://planner.uservoice.com/forums/330525-microsoft-planner-feedback-forum 

Best regards,

Brian