Retrieve BA Exchange Rates by Code
  • 13 Jun 2025
  • 2 Minutes to read
  • Dark
    Light

Retrieve BA Exchange Rates by Code

  • Dark
    Light

Article summary

Get
/sys-rest-api/rest/1/exchangerate

Query Standards

Finder

Following row finders are available for data filtering and optimizing request performance.

  • Select Rates
  • By UUID

Select Rates

Recommended finder parameters. Refer to Query Parameters for example.

ParameterDescriptionSample
exchRateDateDate2016-12-20

By UUID

This is an optional finder for querying a specific Exchange Rate by row ID.

ParameterDescriptionSample
/VUUIDThe VUuid attribute is the Unique row ID/sys-rest-api/rest/1/exchangerate/A7B57B43F9D1B4E0E053B08610ACBDE7
Security
HTTP
Type basic

Basic authentication

Query parameters
finder
string
ExampleselectRate;exchRateDate=2015-01-01
limit
integer
Example500
offset
integer
Example0
totalResults
boolean
Exampletrue
orderBy
string
ExampleBaexratFcurrCode:desc
Responses
200

OK

Headers
Content-Type
string
Exampleapplication/vnd.oracle.adf.resourcecollection+json
{
  "items": [
    {
      "BaexratBankCode": "BOA",
      "BaexratFcurrCode": "CAD",
      "BaexratTcurrCode": "USD",
      "BaexratExchgTypeCode": "STD",
      "BaexratDate": "2015-01-01",
      "BaexratRate1": 0.8604,
      "BaexratRate2": 0.9543,
      "BaexratRate3": 0.8647,
      "BaexratAutoFlag": "0",
      "BaexratVUuid": "A7B57B43F9CFB4E0E053B08610ACBDE7",
      "BaexratIuCreateDate": "2015-05-21T20:47:55Z",
      "BaexratIuCreateUser": "BILL",
      "BaexratIuUpdateDate": null,
      "BaexratIuUpdateUser": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/exchangerate/A7B57B43F9CFB4E0E053B08610ACBDE7",
          "name": "exchangerate",
          "kind": "item",
          "properties": {
            "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001740020413742353742343346394346423445304530353342303836313041434244453778"
          }
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/exchangerate/A7B57B43F9CFB4E0E053B08610ACBDE7",
          "name": "exchangerate",
          "kind": "item"
        }
      ]
    },
    {
      "BaexratBankCode": "BOA",
      "BaexratFcurrCode": "USD",
      "BaexratTcurrCode": "CAD",
      "BaexratExchgTypeCode": "STD",
      "BaexratDate": "2015-01-01",
      "BaexratRate1": 1.2021,
      "BaexratRate2": 1.1975,
      "BaexratRate3": 1.2154,
      "BaexratAutoFlag": "0",
      "BaexratVUuid": "A7B57B43F9CEB4E0E053B08610ACBDE7",
      "BaexratIuCreateDate": "2015-05-21T20:46:00Z",
      "BaexratIuCreateUser": "BILL",
      "BaexratIuUpdateDate": null,
      "BaexratIuUpdateUser": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/exchangerate/A7B57B43F9CEB4E0E053B08610ACBDE7",
          "name": "exchangerate",
          "kind": "item",
          "properties": {
            "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001740020413742353742343346394345423445304530353342303836313041434244453778"
          }
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/exchangerate/A7B57B43F9CEB4E0E053B08610ACBDE7",
          "name": "exchangerate",
          "kind": "item"
        }
      ]
    },
    {
      "BaexratBankCode": "CIBC",
      "BaexratFcurrCode": "CAD",
      "BaexratTcurrCode": "USD",
      "BaexratExchgTypeCode": "STD",
      "BaexratDate": "2015-01-01",
      "BaexratRate1": 0.8604,
      "BaexratRate2": 0.9543,
      "BaexratRate3": 0.8647,
      "BaexratAutoFlag": "0",
      "BaexratVUuid": "A7B57B43F9D0B4E0E053B08610ACBDE7",
      "BaexratIuCreateDate": "2015-05-21T20:49:03Z",
      "BaexratIuCreateUser": "BILL",
      "BaexratIuUpdateDate": null,
      "BaexratIuUpdateUser": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/exchangerate/A7B57B43F9D0B4E0E053B08610ACBDE7",
          "name": "exchangerate",
          "kind": "item",
          "properties": {
            "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001740020413742353742343346394430423445304530353342303836313041434244453778"
          }
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/exchangerate/A7B57B43F9D0B4E0E053B08610ACBDE7",
          "name": "exchangerate",
          "kind": "item"
        }
      ]
    },
    {
      "BaexratBankCode": "CIBC",
      "BaexratFcurrCode": "USD",
      "BaexratTcurrCode": "CAD",
      "BaexratExchgTypeCode": "STD",
      "BaexratDate": "2015-01-01",
      "BaexratRate1": 1.2021,
      "BaexratRate2": 1.1975,
      "BaexratRate3": 1.2154,
      "BaexratAutoFlag": "0",
      "BaexratVUuid": "A7B57B43F9D1B4E0E053B08610ACBDE7",
      "BaexratIuCreateDate": "2015-05-21T20:50:08Z",
      "BaexratIuCreateUser": "BILL",
      "BaexratIuUpdateDate": null,
      "BaexratIuUpdateUser": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/exchangerate/A7B57B43F9D1B4E0E053B08610ACBDE7",
          "name": "exchangerate",
          "kind": "item",
          "properties": {
            "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001740020413742353742343346394431423445304530353342303836313041434244453778"
          }
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/exchangerate/A7B57B43F9D1B4E0E053B08610ACBDE7",
          "name": "exchangerate",
          "kind": "item"
        }
      ]
    },
    {
      "BaexratBankCode": "WELLS",
      "BaexratFcurrCode": "CAD",
      "BaexratTcurrCode": "USD",
      "BaexratExchgTypeCode": "STD",
      "BaexratDate": "2015-01-01",
      "BaexratRate1": 0.8604,
      "BaexratRate2": 0.9543,
      "BaexratRate3": 0.8647,
      "BaexratAutoFlag": "0",
      "BaexratVUuid": "A7B57B43F9D3B4E0E053B08610ACBDE7",
      "BaexratIuCreateDate": "2015-05-21T20:51:34Z",
      "BaexratIuCreateUser": "BILL",
      "BaexratIuUpdateDate": null,
      "BaexratIuUpdateUser": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/exchangerate/A7B57B43F9D3B4E0E053B08610ACBDE7",
          "name": "exchangerate",
          "kind": "item",
          "properties": {
            "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001740020413742353742343346394433423445304530353342303836313041434244453778"
          }
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/exchangerate/A7B57B43F9D3B4E0E053B08610ACBDE7",
          "name": "exchangerate",
          "kind": "item"
        }
      ]
    },
    {
      "BaexratBankCode": "WELLS",
      "BaexratFcurrCode": "USD",
      "BaexratTcurrCode": "CAD",
      "BaexratExchgTypeCode": "STD",
      "BaexratDate": "2015-01-01",
      "BaexratRate1": 1.2021,
      "BaexratRate2": 1.1975,
      "BaexratRate3": 1.2154,
      "BaexratAutoFlag": "0",
      "BaexratVUuid": "A7B57B43F9D2B4E0E053B08610ACBDE7",
      "BaexratIuCreateDate": "2015-05-21T20:50:44Z",
      "BaexratIuCreateUser": "BILL",
      "BaexratIuUpdateDate": null,
      "BaexratIuUpdateUser": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/exchangerate/A7B57B43F9D2B4E0E053B08610ACBDE7",
          "name": "exchangerate",
          "kind": "item",
          "properties": {
            "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001740020413742353742343346394432423445304530353342303836313041434244453778"
          }
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/exchangerate/A7B57B43F9D2B4E0E053B08610ACBDE7",
          "name": "exchangerate",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 6,
  "hasMore": false,
  "limit": 25,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/exchangerate",
      "name": "exchangerate",
      "kind": "collection"
    }
  ]
}
object