Transactions
Available Endpoints
Read Transactions
GET accounts/{account-id}/transactions
Example request and responses
Read Transactions
Endpoint: https://api-sandbox.rabobank.nl/openapi/sandbox/payments/insight/accounts/Wp-xhZMGEWRIIgVjPwTC1aKJJ0VCRZ_4bScUVXof7e0/transactions?bookingStatus=Booked&dateFrom=2021-07-18T02:41:10.529Z&dateTo=2021-10-19T02:41:10.529Z
Request
X-Request-ID: 9c96b7e-8470-410a-937c-396fe9512fea
Date: Thu, 18 Mar 2021 15:10:46 GMT
Digest: sha-512=z4PhNX7vuL3xVChQ1m2AB9Yg5AULVxXcg/SpIdNs6c5H0NE8XYXysP+DGNKHfuwvY7kxvUdBeoGlODJ6+SfaPg==
Signature-Certificate: MIID9DCCAtygAwIBAgIUUzEdjjbjLOePU7NeZfai6bv9RJIwDQYJKoZIhvcNAQELBQAweDEyMDAGA1UEAwwpUmFib2JhbmsgZGV2ZWxvcGVyIHBvcnRhbCBTYW5kYm94IHRlc3RpbmcxCzAJBgNVBAYTAk5MMRAwDgYDVQQIDAdVdHJlY2h0MRAwDgYDVQQHDAdVdHJlY2h0MREwDwYDVQQKDAhSYWJvYmFuazAgFw0yNTExMTIxNTQ3MzRaGA8yMTAwMTAyNTE1NDczNFoweDEyMDAGA1UEAwwpUmFib2JhbmsgZGV2ZWxvcGVyIHBvcnRhbCBTYW5kYm94IHRlc3RpbmcxCzAJBgNVBAYTAk5MMRAwDgYDVQQIDAdVdHJlY2h0MRAwDgYDVQQHDAdVdHJlY2h0MREwDwYDVQQKDAhSYWJvYmFuazCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBALGoQqBxfADuEAHs/k1UoKkqn1XrK3ocV/rItsnCU3ynW9gahC8Ggj4UtcjNcXh8fBieV+6oeFcMRXofY6PiS6IM3YxofwMUM0JqTC/JZcoVhnEButAbg+DVJJfR7jxEDFUR2LL2RTLHYugtJdbg92kuUy7bXjayj6/Ef2R3s+cI7rHiI7oAftce61k4sVmQxGtxAVt+jrSB8eX/hVqdzfNb1MSzRbfII56rLgeaSbWm7gkYcJimyWjPuabqxY0cIvwkum5BRJ87x+QRdxzJuXYuwZsUMaY4ETYiiwUv7Q2vOZ066a6zBs++JSdgCUypvqm9YvRn3vCxB3+me+jvhdUCAwEAAaN0MHIwHQYDVR0OBBYEFHr3mI71/GxAJ/nDhNTZL+XEX6cZMB8GA1UdIwQYMBaAFHr3mI71/GxAJ/nDhNTZL+XEX6cZMA4GA1UdDwEB/wQEAwIFoDAgBgNVHSUBAf8EFjAUBggrBgEFBQcDAQYIKwYBBQUHAwIwDQYJKoZIhvcNAQELBQADggEBAEZod53U0IhIQZSVo4mVSn/bWT53uaeAcSwtRi+hyb8K2nDmT8wWdb6xewghd6EXIpWwetG8+odqvCaatdwPa4XjxE9XEecZC+EAYucY7joEk+maDjgJdgNNCwmWGQvOi9Fav9o2bbSGC3Y615K34aMmSNfuCGJHTw88RciLhPUdLMQF3gUTcQjlRcmE0oBZilZ0BF8Q1BIaJiFZZ7nNb4FGYB3ouySsmz/aPTz+VENZp2geCGjxW+SUIVpKiWA6NN2iJkp4Zywe39FxCca0Fw+QHl0vuMhh5fxyFA3eJLZREsZdgqwXnvIwNIM6/Yd1lxUIEyHL1J/m/vcJv/X0ZY4=
Signature: keyId="474941545142452678797059264714336600071935444114",algorithm="rsa-sha512",headers="date digest x-request-id",signature="GyfIH1COcS7hXa3o1MEaTnsgmu1IkHErjW7sNZPfN3neRx5GzSAl/mH7pNJWhaeESOaNkZM6ocOr9LjpnGjEEOcNfz38eBp1LkfsWyvULOWcLyXKyOCuOcyR8++ukANZnzcX2GBCvENwH8WGdj1bjVyIvhV7i+sn6zYdaXllYOjWlEq2Xhicjp9qios1NecB0Qj9j3h8f+RJF2cjiOjkwALb+TTSc5OyDDN8wHVal4llgaKdULNPMbTqJv3W267jRgM4AUiDR6UY3jgdf2MjSq0J7CGRRCXINAMnS3Bn+oYiqXo1GqFN90gWf2Owc3NMVEGwxeYpuCCPbWicU8/4fA=="
Body:Response
{
"account": {
"currency": "EUR",
"iban": "NL52RABO0125618484"
},
"transactions": {
"_links": {
"account": "/accounts/Wp-xhZMGEWRIIgVjPwTC1aKJJ0VCRZ_4bScUVXof7e0"
},
"booked": [
{
"bookingDate": "2021-10-19",
"creditorAccount": {
"currency": "EUR",
"iban": "NL52RABO0125618484"
},
"creditorAgent": "RABONL2U",
"creditorId": "SI-RKC9I",
"debtorAccount": {
"iban": "NL11RABO1286001009"
},
"debtorAgent": "INGBNL2A",
"debtorName": "Dexter Morris",
"entryReference": "1",
"currencyExchange": [
{
"sourceCurrency": "USD",
"targetCurrency": "EUR",
"exchangeRate": "0.56789"
}
],
"initiatingPartyName": "Jane Dillan",
"instructedAmount": {
"amount": 0.84,
"sourceCurrency": "USD"
},
"numberOfTransactions": 550,
"batchEntryReference": "OM1B000000645364",
"paymentInformationIdentification": "123456",
"raboBookingDateTime": "2021-10-19T14:21:00.000008Z",
"raboDetailedTransactionType": "633",
"raboTransactionTypeName": "st",
"reasonCode": "AG01",
"remittanceInformationStructured": "+++387/5494/481+++",
"remittanceInformationUnstructured": "",
"transactionAmount": {
"value": "55000.0",
"currency": "EUR"
},
"ultimateCreditor": "Joane Cruz",
"ultimateDebtor": "Philip Dillan",
"valueDate": "2021-10-19",
"unitCurrency": "USD",
"balanceAfterBooking": {
"balanceType": "InterimBooked",
"balanceAmount": {
"value": "473.02",
"currency": "EUR"
}
},
"bankTransactionCode": "PMNT-RCDT-ESCT"
}
]
}
}The bookingDate and raboBookingDateTime are provided in GMT (UTC). When processing timestamps, ensure proper time zone conversion is applied.
Account-id's present in the Sandbox environment:
| IBAN | account-id |
|---|---|
| NL52RABO0125618484 | Wp-xhZMGEWRIIgVjPwTC1aKJJ0VCRZ_4bScUVXof7e0 |
| NL80RABO1127000002 | hBS4MQ0Oc4LLJRiUiER94-zoU4B2vwnPkXmsGh_bA |
Scenario's for testing together with the Batch Transaction Details API present in the Sandbox environment:
| IBAN | account-id | dateFrom | dateTo | batchEntryReference | NoOfTransactions |
|---|---|---|---|---|---|
| NL52RABO0125618484 | Wp-xhZMGEWRIIgVjPwTC1aKJJ0VCRZ_4bScUVXof7e0 | 2025-07-01T00:00.00Z | 2025-07-31T23:59.59Z | OM1B000000645366 | 250 |
| NL80RABO1127000002 | hBS4MQ0Oc4LLJRiUiER94-zoU4B2vwnPkXmsGh_bA | 2025-07-01T00:00.00Z | 2025-07-31T23:59.59Z | OM1B000000645365 | 1500 |
| NL80RABO1127000002 | hBS4MQ0Oc4LLJRiUiER94-zoU4B2vwnPkXmsGh_bA | 2024-10-01T00:00.00Z | 2024-10-30T23:59.59Z | OM1B000000645364 | 550 |
Updated 2 days ago
Did this page help you?
