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