Skip to main content (Press Enter).
Skip auxiliary navigation (Press Enter).
Quick Base University
Skip main navigation (Press Enter).
on this day
between these dates
Back to discussions
sort by most recent
sort by thread
Get data from website table
OK here is what I am trying to do compared to excel. I have a sheet that pulls rates from various ba...
The answer depends on the site you are pulling the data from and how you access the site. Complicat...
Get data from website table
Posted 02-04-2018 16:52
OK here is what I am trying to do compared to excel. I have a sheet that pulls rates from various banking sites. In excel its very easy to accomplish this. I click on "From Web" on the data tab, enter the website in the URL field, and select the table in the window below. This then copies the table to my sheet. To update the data I simply click "Refresh All" in the data tab and it grabs the data again. Is there an easy way to do this in Quickbase.
RE: Get data from website table
Posted 02-04-2018 18:43
The answer depends on the site you are pulling the data from and how you access the site. Complicating factor include
if you need to be logged into the site.
if navigation or interaction (eg CAPTCHAs) is required to reach the URL where the information resides,
and how the web site allows its information to be accessed (both legally and technically). There probably is a solution but how you do it depends entirely on the particular site you want to access. So the primary question is what URL are you trying to access. The secondary question is how is the data is identified (which table) and formatted on the page (this is the easier issue to address).
You can stop reading here if you are non-technical but the following information might be helpful to a large group of different users. Let me explain.
When you access a site there are
categories of information that can be in the
. Two of the categories everyone is familiar with namely
is the long string of characters you see in the address bar and the
is what is displayed in your browser or download to your computer.
category of information that you don't normally see is call the
describe in great detail the
technical details about how the content can be accessed such as
a bewildering variety of other header information including Easter eggs, jokes, job solicitations and other obscure information. Nope I am not joking - enjoy some fun reading:
Fun and Unusual HTTP Response Headers
Also browsers are not the only program that access a web site.
can access web sites and
like those at Google acting as crawlers or robots can access web sties. When a installed program or a server accesses a web site it can pretty much do anything it wants (subject to security and authentication issues) with the information. But when a
accesses a web site it must respect the the restrictions specified by the
because all the browser manufactures more or less comply with a common body of standards and best practices.
allow you to access the content of one web site from another domain (ie subdomain.quickbase.com)
it has a header named "
" with an appropriate value. Another common restriction is that some sites will not even allow you to put their URL in an
unless it has a header named "
" with an appropriate value. In a variety of ways each site can control if and how you can access their information.
There are all sorts of details, exceptions, workarounds and tricks that can be used but the bottom line is that the answer to your question depends on the web site you wish to get the information from.
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Powered by Higher Logic