Forum Discussion
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...
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
Thanks again
Bukhtiar
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
- 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 ?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
I am getting error on below line is there an option to connect on webcall and discuss?
Set Jsonresult = JsonConverter.ParseJson(result)
Regards
Bukhtiar
