OANDA - Get exchange rate

Use the OANDA - Get exchange rate action A tool for building the processes, logic, and direction within workflows. to retrieve the exchange rate between two currencies.

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

Before you begin: 

Jump to:

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 Credentials and other settings required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

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