UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Accessing External Data - Soda, Access 2016    
 
   
Scot
post Feb 13 2018, 09:48 AM
Post#1



Posts: 816
Joined: 24-November 08
From: Silver Spring Maryland, USA


Its one thing to be in over your head ... its quite another to be alone and in over your head.

I've a small access database to compile and analyze service tickets generated in my county department. Good analysis depends on content and context and so I want to be sure I have the latest information about the facilities where the service tickets are generated. I could hard code this, but its a big county and lots of departments have their fingers into changes in the facilities that don't necessarily get communicated around the entire chain of command.

The department does export certain data onto a Socrata open data network. I'm curious how I can access this information dynamically. Okay, here's what I know: the external dataset is https://data.montgomerycountymd.gov/resource/jrcf-tvyy.json How do I call that in a query to filter the results that I want?

TIA
Scot


PS: Moderators move as you please if there is a better subforum. I couldn't decide.

--------------------
- Scot
Go to the top of the page
 
DanielPineault
post Feb 13 2018, 10:21 AM
Post#2


UtterAccess VIP
Posts: 5,662
Joined: 30-June 11



You may like to read over Jack's article at https://dymeng.com/parsing-json-with-VBA/

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
Scot
post Feb 13 2018, 12:11 PM
Post#3



Posts: 816
Joined: 24-November 08
From: Silver Spring Maryland, USA


Good article. Thanks. I’ll give this a shot.

--------------------
- Scot
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    22nd February 2018 - 11:24 PM