Best Method for Live Exchange Rates

Question

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 or how to start.

------------------------------
Niraj Shah
------------------------------

blakeharrison · Answer

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.ioQuick Base Solution Provider------------------------------

nirajshah4 · Answer

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 · Answer

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.ioQuick Base Solution Provider------------------------------

Forum Discussion

Best Method for Live Exchange Rates

Related Content

Rate Increase

Exchange Templates Removed?

Dropdown list with Ratings?

Billing Rate Cards

Set seasonal rates automatically