โ04-28-2022 04:49 AM
Hi community, I'm working on Microsoft Project, but I'm unable to find its REST API. Is it available?
Generally, I hope to do 2 things, for example:
GET response: {
"id" : "12345",
"name" : "to do something",
"plannedstart" : "01 Jan 2022",
"plannedend" : "31 Jan 2022",
"actualstart" : "",
"actualend" : ""
}
POST payload: {
"id" : "12345",
"actualstart" : "04 Jan 2022",
"actualend" : "01 Feb 2022"
}
I could build a custom Connector, but does anyone know where to locate the REST API?
Thanks!
โ04-28-2022 05:37 AM
Looks like there is some sort of API - does this help? https://github.com/officedev/project-rest-basic-operations/tree/master/
โ04-28-2022 06:06 AM
It looks like the link above from Neil uses the somewhat legacy OData interface for Project Online
That same approach is referenced from this for Power BI https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-project-online-connect-to-data
From this discussion it looks like Microsoft hasnโt yet ported Project Online to using their common (confusingly named) Graph API (REST)
https://docs.microsoft.com/en-us/answers/questions/401702/is-it-possible-to-fetch-project-online-tas...
โ05-04-2022 09:53 AM
To share my findings:
MS Project REST APIs are limited to integration via "PowerShell" automations only: https://docs.microsoft.com/en-us/samples/officedev/project-rest-basic-operations/project-rest-basic-operations/ (which is similar to Power Automate)
MS Project can make use of "Microsoft Build" APIs to build custom extensions, which could then be added to MS Office apps to integrate with other apps: https://docs.microsoft.com/en-us/office/dev/add-ins/overview/learning-path-beginner
"Graph API endpoints" are not available for MS Project: https://docs.microsoft.com/en-us/answers/questions/401702/is-it-possible-to-fetch-project-online-tasks-using.html
Therefore, I am unable to build a REST API connector SDK for MS Project.