Forum Discussion
MS Project Professional - Update Custom Field From Rest API
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
- BukhtiarAhmadIBMMar 28, 2022Copper Contributor
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
Bukhtiar- Paul_MatherMar 28, 2022MVP
Hello 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
- BukhtiarAhmadIBMMar 28, 2022Copper ContributorThanks a lot for your response can you give some example code to call a REST API and consume the response. I will check the VSTO example link you shared as well.
Thanks again
Bukhtiar