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

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
- BukhtiarAhmadIBM
  Copper Contributor
  Apr 05, 2022
  I am getting error on below line is there an option to connect on webcall and discuss?
  Set Jsonresult = JsonConverter.ParseJson(result)
  
  Regards
  
  Bukhtiar
  - Paul_Mather
    MVP
    Apr 05, 2022
    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

Forum Discussion

MS Project Professional - Update Custom Field From Rest API

Share

Resources