Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Retrieve URL JSON data in MS Access

Tags:

json

ms-access

There is a web service that allows me to go to a URL, with my API-key, and request a page of data. The data is returned as JSON. The JSON is well-formed, I ran it through JSONLint and confirmed its OK.

What I would like to do is retrieve the JSON data from within MS Access (2003 or 2007), if possible, and build a table from that data (first time thru), then append/update the table on subsequent calls to that URL. I would settle for "pre-step" where I retrieve this information via another means. Since I have an API key in the URL, I do not want to do this server-side. I would like to keep it all within Access, run it on my PC at home (its for personal use anyway).

If I have to use another step before the database load then Javascript? But I dont know that very well. I dont even really know what JSON is other than what I have read in Wikipedia. The URL looks similar to:

http://www.SomeWebService.com/MyAPIKey?p=1&s=50

where: p = page number s = records per page

like image 610
ONDEV Avatar asked Dec 16 '10 19:12

ONDEV

People also ask

Can MS Access read JSON file?

This Connector is optimized to work with very large files. Using JSON API Connector you will be able to connect, read and write data from within MS Access.

Can you use an API in Access?

Access doesn't provide any functionality to directly access the data from a HTTP endpoint (REST API). It can only function as a database(backend) in this scenario and you would need to look into other solutions to get the data from the database and provide it from a HTTP endpoint (REST API).

How do I import source data into Access?

Browse to the source database, select it, and then click Open. Select Import tables, queries, forms, reports, macros, and modules into the current database and click OK to open the Import Objects dialog box. In the Import Objects dialog box, click each tab and select the objects you want.

Can Access export JSON?

Choose Access and logon. Click “Export From Table” at task dialog. then show the Export Single Table form.

1 Answers

Access DB is a JavaScript Lib for MS Access, quick page search says they play nicely with JSON, and you can input/output with. boo-ya.

http://www.accessdb.org/

EDIT:
dead url; wayback machine ftw:
http://web.archive.org/web/20131007143335/http://www.accessdb.org/

also sourceforge
http://sourceforge.net/projects/accessdb/

like image 197
albert Avatar answered Oct 05 '22 02:10

albert
Sign in to Comment

Related questions

Read empty YAML file
Optimize JavaScript DrillDown code
ASP .Net MVC 5 JsonResult caching
Simple template library with binding capability for Java
How to use two ng-repeat inside a particular tag
JSON decode on empty string behaves differently with PHP 7
JSON Get parent object from child object
SQL XML or JSON to return to Objective-C via ASP.NET
Validate JSON from Mongo?
Creating multiple metafields with different key showing Error
What is a JSON-safe object?
Dynamically load cascading Questions in Android View
JSONPath query on MongoDB?
Is there such a thing as JSON schema for MongoDB query language itself?
Viima JQuery Comments - GetUsers(Pinged users) displaying incorrectly in partialview
How to parser JSON and add some custom strings?
Why is .NET OData Serializer so slow
Serialize Json object with "multi-type" property
Initialize an object of type T from Dictionary<string,object>
In Ruby, MongoDB returns a BSON::OrderedHash. How to I convert it to JSON? Using to_json gives a "stack level too deep" error [closed]

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!