Forum Discussion

NirajShah4's avatar
NirajShah4
Qrew Cadet
5 years ago

Best Method for Live Exchange Rates

Can anyone tell me an efficient way to pull in live (or near live) exchange rates into my QuickBase application? I'd like to have a maximum of 10 currencies against the US Dollar but not sure of where...
App builders
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
Niraj -

I used https://fixer.io/ as the provider for my Exchange rates. They have a free tier that allows up to 1k calls per month and as often as hourly calls. To integrate it with my Quick Base, I used Workato, but you could use Pipelines or Zapier to do it also.

------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------
  • NirajShah4's avatar
    NirajShah4
    Qrew Cadet
    5 years ago
    Thanks, Blake! I wasn't aware of Fixer but it looks to be just what I need to get a daily view of exchange rates. 

    I'm not an API maven and haven't used Pipelines extensively; are you able to tell me how you were able to set it up?

    I appreciate it!

    ------------------------------
    Niraj Shah
    ------------------------------
    • BlakeHarrison's avatar
      BlakeHarrison
      Qrew Captain
      5 years ago
      I actually did not use Pipelines to build this connection, but used Workato (Pipelines wasn't available when I set this up). For me, I just needed the EUR/USD conversion each day and this is the call I sent:

      And this is the response schema that I setup:

      [ { "control_type": "text", "label": "Success", "render_input": {}, "parse_output": {}, "toggle_hint": "Select from option list", "toggle_field": { "label": "Success", "control_type": "text", "toggle_hint": "Use custom value", "type": "boolean", "name": "success" }, "type": "boolean", "name": "success" }, { "control_type": "number", "label": "Timestamp", "parse_output": "float_conversion", "type": "number", "name": "timestamp" }, { "control_type": "text", "label": "Base", "type": "string", "name": "base" }, { "control_type": "text", "label": "Date", "type": "string", "name": "date" }, { "properties": [ { "control_type": "number", "label": "USD", "parse_output": "float_conversion", "type": "number", "name": "USD" } ], "label": "Rates", "type": "object", "name": "rates" } ]​


      ------------------------------
      Blake Harrison - DataBlender.io
      Quick Base Solution Provider
      ------------------------------