Link

Get all orders

This retrieves information about all of your orders.

Required permissions: View

Available query string parameters:

parameter type additional info
externalOrderId Optional<String> filter by external order id, a list will be returned with one item or empty if nothing found
updatedSince Optional<Long> timestamp in milliseconds. Return all recently updated orders where “updatedAt” > {updatedSince}, and sorted by updatedAt ASC (oldest first)
portfolioId Optional<String> orders that are related to this portfolio
limit Optional<Int> by default 1000, max 2000
offset Optional<Int> by default 0
+ GET /platform/orders?limit=3&offset=0

+ Response 200 (application/json)
  {
    "orders": [
      {
        "orderId": "14697072",
        "externalOrderId": "ck2m90bpq000i3i5qwinf48ap",
        "status": "waiting-counterparty-approve",
        "orderType": "sell",
        "portfolioId": "9a7b6398-d4ac-4b26-ab62-f4dd7396aedb",
        "portfolioType": "trading",
        "accountId": "d961e420-cbcf-4642-83fd-82b184828a1e",
        "amount": "10",
        "baseCurrency": "XRP",
        "quoteCurrency": "USD",
        "limitType": "otc",
        "priceLimit": "0.02",
        "extra": {
          "reportingCurrencyRate": "0.31",
          "counterpartyPortfolioId": "666",
          "counterpartyOrderId": "14697073",
          "daysToSettle": "0",
          "feesPercent": "0.05"
        },
        "createdBy": "cc1bafa6-eb87-4a1e-ae6d-d27d0ea921aa",
        "organizationId": "TESTORG",
        "createdAt": "1572982234471",
        "updatedAt": "1572982234585"
      },
      {
        "orderId": "14694738",
        "externalOrderId": "XRP:3831041",
        "status": "waiting-approve",
        "orderType": "deposit",
        "portfolioId": "9a7b6398-d4ac-4b26-ab62-f4dd7396aedb",
        "portfolioType": "trading",
        "accountId": "d961e420-cbcf-4642-83fd-82b184828a1e",
        "amount": "20.000000",
        "baseCurrency": "XRP",
        "mainCurrency": "XRP",
        "extra": {
          "reportingCurrencyRate": "0.31",
          "terminatedReportingCurrencyRate": "0.31",
          "confirmations": "9",
          "transactionId": "7982C2F5E1E7DC6F6871CD7A3B01449DD27095FA11668EC738477717E1CA94C5",
          "transaction": {
            "inputs": [
              {
                "address": "rwCQk17fhC8G9UCoMgaxsEQb6fVy8HhUY6",
                "value": "20009000"
              }
            ],
            "outputs": [
              {
                "address": "rQUmVCVzbN9X91UzoiUKVs3sNRtpE5xWxi",
                "value": "20000000",
                "destinationTag": "1339786120"
              }
            ],
            "txId": "7982C2F5E1E7DC6F6871CD7A3B01449DD27095FA11668EC738477717E1CA94C5",
            "blockHeight": "51197352",
            "isSuccess": true,
            "currency": "XRP",
            "mainCurrency": "XRP"
          },
          "processingBy": "admin",
          "balanceSnapshot": "20.000000"
        },
        "organizationId": "TESTORG",
        "createdAt": "1572981553305",
        "updatedAt": "1572981771848",
        "terminatedAt": "1572981771582"
      },
      {
        "orderId": "12414905",
        "externalOrderId": "ck2bjzg4d000j3i5qtm66ehjx",
        "status": "executed",
        "orderType": "withdraw",
        "portfolioId": "c98af32b-c3e9-4bfb-972e-7e413bb5ce7e",
        "portfolioType": "custody",
        "accountId": "d961e420-cbcf-4642-83fd-82b184828a1e",
        "amount": "54.75",
        "baseCurrency": "XRP",
        "mainCurrency": "XRP",
        "extra": {
          "transactionRequest": {
            "xpubHash": "9fcf5c405c7c16ed4dda4ccfb768570b0bdc8cdaa5925d1f34e3aae6280a9578",
            "currency": "XRP",
            "mainCurrency": "XRP",
            "amount": "54750000",
            "toAddress": "rwCQk17fhC8G9UCoMgaxsEQb6fVy8HhUY6",
            "transactionRequest": {
              "fee": "10",
              "sequence": "2"
            }
          },
          "toAddress": "rwCQk17fhC8G9UCoMgaxsEQb6fVy8HhUY6",
          "reportingCurrencyRate": "0.2977",
          "terminatedReportingCurrencyRate": "0.30",
          "coSignersNumber": "2",
          "coSigners": [
            "cc1bafa6-eb87-4a1e-ae6d-d27d0ea921aa",
            "7dd1f64c-80be-46e8-8433-1573c28a7baa"
          ],
          "feesPercent": "0",
          "transactionId": "1083B51244D8BDC9890468B7C41B4E3BBE05EFEA244986664B2B69913706A919",
          "transaction": {
            "inputs": [
              {
                "address": "rBy2szZ1mhGmpZqwXzh9jW3SF8SFp9XD4t",
                "value": "54750000"
              }
            ],
            "outputs": [
              {
                "address": "rwCQk17fhC8G9UCoMgaxsEQb6fVy8HhUY6",
                "value": "54749990"
              }
            ],
            "txId": "1083B51244D8BDC9890468B7C41B4E3BBE05EFEA244986664B2B69913706A919",
            "blockHeight": "51033624",
            "isSuccess": true,
            "currency": "XRP",
            "mainCurrency": "XRP"
          },
          "partSigned": {
            "uploadBy": "7dd1f64c-80be-46e8-8433-1573c28a7baa",
            "transaction": {
              "type": "transaction",
              "value": "a600235b2c1de5d06b69ebf18f398f963cfbfe5664edddf957b6cc8b46f2cebb5a54986c5bf8b36045b37ef45af077bb9a9f4ae34607dcd74b7179a73ceee3a96M2MkHmVVSIUtoZA7VI0jrz7ScBqxQ+Q8jVT/Bz7oC5HykF4Bi3FVSOrj4D4ypjcRRj0KUvrWeBroBAWO/37c5hGycS4vNnemwHzbMrSfTRlKI0SAcaCc2hjAjBE26kVyuQH9NYUR1w6fDmuUaHMuYq7JfcCp78PyxdyPZ8HBFTJcWPwuZ9ZlJhEctYBf0RuoTewzrRNOnMM6o97Cs8oZZvYNWv4HRzhmujf16q8i2KIhcGzKNMgdTRpOl61u/CWDhuKvV4grYcr9JGhVF+uhIeoR3DHt6uJqmvrX881yK0d7cyo8t6p03WjZq+fYidxbq1kaPH3Oyqt9PmieQzfzHhfVmPslB4ZMSD+8lac1s4x0sTbvOLYPvmCG78nesR7tmpEjBs8GdKwtzCXgL/kVcfxK4HJ3Ae4WKc3h4BIDROJHq9+bmA0QolwWMNLNUzIjnFG7QQseHYAguBny7TpbSAMnEnveMHAPgIuYVDryx+2ZRMiJHTrX4TPPbpIm1N4nFJWTkOKbfeLgVKCKSYydOhW4K7RaQDGHXeJcL/InTRyQ1KxysYjLwevcsXnDpoJ5VbYfa0isl5Oe1uuqUlPaQair32GPDsXoxy7gL+4LFelY8TVBhVVPDWuHn3aABk94hLi6/TKDgQJQRffoEXHtL6GlAkT+YpJoiu+vAErMYx8SZrQ5d1F3j57Fhx5w2KBxobG9ZjAmaNvwOQ2G+V9wjXMamg/fp0XdH32JAFpVqw76akLAEj3cQY9XVpI2S1aesgxBx79C2Z9ZKvrSdpZcYXl19k86x+0gInioMb2QSQ/yH90wWK+ujZ/v8sLsjcfRE5I+eYEy7o7XVeOhBkN/GlvUzcicdbQ+o1no9bIzrKbUH/v1FG/Tu2sSIsy7ALH7Hx+uyWBW1SqsHag6t3M7bzCX6tbrfnrky2MJlPPS8Y5x8Y0Vpkoxx/NH42s2hgpp6hMAJmEylP03YD/Dp8DGQ=="
            },
            "orderId": "12414905"
          },
          "signed": {
            "uploadBy": "dc188f74-7f50-46e9-8925-d134f72209a8",
            "transaction": {
              "version": "1.0.256",
              "txRaw": "1200002400000002614000000003436B2668400000000000000A732102124A1E7174383B414AAEB1DE6A20BB602F5E3B9FE66B8E07C8F25398AD891F3D74473045022100C9F636C557B5A257064F31132F9A78627367A99A81A2411A02600E018CE904EA022071D8C7C196B7D4DE9A006FF7964D5C2DC824B2C3D58CF407509D2F771E0AFD4681147864244BB7BB89F8037751C256E5317B3E366BE1831469FCC4F96712210B9488625C058A3938566C7CA3",
              "txId": "1083B51244D8BDC9890468B7C41B4E3BBE05EFEA244986664B2B69913706A919"
            },
            "orderId": "12414905"
          },
          "balanceSnapshot": "20.000000"
        },
        "createdBy": "cc1bafa6-eb87-4a1e-ae6d-d27d0ea921aa",
        "organizationId": "TESTORG",
        "createdAt": "1572335541361",
        "updatedAt": "1572341613904",
        "terminatedAt": "1572341613767"
      }
    ],
    "total": "127"
  }

Export all orders to CSV

Call Get all orders endpoint with Accept: text/csv request header return all orders in CSV format.

+ GET /platform/orders?limit=3&offset=0

+ Headers:
  Accept: text/csv

+ Response 200 (text/csv)

  orderId;orderType;baseCurrency;quoteCurrency;amount;status;balanceSnapshot;accountId;accountName;accountType;firstName;lastName;email;createdAt;fromAccount;toAccount;terminatedAt
  "14697072";sell;XRP;USD;"10";"waiting-counterparty-approve";;"9a7b6398-d4ac-4b26-ab62-f4dd7396aedb";"Default Trading";Trading;Trader;First;"trader@example.com";"2019-11-05T19:30:34.471Z";;;"2019-11-05T19:48:50.964Z"
  "14694738";deposit;XRP;;"20.000000";"waiting-approve";"20.000000";"9a7b6398-d4ac-4b26-ab62-f4dd7396aedb";"Default Trading";Trading;;;;"2019-11-05T19:19:13.305Z";;;"2019-11-05T19:22:51.582Z"
  "12414905";withdraw;XRP;;"54.75";executed;;"c98af32b-c3e9-4bfb-972e-7e413bb5ce7e";"Default Vault";Custody;Trader;First;"trader@example.com";"2019-10-29T07:52:21.361Z";;;"2019-10-29T09:33:33.767Z"