Forum Discussion
MS Project Professional - Update Custom Field From Rest API
Hi
We have desktop MS MPP File which has a custom field called Build Status which we want to update reading a rest api getting status details from an external system.
Is this possible?
Regards
Bukhtiar Ahmad
Hello BukhtiarAhmadIBM ,
Are you using Project Server / Project Online? If so, yes you have an API to update data. Here is an example using PowerShell calling the REST API to update an enterprise project level custom field: https://github.com/officedev/project-rest-basic-operations/blob/master/updateprojectcustomfieldvalues.ps1
Here are the docs on the REST API: https://docs.microsoft.com/en-us/previous-versions/office/project-javascript-api/jj669214(v=office.15)#projectserver-resources-in-the-rest-interface
Paul
Hi
Thanks for your response I am not using either of them I am using project professional edition installed on my PC
We have to update status custom column in MPP manually from another application one by one for 100 plus records so I was thinking we develop one simple API call and update this custom column automatically in MPP. If this is possible
Regards
BukhtiarHello BukhtiarAhmadIBM ,
In that case you will need to the user the Project object model to programmatically work with MPP files. You could write a VSTO add-in for MS Project and automate this - a user would launch MS Project then start your app from a custom button on the ribbon etc. Example VSTO add-in for Project: https://docs.microsoft.com/en-us/visualstudio/vsto/walkthrough-creating-your-first-vsto-add-in-for-project?view=vs-2022
Paul
