Automatic website import to QB field
We are trying to create a field/fields that will pull rates from www.snaprates.com into Quickbase that can be automatically update. Any help on this would be great. Thank you.
Forum Discussion
There are a lot of reasons you can't do this:
(1) snaprates.com does not support https so you would get "mixed content" error.
(2) snaprates.com does not support cross domain requests.
(3) snaprates.com may or may not allow you to scrape their data
But this is QuickBase and nothing is impossible!
It has been years since I have done this but you can still use my old pal YQL (Yahoo Query Language) to fetch the data through their servers and return it to QuickBase (thus circumventing the same origin policy your browser enforces).
Here is proof:
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=678
To repeat this result just copy the code in the above pastie and paste it into the console.
The key thing to note is that despite QuickBase and SnapRates being hosted on separate domains QuickBase can in fact access the SnapRates data by going through the YQL service. Note the dialog displaying the SnapRates data is being displayed within QuickBase.
You didn't say what data you wanted to extract so I just grabbed all the table data. It is trivial to extract specific data from the table data.
(1) snaprates.com does not support https so you would get "mixed content" error.
(2) snaprates.com does not support cross domain requests.
(3) snaprates.com may or may not allow you to scrape their data
But this is QuickBase and nothing is impossible!
It has been years since I have done this but you can still use my old pal YQL (Yahoo Query Language) to fetch the data through their servers and return it to QuickBase (thus circumventing the same origin policy your browser enforces).
Here is proof:
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=678
To repeat this result just copy the code in the above pastie and paste it into the console.
The key thing to note is that despite QuickBase and SnapRates being hosted on separate domains QuickBase can in fact access the SnapRates data by going through the YQL service. Note the dialog displaying the SnapRates data is being displayed within QuickBase.
You didn't say what data you wanted to extract so I just grabbed all the table data. It is trivial to extract specific data from the table data.