Discussions

Expand all | Collapse all

Best Method for Live Exchange Rates

  • 1.  Best Method for Live Exchange Rates

    Posted 09-21-2020 12:08
    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
    ------------------------------


  • 2.  RE: Best Method for Live Exchange Rates

    Posted 09-22-2020 16:07
    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
    ------------------------------



  • 3.  RE: Best Method for Live Exchange Rates

    Posted 24 days 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
    ------------------------------



  • 4.  RE: Best Method for Live Exchange Rates

    Posted 23 days 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
    ------------------------------