Forum Discussion
Link two projects in Project online using REST API
Hi All,
I have a requirement where I need to link multiple projects to a master project programmatically in Project Online. I've explored several options but haven't had any success so far. I'm looking for guidance or best practices to accomplish this task.
I have the option to use either Python or Power Automate, so any insights or solutions using these tools would be greatly appreciated.
Thanks in advance for your help.
Hi the linking between tasks in two or more schedules, is a manual exercise where you'd open and check out both projects, create a 'simulated master' schedule, create the linkages between the schedules, the NOT save the master but publish the projects with the cross project links established. Due to the nature of this tasks I do not believe you'd even want to do this programmatically, as the process of establishing the tasks, how they're ordered, etc. requires some planning and thought. As far as I'm aware this activity needs to happen in the MS Project Pro full desktop scheduling client, so any automation would require literally having a program open the Pro client, understand some logic to make the connections, then do a publish activity of each schedule. The pure time and cost to automate this (if it's even possible) would greatly outweigh the time it would take to do the linking exercise listed above, plus the ability to check the linkages are done accurately, with the right pred/successor relationships. ordering, etc. is just a task that would be overwhelming to automate.....
FYI we've done alot of automations using this type of 'instantiate MS Project Pro to do xxx and yyy' and it's very complex, and honestly tough to support due to its custom nature. This may just be a case where manual processes work best.
Thanks robhprojility for your response.
In our current setup, we use a custom application to create projects after a comprehensive approval process. Within this application, users define project attributes, and upon approval, a project is created in Project Online. To enhance project management, we now require the ability to define multiple subprojects within a single project in the custom application. Once approved, all subprojects should be automatically created under a corresponding master project in Project Online. Task definitions will follow this step.
To streamline this workflow, we seek an automated process that efficiently generates master projects and their associated subprojects while maintaining a structured and efficient approval mechanism.
I hope after understanding the whole scenario you can better help me for a solution.
Regards
Shruti Vyas
