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 R...  

Title: How to Work With the Command Bar Object in VBA
Link:    • How to Work With the Command Bar Obje...  

Title: How to Work With the Command Bar Control Object in VBA
Link:    • How to Work With the Command Bar Cont...  

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 Exce...  

Title: How to Use the Shell Automation Library in VBA | Part 1
Link:    • How to Use the Shell Automation Libra...  

Title: How To Control The Visual Basic Editor With VBA
Link:    • How To Control The Visual Basic Edito...  

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...  

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 Cer...  


**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