Making API Requests in VBA | JSON

In our previous video, we saw how to request data from an API using VBA, this video was intended for APIs that offered XML versions of their API. However, not all APIs will provide their data in this format, so we need to explore other options as well. This video focuses on APIs as well but will cover JSON formatted data and how to parse it. Video Resources: -------------------------------------------------- Resource: GitHub File Link: https://github.com/areed1192/sigma_coding_youtube/tree/master/vba/vba-advanced/xml-library/Requesting%20APIs%20-%20JSON.bas Resource: Resource JSON Parser Link: https://github.com/VBA-tools/VBA-JSON Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub Sigma Coding: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: How To Programmatically Add Library References Using VBA Link: https://youtu.be/ri8Kzwu6aqU Title: How to Work With the Command Bar Object in VBA Link: https://youtu.be/nMZvFzVIW-c Title: How to Work With the Command Bar Control Object in VBA Link: https://youtu.be/LsCoII_VZMk Title: How to Export Macros Using VBA Link: https://youtu.be/6VoiGoCASrU Title: How To Run A Python Script Using Excel VBA Link: https://youtu.be/rlHcrAb2_fs Title: How to Use the Shell Automation Library in VBA | Part 1 Link: https://youtu.be/Hqt1rs1bth8 Title: How To Control The Visual Basic Editor With VBA Link: https://youtu.be/tv4Ext49i24 Title: Web Scraping With VBA | Part One Link: https://youtu.be/inXUOu5bwAE Title: Web Scraping With VBA | Part Three Link: https://youtu.be/jDd1u1Q0xMs Title: Web Scraping With VBA | Part Two Link: https://youtu.be/7_9gRf4lC0g Title: Web Scraping With VBA | Scraping Data Tables Link: https://youtu.be/Z7XwlH6Mes4 Title: Making API Requests in VBA | JSON Link: https://youtu.be/BRB2SlsBEUI Title: Making API Requests in VBA | XML Link: https://youtu.be/2SwWRg8-BvE Title: How To Pull Data From Access Using VBA Link: https://youtu.be/5kIUPFWsNYw Title: Importing Text Files In VBA Link: https://youtu.be/o8jcNHxLDSw Title: How to Use the File System Object in VBA Link: https://youtu.be/I05NXLUh0Co Title: How to Build Windows Forms Applications in Python | Pt. 2 Link: https://youtu.be/Qc019p2Ptc4 **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #Excel #VBA #APIs