MS Project Professional - Update Custom Field From Rest API

[BukhtiarAhmadIBM]

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

[#2]

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/updateprojectcustomfieldvalue... 

Here are the docs on the REST API: https://docs.microsoft.com/en-us/previous-versions/office/project-javascript-api/jj669214(v=office.1... 

Paul

[#3]

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

[#4]

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-p... 

Paul

[#5]

Thanks 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

[#6]

Hello @BukhtiarAhmadIBM ,

There is no REST API for MS Project - only Project Server / Project Online. Working programmatically with mpp files requires you to use MS Project. You can automate this using the Project Object model via a VSTO add-in or even a simple VBA Macro.

Paul

[#7]

Hi

I was not successful find a macro which make a rest api call and manipulate the response json, is someone can find a sample macro code ?

[#8]

Hello @BukhtiarAhmadIBM ,

Here are a few examples for Excel VBA: 

https://www.appsloveworld.com/solved-how-to-call-rest-api-from-excel-macros-vba-and-parse-json/ 

https://stackoverflow.com/questions/38246789/how-do-we-use-restful-apis-from-excel-macros-vba 

These might help you get something working from MS Project.

Paul

[#9]

I am getting error on below line is there an option to connect on webcall and discuss?

Set Jsonresult = JsonConverter.ParseJson(result)

Regards

Bukhtiar 

[#10]

Hello @BukhtiarAhmadIBM ,

Unfortunately there is no option to web call and discuss from this forum. I would recommend posting the specific error on a developer focused forum such as stackoverflow. 

Paul