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_co... Resource: Resource JSON Parser Link: https://github.com/VBA-tools/VBA-JSON Resources: -------------------------------------------------- Facebook Page:   / codingsigma   Facebook Group:   / sigmacoding   GitHub Sigma Coding: https://github.com/areed1192/sigma_co... Support Sigma Coding: -------------------------------------------------- Patreon:   / sigmacoding   Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: How To Programmatically Add Library References Using VBA Link:    • How To Programmatically Add Library Refere...   Title: How to Work With the Command Bar Object in VBA Link:    • How to Work With the Command Bar Object in...   Title: How to Work With the Command Bar Control Object in VBA Link:    • How to Work With the Command Bar Control O...   Title: How to Export Macros Using VBA Link:    • How to Export Macros Using VBA   Title: How To Run A Python Script Using Excel VBA Link:    • How To Run A Python Script Using Excel VBA   Title: How to Use the Shell Automation Library in VBA | Part 1 Link:    • How to Use the Shell Automation Library in...   Title: How To Control The Visual Basic Editor With VBA Link:    • How To Control The Visual Basic Editor Wit...   Title: Web Scraping With VBA | Part One Link:    • Web Scraping With VBA | Part One   Title: Web Scraping With VBA | Part Three Link:    • Web Scraping With VBA | Part Three   Title: Web Scraping With VBA | Part Two Link:    • Web Scraping With VBA | Part Two   Title: Web Scraping With VBA | Scraping Data Tables Link:    • Web Scraping With VBA | Scraping Data Tables   Title: Making API Requests in VBA | JSON Link:    • Making API Requests in VBA | JSON   Title: Making API Requests in VBA | XML Link:    • Making API Requests in VBA | XML   Title: How To Pull Data From Access Using VBA Link:    • How To Pull Data From Access Using VBA   Title: Importing Text Files In VBA Link:    • Importing Text Files In VBA   Title: How to Use the File System Object in VBA Link:    • How to Use the File System Object in VBA   Title: How to Build Windows Forms Applications in Python | Pt. 2 Link:    • How to Schedule a Macro to Run at Certain ...   **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