The other day I had a client inquire about snagging some data from a 3rd party web service and feeding it into QuickBase. I came up with a simple demo that allows you to (1) enter an ISBN-13 number, (2) blur the field and (3) script injected into the page using the image onload technique will fill in the QuickBase fields it finds from an external web service. The script uses YQL (Yahoo Query Language) to act as a proxy so that the data can cross domains without violating the same origin policy:
My Old Pal YQL ~ Best Friends Forever
https://haversineconsulting.quickbase.com/db/bi5trc6a8?a=nwr
Type in an ISBN-13 number and wait while the Details are fetched from this web service:
http://www.isbnsearch.org/
Tested ISBN-13 Numbers:
9781849519083
9781783559688
9781849697545
Pastie Databasehttps://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=307
Notes:(1) I only implemented the logic on the add record form and I don't perform any extra error handling or feedback if something goes wrong.(2) The script uses the jQuery plugin
YQL found here:
https://github.com/hail2u/jquery.query-yql (3)Those three ISBN-13 numbers are all
HighChart books. Collect them all!