Exchange Rate (Independent Publisher) (Preview)

Get real-time currency conversion data provided by ExchangeRate-API.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name Fördős András
Email fordosa90+ipc_exch@gmail.com
Connector Metadata
Publisher Fördős András
Website https://www.exchangerate-api.com/
Privacy policy https://www.exchangerate-api.com/terms
Categories Commerce;Finance

Creating a connection

The connector supports the following authentication types:

Default Parameters for creating connection. All regions Not shareable

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name Type Description Required
API Key securestring ExchangeRate-API Key True

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Get Exchange Rate

Get specific exchange rate between two currencies

Get Exchange Rates

Get all supported exchange rates for selected base currency

Get Historical Conversions

Get historical conversions for a base currency for a given day

Get Historical Rates

Get historical rates for a base currency for a given day

List Currencies

List supported currency codes

Get Exchange Rate

Get specific exchange rate between two currencies

Parameters

Name Key Required Type Description
Base currency
baseCurrency True string

Base currency code for exchange rates, eg 'USD'

Target currency
targetCurrency True string

Target currency code for exchange rates, eg 'EUR'

Returns

Name Path Type Description
Result
result string

Result state of the request.

Documentation
documentation string

Link to the ExchangeRate-API documentation.

Terms of use
terms_of_use string

Link to the ExchangeRate-API terms of use.

Last updated (unix)
time_last_update_unix integer

Timestamp of last update in unix format, eg 1585353700.

Last updated (UTC)
time_last_update_utc string

Timestamp of last update in UTC format, eg 'Sat, 28 Mar 2020 00:00:00 +0000'.

Next update (unix)
time_next_update_unix integer

Timestamp of next update in unix format, eg 1585353700.

Next update (UTC)
time_next_update_utc string

Timestamp of next update in UTC format, eg 'Sat, 28 Mar 2020 00:00:00 +0000'.

Base code
base_code string

Selected base currency code, eg 'USD'.

Target code
target_code string

Selected target currency code, eg 'EUR'.

Conversion rate
conversion_rate float

Current conversion rate between base and target currency.

Get Exchange Rates

Get all supported exchange rates for selected base currency

Parameters

Name Key Required Type Description
Base currency
basecurrency True string

Base currency code for exchange rates, eg 'USD'

Returns

Name Path Type Description
Result
result string

Result state of the request.

Documentation
documentation string

Link to the ExchangeRate-API documentation.

Terms of use
terms_of_use string

Link to the ExchangeRate-API terms of use.

Last updated (unix)
time_last_update_unix integer

Timestamp of last update in unix format, eg 1585353700.

Last updated (UTC)
time_last_update_utc string

Timestamp of last update in UTC format, eg 'Sat, 28 Mar 2020 00:00:00 +0000'.

Next update (unix)
time_next_update_unix integer

Timestamp of next update in unix format, eg 1585353700.

Next update (UTC)
time_next_update_utc string

Timestamp of next update in UTC format, eg 'Sat, 28 Mar 2020 00:00:00 +0000'.

Base code
base_code string

Selected base currency code, eg 'USD'.

Conversion rates
conversion_rates object

Conversion rates for base currency: property name is currency code while value is the respective rate.

Get Historical Conversions

Get historical conversions for a base currency for a given day

Parameters

Name Key Required Type Description
Base currency
baseCurrency True string

Base currency code for exchange rates, eg 'USD'

Year
year True string

Selected year for historical data in YYYY format, eg '2020'

Month
month True string

Selected month for historical data in MM format without leading zero, eg '12'

Day
day True string

Selected day for historical data in DD format without leading zero, eg '31'

Amount
amount True string

A decimal amount you would like converted, eg '100.5'

Returns

Name Path Type Description
Result
result string

Result state of the request.

Documentation
documentation string

Link to the ExchangeRate-API documentation.

Terms of use
terms_of_use string

Link to the ExchangeRate-API terms of use.

Year
year integer

Selected year for historical data.

Month
month integer

Selected month for historical data.

Day
day integer

Selected day for historical data.

Base code
base_code string

Selected base currency code for exchange rate.

Requested amount
requested_amount integer

Requested amount in base currency to be converted.

Conversion rates
conversion_rates object

Conversion rates for base currency: property name is currency code while value is the respective rate.

Get Historical Rates

Get historical rates for a base currency for a given day

Parameters

Name Key Required Type Description
Base currency
baseCurrency True string

Base currency code for exchange rates, eg 'USD'

Year
year True string

Selected year for historical data in YYYY format, eg '2020'

Month
month True string

Selected month for historical data in MM format without leading zero, eg '12'

Day
day True string

Selected day for historical data in DD format without leading zero, eg '31'

Returns

The outputs of this operation are dynamic.
Name Path Type Description
Result
result string

Result state of the request.

Documentation
documentation string

Link to the ExchangeRate-API documentation.

Terms of use
terms_of_use string

Link to the ExchangeRate-API terms of use.

Year
year integer

Selected year for historical data.

Month
month integer

Selected month for historical data.

Day
day integer

Selected day for historical data.

Base code
base_code string

Selected base currency code for exchange rate.

Conversion rates
conversion_rates object

Conversion rates for base currency: property name is currency code while value is the respective rate.

List Currencies

List supported currency codes

Returns

Name Path Type Description
Result
result string

Result state of the request.

Documentation
documentation string

Link to the ExchangeRate-API documentation.

Terms of use
terms_of_use string

Link to the ExchangeRate-API terms of use.

Supported codes
supported_codes array of array

Array of supported currency codes and their names.

items
supported_codes array of string