<%dim crumb crumb2="SQL API Function Example" crumb1="Yahoo Finance API Query" crumb="Query Function Tutorial" %> Access API Query Example
Home   Fees/Services   Access Templates   Tutorials   Tutorial Downloads   Articles   Search   Contact  Privacy  Links
<% response.write crumb2 %>
<% response.write crumb1 %>
Home > Tutorials > Query Tutorials > <% response.write crumb %>

Query Tutorials Index:
Too Complex Query
Aggregate Query
Not In Operator
Choose Function
Crosstab Query
Date Time Query
SQL Delete Query
External Table Query
Report Filter Query
Group By Query
Having Query Clause
Histogram Query
Access Append Query
Master Detail Update
Order By Query
SQL Parameter Query
Predicate Query
Self Join Query
Scalar SubQuery
Master Detail Query
Select Query
Access SQL Select Top
SQL Union Query
SQL Update Query
Custom Query Function


MultiSelect Parameter Forms Access Tutorial

API Function Query Example

Access API Tutorial

Need to use an API to get data from a website into an Access database?  This is a fairly common requirement and we show a great example on this page.  Here we are going to retrieve the current price of stocks trading out there in the stock market.  We will use Yahoo Finance's API for this. In the example below we first create a Public Function containing the API code.  The we call that function while using a Select Query to retrieve our stock symbols from our table.

Once see how to dynamically retrieve the current stock prices you can show them in a form or change to an Update Query to save the in a table along with the current date.  If you wanted to you could create an Access database that would wake up once a day on update your database of stock quotes.  This way you can plot them over time.

Here is the table we are using for this SQL API function example:


Next is the function we have created:

get data from website via Access query

And the Access query contains this query code:

vb function in access query

And when we run the query we get:

access api query example

Contact us here at Blue Claw Database Design if you feel we could help you get your job done quickly.  We promise to only charge when we delivery a product or component and we will always tell you how much programming will cost up front.  We have programmed more than 500 databases all over the USA and all over the world.  Contact us today!

You can also read more about Yahoo Finance's stock quote api.  There is a lot more information about each stock that can be pulled using the API.

Microsoft Office:
MS Access 2000 Through Access 2016 & Office 365

Contact Information
<% Response.write "Copyright 2000-" & year(now) & " Blue Claw Database Design" %>
Development in Microsoft Access, Microsoft SQL/Server and Azure

See our SQL/Server Development and Access Migration Tutorials