UPDATE: Here’s the post on how to use VBA with JSON using
CourtListener as an example, or you may view the Wunderlist how-to here.
So before I talk about recordsets, I want to say I’ve spent some time recently learning how to parse/process JSON from CourtListener in VBA, which enables a person to obtain search results on tons of cases. So in a couple of blog posts, we’ll be discussing using VBA to parse/process JSON strings and you will learn how you may do that yourself. How exciting is that??? Can you imagine being able to automatically hyperlink your briefs and/or transcripts for free?
Potentially, you could mark the citations in your transcripts, briefs, or Word documents in a certain way, write a function to find those marks in the transcripts, have the function put the strings into variables, search CourtListener for the variables’ values, and hyperlink the transcript entry automatically or with a prompt.
There are also other organizations/entities that offer JSON parsing for authority and we may go over those as well. This would be an invaluable thing to know if PACER were ever to become available online at no cost (there is current litigation over this) because you could link exhibits, rulings, briefs, everything in the actual court record, just because you can, for no cost past the static up-front cost of paying someone to write the automation code.
So in a couple weeks, that’s exactly what we’ll do, but for now, back to DAO recordsets.
UPDATE: Here’s the post for Courtlistener, or you may view the Wunderlist how-to here.