Making API Requests in VBA | XML

[@herbertvantonder5188]

In 2023 still fantastic video, first video explaining XML tree to excel process - thanks so much

[@ajaz4sky]

The Only Practical Video I have found on API requests and Response handling in VBA Excel....Thanks A Lot

[@SigmaCoding]

I'm glad you found it useful!

[@thameranjaay6310]

Thank you so much for making this. Extremely helpful

[@mariusbotezatu6365]

Congrats, please make a video for POST request.

[@davidgolfer63]

Very informative video Sir! Is there any chance to cover the Get/Post request for login in a server by XML or HttpReq in VBA as on KZbin this content is not that common or very well explained. Thank you and good job.

[@negociosonline40]

I need to load the query along with loop, but the loop won't let the query be loaded, could you help me?

[@ansimolthulasidharan7920]

can u help me in creating xml api with my excel VBA. everything i followed but it throws error

[@asis7500]

What font it is?

[@ReshaDespa]

where i can find my own api key? or i have create it by something?

[@SigmaCoding]

API Keys have to be created by yourself, so in this case since we are using google places API you would need to get one from there.

[@marianalexandru8486]

Hi ! Thank you for the video. I have tried to load a longer query but I see VBA imported only partially the XML. I would highly apreciate an advice on this issue. thank you !

[@jobethflores9565]

Great video. Please help me about how to connect my vba to web service of SSS. I cannot access the web service even thou I have the tokenID given by the admin.

[@yusufgillani532]

I want to learn to automate a lot of my tasks at work. What do you recommend? Python or VBA. Can I do more things using Python? What about Javascript?

[@danielfrancisco1461]

great video! where did you learn all that stuff about vba, xml and python? is there any book you would recommend?

[@SigmaCoding]

A lot of it is research and expanding on different concepts I already had under my belt. However, I do have a few books on my website that I recommend. Here is the link to the page: sigma-coding.com/book-recommendations/ For the most part if you're trying to do Python and VBA in the same task then there is only one book that covers that topic. With VBA, I was always surprised how hard it was to find books that went beyond the Excel Object model. There are maybe 2 books I can think of off the top of my head that go beyond Excel VBA and even when they do it's very limited.

[@dildokafir5058]

@@SigmaCoding link doesn't work

[@djkujo007]

Thank you!

[@larsbrockmann8563]

Great Video. Thank you.

[@ringvision7075]

I should be able to put my API key in the User variable section of Environment Variables and then use VBA.Environ("name-of-API-key") and it should return the value correct? I tried doing this but it comes back as an empty string. My variable name matches Google-Places-API-Key but like I said it returns an empty sting. I also tried adding $. VBA.ENVIRON$("Google-Places-API-Key"). Maybe this is not an option?

[@jayshreebansode6877]

I am getting one error in my Excel macro and the error is: 'XML document must have a top level element". Any one know why am getting this error please help

[@SigmaCoding]

Are you using it with the Google API?

[@CyrusPieris]

Amazing. Thank you.

[@codingwithjoyk]

Great video! Looking forward to connecting to the Adobe applications. Also, that IE workaround you mentioned in the recent webscraping from vba videos? I'd like to see that - don't even have IE on my computer! Thank you! Keep 'em coming!

[@SigmaCoding]

Yeah I'm still working on the IE workaround, it might require the download of a 3rd party software so I'm trying to see if there are any alternatives before doing that.

[@codingwithjoyk]

@@SigmaCoding Thank you!

[@jeffhickey7432]

Thank you! Subbed!

[@attilavarkonyi7066]

Thank you thank you thank you!

[@negociosonline40]

Ativa legenda para português, vai ajudar os brasileiros.