Forum Discussion

Copper Contributor

Mar 28, 2022

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? R...

Copper Contributor

Mar 28, 2022

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_Mather

MVP

Mar 28, 2022

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

BukhtiarAhmadIBM
Copper Contributor
Mar 28, 2022
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
- Paul_Mather
  MVP
  Mar 28, 2022
  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
  - BukhtiarAhmadIBM
    Copper Contributor
    Apr 03, 2022
    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 ?