Query node for utxo transaction history

Hey guys & gals,

Is it possible to query my cardano node for an address’ transaction history? Lets say for example last 5 transactions from a specific address?

I found some documentation on cardano-wallet utility but I am using cardano-addresses since I needed to create a large number of addresses derived from one root address.

Any help is greatly appreciated!!

Hello @Chris_vd_Heijden :

instead of the CLI commands you can use one of the APIs to do that.

You can query the transactions done by a specific address:
https://mainnet.cutymals.com/odata/TransactionsOut?address=addr1q9s5nqzv2yd93cqd6x94qtjg0yp654uzwnd33g0wg2kd9pscfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hswa3mh7&X-API-KEY=ILoveCutyMals

"value": [
    {
      "Id": 62720133,
      "TxId": 26804672,
      "Index": 1,
      "Address": "addr1q9s5nqzv2yd93cqd6x94qtjg0yp654uzwnd33g0wg2kd9pscfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hswa3mh7",
      "AddressRaw": "016149804c511a58e00dd18b502e487903aa578274db18a1ee42acd286184851696e018839d5d782865766748734140ea3eb0f70686ae1616f",
      "PaymentCred": "6149804c511a58e00dd18b502e487903aa578274db18a1ee42acd286",
      "StakeAddressId": 4244596,
      "Value": 7751640,
      "AddressHasScript": false,
      "DataHash": null
    },
    {
      "Id": 62720388,
      "TxId": 26804779,
      "Index": 0,
      "Address": "addr1q9s5nqzv2yd93cqd6x94qtjg0yp654uzwnd33g0wg2kd9pscfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hswa3mh7",
      "AddressRaw": "016149804c511a58e00dd18b502e487903aa578274db18a1ee42acd286184851696e018839d5d782865766748734140ea3eb0f70686ae1616f",
      "PaymentCred": "6149804c511a58e00dd18b502e487903aa578274db18a1ee42acd286",
      "StakeAddressId": 4244596,
      "Value": 1500000,
      "AddressHasScript": false,
      "DataHash": null
    }
  ]

Or you can query all transactions done by a wallet (e.g. the stake key which unites all addresses of a wallet):
https://mainnet.cutymals.com/odata/TransactionsOut?stakeAddress=stake1uyvys5tfdcqcsww467pgv4mxwjrng9qw504s7urgdtskzmcxrh4t4&X-API-KEY=ILoveCutyMals

"value": [
    {
      "Id": 60765802,
      "TxId": 25989392,
      "Index": 0,
      "Address": "addr1q892p6eht6w0nexy39s7qsyxaefag9n9zzzher5wztcht8gcfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hsdskn4j",
      "AddressRaw": "01caa0eb375e9cf9e4c48961e04086ee53d4166510857c8e8e12f1759d184851696e018839d5d782865766748734140ea3eb0f70686ae1616f",
      "PaymentCred": "caa0eb375e9cf9e4c48961e04086ee53d4166510857c8e8e12f1759d",
      "StakeAddressId": 4244596,
      "Value": 55000000,
      "AddressHasScript": false,
      "DataHash": null
    },
    {
      "Id": 60783498,
      "TxId": 25997113,
      "Index": 1,
      "Address": "addr1q9s2ar22prfpq0xyxjdmjxjhmsvskh3fh9nyc7786ks5gnqcfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hse56d93",
      "AddressRaw": "0160ae8d4a08d2103cc4349bb91a57dc190b5e29b9664c7bc7d5a1444c184851696e018839d5d782865766748734140ea3eb0f70686ae1616f",
      "PaymentCred": "60ae8d4a08d2103cc4349bb91a57dc190b5e29b9664c7bc7d5a1444c",
      "StakeAddressId": 4244596,
      "Value": 3444404,
      "AddressHasScript": false,
      "DataHash": null
    },
    {
      "Id": 60783499,
      "TxId": 25997113,
      "Index": 2,
      "Address": "addr1q9s2ar22prfpq0xyxjdmjxjhmsvskh3fh9nyc7786ks5gnqcfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hse56d93",
      "AddressRaw": "0160ae8d4a08d2103cc4349bb91a57dc190b5e29b9664c7bc7d5a1444c184851696e018839d5d782865766748734140ea3eb0f70686ae1616f",
      "PaymentCred": "60ae8d4a08d2103cc4349bb91a57dc190b5e29b9664c7bc7d5a1444c",
      "StakeAddressId": 4244596,
      "Value": 1383759,
      "AddressHasScript": false,
      "DataHash": null
    },
    {
      "Id": 60800547,
      "TxId": 26004447,
      "Index": 0,
      "Address": "addr1q892p6eht6w0nexy39s7qsyxaefag9n9zzzher5wztcht8gcfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hsdskn4j",
      "AddressRaw": "01caa0eb375e9cf9e4c48961e04086ee53d4166510857c8e8e12f1759d184851696e018839d5d782865766748734140ea3eb0f70686ae1616f",
      "PaymentCred": "caa0eb375e9cf9e4c48961e04086ee53d4166510857c8e8e12f1759d",
      "StakeAddressId": 4244596,
      "Value": 2000000,
      "AddressHasScript": false,
      "DataHash": null
    },
    {
      "Id": 60806742,
      "TxId": 26007034,
      "Index": 1,
      "Address": "addr1q80c93q2vfm0wfakm077yxzd2mgtxd8dt3mvrq29vucu86qcfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hsfx6g8t",
      "AddressRaw": "01df82c40a6276f727b6dbfde2184d56d0b334ed5c76c181456731c3e8184851696e018839d5d782865766748734140ea3eb0f70686ae1616f",
      "PaymentCred": "df82c40a6276f727b6dbfde2184d56d0b334ed5c76c181456731c3e8",
      "StakeAddressId": 4244596,
      "Value": 1648318,
      "AddressHasScript": false,
      "DataHash": null
    },
    {
      "Id": 62683801,
      "TxId": 26789253,
      "Index": 0,
      "Address": "addr1qysr6qu2vgpcw4w9uaj5m3sjv3fa4plvyfvvwesavdh7q8qcfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hswf83fd",
      "AddressRaw": "01203d038a62038755c5e7654dc6126453da87ec2258c7661d636fe01c184851696e018839d5d782865766748734140ea3eb0f70686ae1616f",
      "PaymentCred": "203d038a62038755c5e7654dc6126453da87ec2258c7661d636fe01c",
      "StakeAddressId": 4244596,
      "Value": 51000000,
      "AddressHasScript": false,
      "DataHash": null
    },
    {
      "Id": 62686489,
      "TxId": 26790399,
      "Index": 1,
      "Address": "addr1qymhc0zhug08exk3w234mrxun2yf5dq8t2vwn4y0vncwxngcfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hswhzu2l",
      "AddressRaw": "01377c3c57e21e7c9ad172a35d8cdc9a889a34075a98e9d48f64f0e34d184851696e018839d5d782865766748734140ea3eb0f70686ae1616f",
      "PaymentCred": "377c3c57e21e7c9ad172a35d8cdc9a889a34075a98e9d48f64f0e34d",
      "StakeAddressId": 4244596,
      "Value": 20761542,
      "AddressHasScript": false,
      "DataHash": null
    },
    {
      "Id": 62714627,
      "TxId": 26802434,
      "Index": 1,
      "Address": "addr1q8yeps8k0tg4m4322tz7t6tepwf6kdrv7h39ampgjwyhglscfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hsatejcd",
      "AddressRaw": "01c990c0f67ad15dd62a52c5e5e9790b93ab346cf5e25eec289389747e184851696e018839d5d782865766748734140ea3eb0f70686ae1616f",
      "PaymentCred": "c990c0f67ad15dd62a52c5e5e9790b93ab346cf5e25eec289389747e",
      "StakeAddressId": 4244596,
      "Value": 18593225,
      "AddressHasScript": false,
      "DataHash": null
    },
    {
      "Id": 62714965,
      "TxId": 26802572,
      "Index": 0,
      "Address": "addr1q8yeps8k0tg4m4322tz7t6tepwf6kdrv7h39ampgjwyhglscfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hsatejcd",
      "AddressRaw": "01c990c0f67ad15dd62a52c5e5e9790b93ab346cf5e25eec289389747e184851696e018839d5d782865766748734140ea3eb0f70686ae1616f",
      "PaymentCred": "c990c0f67ad15dd62a52c5e5e9790b93ab346cf5e25eec289389747e",
      "StakeAddressId": 4244596,
      "Value": 1500000,
      "AddressHasScript": false,
      "DataHash": null
    },
    {
      "Id": 62718928,
      "TxId": 26804170,
      "Index": 1,
      "Address": "addr1qx09049cd5l4c3lcu7tc9mggh8mtd29ra8y6tedfchqmcnccfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hsljpzs9",
      "AddressRaw": "019e57d4b86d3f5c47f8e79782ed08b9f6b6a8a3e9c9a5e5a9c5c1bc4f184851696e018839d5d782865766748734140ea3eb0f70686ae1616f",
      "PaymentCred": "9e57d4b86d3f5c47f8e79782ed08b9f6b6a8a3e9c9a5e5a9c5c1bc4f",
      "StakeAddressId": 4244596,
      "Value": 16424908,
      "AddressHasScript": false,
      "DataHash": null
    }
  ],

And if you dont know the stake key, you can just derive it from an existing address:
https://mainnet.cutymals.com/api/CardanoTools/GetStakeAddressFromAddress/addr1q9s5nqzv2yd93cqd6x94qtjg0yp654uzwnd33g0wg2kd9pscfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hswa3mh7?X-API-KEY=ILoveCutyMals

{
  "address": "addr1q9s5nqzv2yd93cqd6x94qtjg0yp654uzwnd33g0wg2kd9pscfpgkjmsp3quat4uzsetkvay8xs2qagltpacxs6hpv9hswa3mh7",
  "stakeAddress": "stake1uyvys5tfdcqcsww467pgv4mxwjrng9qw504s7urgdtskzmcxrh4t4"
}

I hope that helps you achieving your goal.
If you’re curios what else you can do with the free api check our swagger
Swagger UI (mainnet.cutymals.com)