OANDA - Get exchange rate

Use the OANDA - Get exchange rate action to retrieve the exchange rate between two currencies.

For more information about the OANDA connector, go to OANDA.

Configure the OANDA - Get exchange rate action

  1. Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

  2. Select a Connection. If you do not have a connection, see Add a connection.

  1. Select the Base currency for the exchange rate.
  2. Select the Quote currency.
  3. (Optional) To get the exchange rate for a specific date in the past, select the Historic rate date.
  4. Create or select a variable for the output.

OANDA - Get exchange rate action fields and settings

Section Field Description Variable types

(unlabeled)

Connection

The OANDA connection used to access the exchange rate API.

To refresh the available connections, click .

(n/a)

 

Base currency

The base currency – also called the transaction currency - is the first currency appearing in a currency pair quotation. The exchange rate uses one unit of the base currency to calculate the rate for the quote currency. Such as 1 USD (base) = 1.25 CAD (quote).

If you use a variable, the value must be in the three digit currency code. See List of currencies for a list of the abbreviations.

If you use an invalid code, you get an Invalid Base error:

"Invalid or malformed argument; [base] must be a valid 3 letter currency code as defined by [currencies] endpoint for [data_set] (OANDA): (INVALID BASE VALUE)"

Text, Decimal, Integer, Boolean, DateTime, Collection

  Quote currency

The quote currency, or the counter currency, is the second currency appearing in a currency pair quotation. Used to determine the value of the base currency. Such as 1 USD (base) = 1.25 CAD (quote).

If you use a variable, the value must be in the three digit currency code. See List of currencies for a list of the abbreviations.

If you use an invalid code, you get an Invalid Quote error:

"Invalid or malformed argument; [quote] must be a valid 3 letter currency code as defined by [currencies] endpoint for [data_set] (OANDA): (INVALID QUOTE VALUE)"

Text, Decimal, Integer, Boolean, DateTime, Collection
  Historic rate date

Only select a date if you need a specific date in the past. The date must be:

  • In ISO 8601 format - YYYY-MM-DDThh:mm:ss±hh:mm

  • Defined in 15 minute intervals. All date time fields must be on 00, 15, 30 or 45 UTC minutes boundaries: (2021-04-08T10:00:00.000Z)"

  • A date in the past.

Text, Integer, DateTime
Output Exchange rate

Stores the result of the action as an object with the following variables:

  • Meta: (Object) Returns data about the exchange rate request.

    • Effective parameters: (Object) Contains information on how the API interpreted the parameters in the request.

      • Data set: (Text) The endpoint used in the conversion.

      • Base currencies: (Collection) The base currency used in the action. See List of currencies for a list of the abbreviations.

      • Quote currencies: (Collection) The quote currency used in the action. See List of currencies for a list of the abbreviations.

    • Request time: (Text) The time-stamp that the server processed the request.

  • Quote: (Collection) Returns the exchange rate quote data.

    • Base currency: (Text) The base currency used in the action. See List of currencies for a list of the abbreviations.

    • Quote currency: (Text) The quote currency used in the action. See List of currencies for a list of the abbreviations.

    • Bid: (Decimal) The highest rate that someone is willing to buy the currency at.

    • Ask: (Decimal) The lowest rate that someone in the market is willing to sell at.

    • Midpoint: (Decimal) The average of the bid and ask rates. This is not a rate that you can deal at, but is often used in quotes.

Object