jeroenkuster

api in an access database

Recommended Posts

Assuming you have gotten a KEY for the API (if not follow the directions here:https://rebrickable.com/api/)

then you can construct a URL in Access (using vb) similar to this

https://rebrickable.com/api/v3/lego/colors/?key=<*Your Key*>

where the <*Your Key*> = the key you had generated.

After which it will return a JSON object that you will need to parse out into a vb object, which then you should be able to import into your data base.

Here is a thread which should get you started: https://stackoverflow.com/questions/32768235/creating-a-microsoft-access-database-connection-to-a-rest-based-api

 

It will take a bit of work, but is well worth it.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now