Retrieving Real-Time Data Using a Web API in Microsoft Access

In this Microsoft Access tutorial, I'm going to teach you how to use a little VBA code to go out to the web and retrieve data using something called a web API. The example we're going to use today involves going out to an internet time server and getting the exact time, but this technique can be used for tons of different things, including interacting with ChatGPT.

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

RECOMMENDED COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Retrieving Real-Time Data, Web API, Data Retrieval with VBA, Real-Time Data Access, Web API in Access, Microsoft Access Web API Tutorial, Access VBA Web API Example, Web Data Integration, Access Data from Internet, Microsoft Access Time Retrieval, Internet Time Using VBA, Access Web Data with VBA, ChatGPT Integration, Real-Time Data Access with Access, Access VBA Web API Fetch, Web API Data Retrieval in Access, VBA Code for Web Data Retrieval, Access External Data, Microsoft Access Data Integration, Internet Time Retrieval Tutorial, Access Web Data Fetching.

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[skytechbits]

Yes, it's backwards 🤣 You are the best Richard. Straight-forward, non-edited, and entertaining with solid information.

[giorgiorovelli]

At 23:10 you say, "I'll put a link in the description below" but I don't see the link

[fotiosfotinakis]

Richard, this is great! Thanks for sharing, had no idea how to do it!

[Shadow.Dragon]

Very interesting! I've heard about APIs, but haven't programmed any with them. Thanks for the great video Richard!

[mindovermechanics]

Yes please do a seminar on WEB API! My database application is starving for it 😅!

[jerrydfowler]

Rick, as always your lessons are excellent information. I have always felt that you are genuinely concerned for your members. I see that by the way you teach and the way you talk to your members. Please keep up the great work!! and thanks

[Hrubicundus]

Superb Richard, you have excelled yourself this time. Any chance of you doing a video of using it to get stock prices etc?

[xavierbatlle]

Thanks Richard! Perhaps will be interesting a video about retrieving data from websites with different codepages or internacional caracters? ;-)

[Kenitso]

Hi Richard. Uh, just one thing. You are returning the UTC date time not the date time relative to the user's time zone.
I believe you should be parsing "datetime" instead of "utc_datetime" for the general purpose of this function.
If I ask the time in "Asia/Bangkok" from Hawaii I would NOT get the time now in Bangkok but the time relative to UTC.
Just thought I would mention that detail for the benefit of viewers that may extend this functions utility.
Here's the modified code:
S = ResponseText
L = InStr(S, "datetime:")
S = Right(S, Len(S) - L + 1)
S = Left(S, 42)
S = Mid(S, 16, 2) & "/" & Mid(S, 19, 2) & "/" & Mid(S, 11, 4) & " " & Mid(S, 22, 8)
Thanks for ALL of your content!

[vincentchikobe]

Hi sir how do you add the primary key in that statement to get the sum for each member? Dsum("feecollected", table1", "term='term1'") please help. Thank you!

[bigalc]

Great video, the only problem I have is that as I live in England its giving me the time an hour behind, because we have to move the clocks back and forward an hour, is there a way to add an hour to the time and then take it off when needed.

[פוןטק]

Hello Richard, first Thank you very much for the excellent guide, I wanted to ask please if there is a guide with XML or json ?

[patriknemec]

Hello Richard, where can I find the older video about API, you mentioned?

[Stache]

I've got a puzzler semi-tackled
XML with DTD, pulled by API externally, stripped of DTD, then imported.
Since the whole database load is 1.25 million records I have to select smaller chunks, and import one after the other...
Sadly I can specify a date and still get duplicate of old information as they stick on new dates, and it's so much a mess to see what's changed, I flush and refill. It would be nice to not get it with DTD but it's a service on trial and they haven't shown how to avoid DTD

[kiter]

For some reason my ResponseText returns the real time data just fine but the data has curly brackets around the entire string. There must be a there a reason for this? thanks.

[edsonaccess]

I would like to consume information via API directly through MsAccess without using third-party software or ODBC connection, and I would like to know if I can do this using Supabase, Firebase or others, is it possible? I sent a message in Brazilian Portuguese because I didn't realize it was English. hahaha
But tell me if it's possible and if it's better, make an example video, it helps a lot for people who like msaccess but want to integrate with web applications like flutterflow, flutter, etc.
Grateful.

[Marko_Kostic]

Is there an option, that button can be placed on Web Page and by clicking it's done the same process?
Thank You!

[johnclark]

Great stuff Richard! Question: The site I want to use this code for requires an Key. How would I us that in the get statement?

[khaledsaad]

I ask permission from you a lesson to explain the tool of tree note ples