Retrieve BA Exchange Rates by Code
    • 25 Sep 2024
    • 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-21T08: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-21T08: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-21T08: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-21T08: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-21T08: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-21T08: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