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

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 ?
  - Paul_Mather
    MVP
    Apr 04, 2022
    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