topic REST API for MS Project (no public connector available) in Workato Pros Discussion Board

REST API for MS Project (no public connector available)

james-ng — Thu, 28 Apr 2022 11:49:39 GMT

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!

Re: REST API for MS Project (no public connector available)

neils — Thu, 28 Apr 2022 12:37:53 GMT

Looks like there is some sort of API - does this help? https://github.com/officedev/project-rest-basic-operations/tree/master/

Re: REST API for MS Project (no public connector available)

mylescarrick — Thu, 28 Apr 2022 13:06:29 GMT

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-tasks-using.html

Re: REST API for MS Project (no public connector available)

james-ng — Wed, 04 May 2022 16:53:07 GMT

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.