Forum Discussion
BukhtiarAhmadIBM
Mar 28, 2022Copper Contributor
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...
Paul_Mather
Apr 04, 2022MVP
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
Apr 05, 2022Copper Contributor
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_MatherApr 05, 2022MVP
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