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


  • 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.

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?

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.