Returns a list of transactions for a given account. Ordered chronologically by creation date, with the most recent transaction appearing first.
You can use optional parameters to filter the transactions.
For example, use budgetId to return only transactions associated with a given budget.
| limit | integer [ 1 .. 10000 ] Default: 100 The maximum number of results to return. Example: limit=200 |
| offset | integer Default: 0 The number of items to skip before returning results. Example: offset=100 |
string or Array of strings Controls which optional properties should be attached to the response. Example: include=bankFeedDetails,annotations | |
string or Array of strings The ID of the person to work with. Use commas to pass multiple values. Has to be URL encoded. | |
string or Array of strings The Example: type=payment%2Cload | |
string or Array of strings The Example: excludeType=payment%2Cload | |
string or Array of strings The status to filter transactions by. Use commas to pass multiple values. Has to be URL encoded. Learn more about transaction statuses. Example: status=complete%2Ccancelled | |
string or Array of strings The | |
string or Array of strings The Example: budgetName=Account%2Cmarketing | |
string or Array of strings Filters transactions that include selling these currencies. Use commas to pass multiple values. Has to be URL encoded. Example: sellCurrency=USD%2CEUR | |
string or Array of strings Filters orders that include purchasing these currencies. Use commas to pass multiple values. Has to be URL encoded. Example: buyCurrency=GBP | |
| startDate | string The earliest date from which to retrieve records (includes records on this date). Example: startDate=2021-02-15 |
| endDate | string The latest date until which to retrieve records (includes records on this date). Example: endDate=2021-02-16 |
| search | string <= 100 characters The term to search the records for. Example: search=Cesar+Treutel |
string or Array of strings If Example: annotationStatus=draft%2Csubmitted | |
string or Array of strings If Example: attachmentStatus=absent%2Cpresent | |
| batchPaymentOrders | string description: 'If true, returns orders instead of the list of all payments from batches. Example: batchPaymentOrders=true |
OK
{- "limit": 200,
- "offset": 100,
- "count": 67,
- "rows": [
- {
- "resourceType": "payment",
- "id": 42782085,
- "orderId": 1380,
- "userId": "34edaf73-49be-4669-83ee-1b1f8c680d26",
- "companyId": "F50072",
- "originId": "9a623439-8275-4230-a157-6c623a2ea7b8",
- "originOrderId": "EKOBEPVFJ",
- "budgetId": "775596ae-2624-40af-a9dc-9756110a4a03",
- "status": "orderCancelled",
- "isMultiBeneficiary": true,
- "budget": "companyBalance",
- "beneficiaryId": "ben90944601",
- "beneficiaryName": "Nichole Grant",
- "beneficiaryAddress": "46315 Bailey MillSouth CamilleNiue",
- "beneficiaryAccountNumber": "10387899",
- "beneficiarySortCode": "12-34-56",
- "beneficiaryIban": "PT72105510150936500020992",
- "beneficiaryBankCode": "QHKEMKK1",
- "beneficiaryBankAddress": "883 Bernie MountainNew EstachesterVietnam",
- "beneficiaryCountryCode": "GB",
- "beneficiaryRoutingInfo": "Payment will be routed from Barclays Bank and then through Lloyds bank",
- "remitterName": "Joseph Bloggs",
- "reference": "withdrawal transaction at Osinski, Zboncak and Bayer using card ending with ***3963 for IDR 670.50 in account ***32418758",
- "amount": 773.08,
- "currency": "USD",
- "sellCurrency": "USD",
- "buyCurrency": "USD",
- "settlementAmount": 33920.34,
- "settlementFee": 1.34,
- "settlementAmountWithoutFee": 33920.34,
- "customerRate": 0.8637052,
- "customerInverseRate": 0.71942446043,
- "confirmationKey": "F36555/pdf/F36555-000265963.pdf",
- "uniqueId": "69e4a1e8-db35-4301-b5a8-67a2cb063609",
- "type": "exchange",
- "order": {
- "id": 1380,
- "companyId": "F50072",
- "events": [
- null
], - "originId": "9a623439-8275-4230-a157-6c623a2ea7b8",
- "status": "complete",
- "type": "payment",
- "userId": "34edaf73-49be-4669-83ee-1b1f8c680d26",
- "userName": "John Doe",
- "lastSourceEventDatetime": "2019-08-24T14:15:22Z",
- "orderSource": "string",
- "parentOriginId": "string",
- "settlementDate": "string",
- "initiator": "John Doe",
- "createdAt": "2019-08-24T14:15:22Z",
- "updatedAt": "2019-08-24T14:15:22Z",
- "metadata": "{ paymentsCount: 1 }"
}, - "deleted": true,
- "budgetName": "string",
- "transactionGroupId": "1c0547bd-30e6-4d14-b82e-78cd128fbfd9",
- "transactionBoxes": [
- {
- "id": "2af0e603-0c72-4a7c-8020-52916d7a9960",
- "accountId": "F50091",
- "budgetId": "775596ae-2624-40af-a9dc-9756110a4a03",
- "transactionId": "42782085",
- "transactionBoxableId": "42782085",
- "transactionBoxableType": "payment",
- "paymentId": 42782085,
- "orderId": "E61BG8PJCXQ4-Fee",
- "eventSource": "Orders",
- "chargeBearer": "string",
- "blockId": "454",
- "blockTag": "abd8d22e-d701-45c4-960a-d198e0e16a14",
- "paymentType": "UK.OBIE.BalanceTransfer",
- "creditDebitIndicator": "Debit",
- "thirdPartyReference": "abd8d22e-d701-45c4-960a-d198e0e16a14-FEE",
- "internalAccountTransferId": "BR89",
- "affectsLedgerBalance": false,
- "isCurrencyAlignment": false,
- "runningBalance": "957.92",
- "transactionReference": "",
- "statementReference": "",
- "debtorAccount": {
- "id": "ed8388b1-4d01-41e7-a04a-2be9a56adb68",
- "ownerId": "d6061bbee6",
- "accountId": "F50091",
- "schemeName": "UK.OBIE.SortCodeAccountNumber",
- "identification": "23188474064478",
- "name": "Joe Bloggs 202106171735",
- "address": "21 test street",
- "institutionAddress": "29 test street",
- "institutionBic": "1",
- "institutionName": "Test Name",
- "transactionBoxId": "1ee51a67-d6ba-480e-9686-f2fadb1fa1ef"
}, - "creditorAccount": {
- "id": "ed8388b1-4d01-41e7-a04a-2be9a56adb68",
- "ownerId": "d6061bbee6",
- "accountId": "F50091",
- "schemeName": "UK.OBIE.SortCodeAccountNumber",
- "identification": "23188474064478",
- "name": "Joe Bloggs 202106171735",
- "address": "21 test street",
- "institutionAddress": "29 test street",
- "institutionBic": "1",
- "institutionName": "Test Name",
- "transactionBoxId": "1ee51a67-d6ba-480e-9686-f2fadb1fa1ef"
}, - "fx": {
- "sourceCurrency": "USD",
- "sourceAmount": "1.16",
- "destinationCurrency": "USD",
- "destinationAmount": "1.00",
- "rate": "0.8621"
}, - "debitId": 1097,
- "creditId": 1098,
- "boxTransactionId": 17098,
- "budget": {
- "accountId": "F50091",
- "budgetId": "775596ae-2624-40af-a9dc-9756110a4a03",
- "budgetName": "Account Balance",
- "boxId": "5426d2ca50"
}, - "type": "credit",
- "marqetaTransactionToken": "34edaf73-49be-4669-83ee-1b1f8c680d26",
- "boxId": "34edaf73-49be-4669-83ee-1b1f8c680d26",
- "marqetaTransactionIdentifier": "940",
- "amount": 20,
- "currency": "USD",
- "valueDateTime": "2021-01-30T08:30:00Z",
- "bankFeedTransactions": [
- null
], - "transactionCreditorAccount": {
- "id": "ed8388b1-4d01-41e7-a04a-2be9a56adb68",
- "ownerId": "d6061bbee6",
- "accountId": "F50091",
- "schemeName": "UK.OBIE.SortCodeAccountNumber",
- "identification": "23188474064478",
- "name": "Joe Bloggs 202106171735",
- "address": "21 test street",
- "institutionAddress": "29 test street",
- "institutionBic": "1",
- "institutionName": "Test Name",
- "transactionBoxId": "1ee51a67-d6ba-480e-9686-f2fadb1fa1ef"
}, - "transactionDebtorAccount": {
- "id": "ed8388b1-4d01-41e7-a04a-2be9a56adb68",
- "ownerId": "d6061bbee6",
- "accountId": "F50091",
- "schemeName": "UK.OBIE.SortCodeAccountNumber",
- "identification": "23188474064478",
- "name": "Joe Bloggs 202106171735",
- "address": "21 test street",
- "institutionAddress": "29 test street",
- "institutionBic": "1",
- "institutionName": "Test Name",
- "transactionBoxId": "1ee51a67-d6ba-480e-9686-f2fadb1fa1ef"
}, - "createdAt": "2019-08-24T14:15:22Z",
- "updatedAt": "2019-08-24T14:15:22Z"
}
], - "annotationGroup": {
- "id": "c32ba075-f6e9-45db-aae8-a8f1aeaa13b6",
- "accountId": "F50091",
- "transactionGroupId": "c32ba075-f6e9-45db-aae8-a8f1aeaa13b6",
- "paymentId": 1234,
- "status": "draft",
- "annotations": [
- {
- "id": "c32ba075-f6e9-45db-aae8-a8f1aeaa13b6",
- "annotationGroupId": "c32ba075-f6e9-45db-aae8-a8f1aeaa13b6",
- "accountId": "F50091",
- "amount": 100,
- "annotationValues": [
- null
], - "createdBy": "f7aa80c9-4d4a-4a52-8ae2-b73638b3f2d8",
- "updatedBy": "f7aa80c9-4d4a-4a52-8ae2-b73638b3f2d8",
- "createdAt": "2019-08-24T14:15:22Z",
- "updatedAt": "2019-08-24T14:15:22Z"
}
], - "createdAt": "2019-08-24T14:15:22Z",
- "updatedAt": "2019-08-24T14:15:22Z"
}, - "attachment": {
- "id": "c32ba075-f6e9-45db-aae8-a8f1aeaa13b6",
- "accountId": "F50091",
- "isLost": false,
- "note": "I did not lose the file to attach so I do not need to fill in this field.",
- "transactionGroupId": "c32ba075-f6e9-45db-aae8-a8f1aeaa13b6",
- "paymentId": 1234,
- "count": 2,
- "attachmentFiles": [
- {
- "id": "c32ba075-f6e9-45db-aae8-a8f1aeaa13b6",
- "accountId": "F50091",
- "attachmentId": "c32ba075-f6e9-45db-aae8-a8f1aeaa14b3",
- "productId": "3ef24d53-6e22-4103-a16b-d268e4f7346d",
- "fileName": "2021-09-01T13:04:57Z_288946aa-0469-4518-a962-40e9be858d1e_2.pdf",
- "year": "2021",
- "month": "9",
- "file": true,
- "type": "pdf",
- "createdBy": "f7aa80c9-4d4a-4a52-8ae2-b73638b3f2d8",
- "updatedBy": "f7aa80c9-4d4a-4a52-8ae2-b73638b3f2d8",
- "createdAt": "2019-08-24T14:15:22Z",
- "updatedAt": "2019-08-24T14:15:22Z"
}
], - "createdAt": "2019-08-24T14:15:22Z",
- "updatedAt": "2019-08-24T14:15:22Z"
}, - "teams": "string",
- "createdAt": "2019-08-24T14:15:22Z",
- "updatedAt": "2019-08-24T14:15:22Z"
}
]
}