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