Forum Discussion
Don777
Sep 30, 2021Copper Contributor
Where I can find standard documents to call REST API in Macro and parsing JSON using VBA
I am planning to call a REST service for both GET & POST. Using JSON files. This I am planning do this in macro. Where I can find standard solution to do this? I don't wanna use any any custom or ...
JKPieterse
Oct 04, 2021Silver Contributor
Have a look at these:
#1: https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/
others:
https://community.powerbi.com/t5/Power-Query/Getting-data-from-API-with-JSON-body/td-p/1030682
https://www.howtoexcel.org/power-query/how-to-access-a-json-api-with-power-query/
#1: https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/
others:
https://community.powerbi.com/t5/Power-Query/Getting-data-from-API-with-JSON-body/td-p/1030682
https://www.howtoexcel.org/power-query/how-to-access-a-json-api-with-power-query/
Don777
Oct 07, 2021Copper Contributor
Thanks I will check this