Can the result of a URL formula (i.e. the price of a wine from a third party) be displayed automatically for that wine, for example within a separate field ?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have a table of "wines" with wine records and one field "price" being a url formula which generates a link for each wine to a third party's API to return a price.

I currently have this set up as a button and have to click and view the info being returned on a new window (namely currency, wine ID and price as per the attached screenshot).

I would like instead to have the info returned by the third party to automatically populate a "price" field in Quickbase for each wine record as opposed to having to click on a button each time and open a new window.

Not sure if this falls within the scope of APIs (on which I must say I am a bit novice). I cant find much info on making outgoing calls to third parties and having the data being returned automatically populate a field. Can this be handled by Quickbase? 

Anyone out there who can guide me with this, would be greatly appreciated! 

Photo of Benjamin

Benjamin

  • 20 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,268 Points 50k badge 2x thumb
This can be done using Workato, which is the generic connector to all External APIs which QuickBase integrates with nicely.

https://www.workato.com/integrations/quickbase

You would probably need the help of a developer to implement this and have the need strong enough to support the monthly cost.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 Points 20k badge 2x thumb
Your 3rd party API needs to return the data as JSONP or implement CORS.

What is JSONP all about?
http://stackoverflow.com/questions/2067472/what-is-jsonp-all-about

Cross-origin resource sharing
https://en.wikipedia.org/wiki/Cross-origin_resource_sharing

If either of these features are supported by your API you can use script to fetch the data from the API and stuff it into a field automatically. Since you didn't identify the API provider there isn't much more to say.