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:

IBANaccount-id
NL52RABO0125618484Wp-xhZMGEWRIIgVjPwTC1aKJJ0VCRZ_4bScUVXof7e0
NL80RABO1127000002hBS4MQ0Oc4LLJRiUiER94-zoU4B2vwnPkXmsGh_bA

Scenario's for testing together with the Batch Transaction Details API present in the Sandbox environment:

IBANaccount-iddateFromdateTobatchEntryReferenceNoOfTransactions
NL52RABO0125618484Wp-xhZMGEWRIIgVjPwTC1aKJJ0VCRZ_4bScUVXof7e02025-07-01T00:00.00Z2025-07-31T23:59.59ZOM1B000000645366250
NL80RABO1127000002hBS4MQ0Oc4LLJRiUiER94-zoU4B2vwnPkXmsGh_bA2025-07-01T00:00.00Z2025-07-31T23:59.59ZOM1B0000006453651500
NL80RABO1127000002hBS4MQ0Oc4LLJRiUiER94-zoU4B2vwnPkXmsGh_bA2024-10-01T00:00.00Z2024-10-30T23:59.59ZOM1B000000645364550

Did this page help you?