JSON Parse Code - Web API in Microsoft Access


	Back to Web API Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

JSON Parse Code

Michael Johnson

3 years ago

Between work being busy, and I'm just learning GitHub, I finally got the code uploaded that I used to parse JSON.

https://github.com/setecastronomy-dotcom/jsonParseVBA/tree/main

There's the class module that was made to parse the JSON, and the code for how I used it to extract the information (in this case from a site called When to Work) into a table via a recordset with a lot of information in the collection.

I also have a README file that has the code credits and the video I watched.

	Alex Hedley @Reply 3 years ago
Nice work

Michael Johnson OP @Reply

3 years ago

Thanks Alex!

Richard, some of the things in this code that I found interesting and I'd be interested in learning more about are:
-The "Call" command
-Class Modules, particularly how it was used here
-Collections. I found it really cool the way this code parsed the JSON, dumped it into a collection, and had a great way to pull the data out. Kind of like an array on steroids. :)

I'm sure it adds to an already long list of topics you want to cover, but I wanted to toss these in there. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Web API.

Next Unseen

New Feature: Comment Live View