Solved

Socrata SOAP Open Data - API or SDK for use with VBA

Posted on 2016-09-27
2
26 Views
Last Modified: 2016-11-09
I have to interface with a government site from an Access application and there are no API's for VBA. I'm wondering if anyone else has used these tools?

Here is a link to what I'm talking about...

My being able to do this will be a deciding factor in my getting this project.

Any help would be greatly appreciated.
0
Comment
Question by:Ei0914
2 Comments
 
LVL 17

Accepted Solution

by:
Barry Cunney earned 500 total points
ID: 41820000
Hi
You can do something similar to the following sample in VBA code:

Dim reqOpenData as New XMLHTTP

reqOpenData.Open "GET", "https://data.kingcounty.gov/resource/murn-chih.json?record_type=FOUND"

reqOpenData.Send

Open in new window

0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Shoutout to Emily Plummer (http://www.experts-exchange.com/members/eplummer26.html) for giving me this article! She did most of it, I just finished it up and posted it for her :)    Introduction In a previous article (http://www.experts-exchang…
JavaScript has plenty of pieces of code people often just copy/paste from somewhere but never quite fully understand. Self-Executing functions are just one good example that I'll try to demystify here.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The viewer will learn how to count occurrences of each item in an array.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now