How To Call REST API From Excel VBA And Parse JSON

**To appreciate my subscribers who turned on 🔔, FREE download will be applicable only to the first 50 viewers/downloads after that $0.99.Please subscribe and turn on 🔔 to get my future products for FREE.

👉 How Do I make an API call from Excel VBA?
👉 Are you wondering, is it possible to make REST API Calls from Excel Macro?
✔️ Yes, we can call REST API from Excel VBA with the help of an XML HTTP request.

In this video, you'll learn

✔️ How to make a REST API call(GET Request) using Excel VBA?
✔️ How to parse or convert the REST API response with a third party JSON converter?

You can also make Excel VBA HTTP post requests, HTTP request authentication as well.

Please do let me know if you have any questions

********** Tutorial Playlists **********

****** Contact me ********

******* Books written by me ********

******* Productivity tool *********

******* Gear Used To Shoot This Video ******
_Audio & Microphone

********Learning partner********

[Amarindaz]

Download Excel Macro 👉 https: //gum.co/rest-api-excel-vba (Use code RESTAPI and get it for FREE**)

**To appreciate my subscribers who turned on 🔔, FREE downloads will be applicable only to the first 50 viewers/downloads after that $0.99.Please subscribe and turn on 🔔 to get my future products for FREE.

[mikem]

Nice job sticking to the very minimum steps needed. Keep up the good work.

[raidenc]

I love your tutorial, it's very helpful to me.

[jimgripp]

Great video to explain REST API call, response handling and JSON parsing. I was able to understand and apply the principles to my VBA code.

[adamr]

Excellent! Thank you. I’d like to try for a personal project!

[caulacau]

Great video!
A quick question if I can: Is it possible to parse the contents of the return to a two dimensional array - columns and rows?
Thanks
Caula

[enableDeepak]

Nice tutorial. How to write the parsed JSON properties to the an existing Excel with known columns-json properties mapping ?

[negociosonline]

FAZ UM TUTORIAL PARA ACESSAR A API DA BINANCE PARA ABRIR OPERAÇÕES PELO EXCEL

[tarunprakashsingh]

how to parse complex nested JSON in vba without knowing nodes and items. is there a way to parse key/value pairs?

[negociosonline]

FAZ UM TOTURIAL PARA ACESSAR A API DA BINANCE PARA ABRIR OPERAÇÕES PELO EXCEL

[musttry]

Sir do you have any idea about the google drive api? How to use it to perhaps add files in the drive using vba code?

[MakeItHappenWithExcel]

Sir can I ask somthing. Can vba connect to google sheet API using this method? Thank you.

[kcerny]

Great! I'd like to know how to capture a respose via XML object.

[yumefke]

Great, I have an issue when dealing with special UTF-8 characters. Is there any way to handle characters like Chinese, Vietnamese, and Japanese?

[MaximumSilly]

I imported your JsonConverter module but when I compile it states - "Invalid use of New Keyword" this is in the Function = json_ParseObject - The line the error is happening is = Set json_ParseObject = New Dictionary - please advise

[mattnampel]

Hi, this is a great video. Do you have an example where you have to pass an API key along as well?

[cryptostar]

Hello, it seems the code you typed RESTAPI has expired

[charanchitu]

Need to collect jira issues/Bugs with VBA and paste in a excel sheet? can we do it?

[makaniharesh]

Sir will u help me to autofill I'd and password in gst login portal using vba excel...
I m accountant
Will u plz

[soylalbayiniz]

Set json =
Debug.Print json("viewCount") I am getting error in this section