It seems that you need to use the command "listtransactions" if you want to list all transactions (Both receive and sent transactions).
Read it here https://bitcoincore.org/en/doc/0.21.0/rpc/wallet/listtransactions/
Get more RPC commands here https://chainquery.com/bitcoin-cli#
Topic: List all received and sent transactions by address (Read 136 times)
I would like to list all received and sent transactions by an address.
How can this be done ?
How can this be done ?
I don't know how to do this using bitcoin core.
But I know how to do this using an external API (You may have privacy issues, as you are requesting to third party).
https://api.blockchair.com/bitcoin/dashboards/address/12cbQLTFMXRnSzktFkuoG3eHoMeFtpTu3S?transaction_details=true
Example response:
Code:
{
"data": {
"12cbQLTFMXRnSzktFkuoG3eHoMeFtpTu3S": {
"address": {
"type": "pubkeyhash",
"script_hex": "76a91411b366edfc0a8b66feebae5c2e25a7b6a5d1cf3188ac",
"balance": 1843772638,
"balance_usd": 830472.07160796,
"received": 19543772638,
"received_usd": 1178.3017,
"spent": 17700000000,
"spent_usd": 1.77,
"output_count": 51,
"unspent_output_count": 46,
"first_seen_receiving": "2009-01-09 03:54:39",
"last_seen_receiving": "2021-04-05 21:42:49",
"first_seen_spending": "2009-01-12 03:30:25",
"last_seen_spending": "2009-01-12 20:04:20",
"scripthash_type": null,
"transaction_count": 51
},
"transactions": [
{
"block_id": 677929,
"hash": "bd59cb93d6a22991a5572361e1729bc6a9489660fd847206b89fd754981b60ec",
"time": "2021-04-05 21:42:49",
"balance_change": 5611
},
{
"block_id": 643172,
"hash": "7cb8b3623c00e9751333bbd5f7f8aa53f36a156092fc4c4fdde239fe4213ee50",
"time": "2020-08-11 06:03:31",
"balance_change": 547
},
{
"block_id": 643169,
"hash": "7775a1204bc445ad9966ee0a1c9acec8115bb2cba02934e247939f83c31be469",
"time": "2020-08-11 05:56:35",
"balance_change": 547
},
{
"block_id": 580247,
"hash": "23c3c252d35abdeaed484bc2fbbe373701aac2776365b01692402df4c2bc85b8",
"time": "2019-06-11 13:48:10",
"balance_change": 10000
},
{
"block_id": 564789,
"hash": "8f716720ef9caf72149e262748e543df1fc2996cb5ae95d6cec2678dd06601ce",
"time": "2019-02-26 20:37:12",
"balance_change": 588
},
{
"block_id": 558860,
"hash": "ba7f6b30ee34bf9bbb6ebbbe1b1a32a01b40dc952c160a35ae7565252fa1ab1e",
"time": "2019-01-17 04:59:14",
"balance_change": 660619
},
{
"block_id": 550371,
"hash": "62102bcef551308d081504342083ebf35d7f082738cc510c5cd94b3f7ecb5e23",
"time": "2018-11-17 00:23:43",
"balance_change": 17932
},
{
"block_id": 550359,
"hash": "7b9d92b6098a1e5c11e948d9ac1dd18fb18087f6fd4864a4d0413a4345bb8bc7",
"time": "2018-11-16 22:11:03",
"balance_change": 20977
},
{
"block_id": 541525,
"hash": "8e8e4148332eefe195c51377d18a95f2c70972e829977d9752888ac1dd45e4ab",
"time": "2018-09-15 13:40:51",
"balance_change": 100000
},
{
"block_id": 529906,
"hash": "c7bd29267a338ff592209123b99e37bb8431f0b8511bd485d3d9a68c5f0bb97a",
"time": "2018-06-30 15:05:31",
"balance_change": 17000000
},
{
"block_id": 515394,
"hash": "ad38beebfb3f9ecc759787a69ada97c561a11e1a22355a052e5ab750774e5f8b",
"time": "2018-03-27 14:06:10",
"balance_change": 66593
},
{
"block_id": 496418,
"hash": "0259713cf98049818691cfa9bf8628823a3eae437e3287ce4896ad3871f65c89",
"time": "2017-11-27 21:44:46",
"balance_change": 2580
},
{
"block_id": 483666,
"hash": "0b49e4e83c75005c9863ab868fe7d548451f38095ac79c3304ff012a815ca451",
"time": "2017-09-05 14:38:11",
"balance_change": 10000
},
{
"block_id": 483210,
"hash": "ba60b4e0437562402caa17ffce31f6f62e4149986a17b8aa3bab044025763ea9",
"time": "2017-09-02 22:28:03",
"balance_change": 218000
},
{
"block_id": 464282,
"hash": "595cf9da27359b36196ad457acba9a409ef68f51d6cd130e5449a4f418fb62f1",
"time": "2017-05-01 01:51:15",
"balance_change": 80708
},
{
"block_id": 425909,
"hash": "b6bd983868e1e3944b45dd644832ece3791f86c494c679ea2a8fcd884f1b2769",
"time": "2016-08-19 17:56:49",
"balance_change": 50000
},
{
"block_id": 411567,
"hash": "c4b968504a34a27482bf0f1f9d9b93b74fddbf3877cfd92e2fde48c6ba8c791c",
"time": "2016-05-13 10:01:54",
"balance_change": 6660
},
{
"block_id": 410787,
"hash": "f5b204652306e30faa99600994482f6fc9df8ba12df3576d0833091eb8270e64",
"time": "2016-05-08 08:24:15",
"balance_change": 27323
},
{
"block_id": 410520,
"hash": "cafeea4014228d575610eea291de6288c2125f9ec49a078bcb221c1c30648caa",
"time": "2016-05-06 14:24:53",
"balance_change": 5430
},
{
"block_id": 410400,
"hash": "1d21fdbbddc8985ead4079261d9db4608f0b3cc946cb52081c5e347a9cddd63a",
"time": "2016-05-05 20:55:22",
"balance_change": 22272
},
{
"block_id": 410400,
"hash": "e82f85e879cba004ff6ed485a4c90b30350aa900d39327e2e37868504af74799",
"time": "2016-05-05 20:55:22",
"balance_change": 22272
},
{
"block_id": 410400,
"hash": "fc0bffe90fa4bb922c77ce3a9fc86742cb6bd38f57a7bf28c900c0470de5137f",
"time": "2016-05-05 20:55:22",
"balance_change": 22272
},
{
"block_id": 410400,
"hash": "eedbae6778bcf62f7ecd3eaa7bbabdcaf6992e9284ed2b3cc1c90f3a9fece711",
"time": "2016-05-05 20:55:22",
"balance_change": 22272
},
{
"block_id": 410400,
"hash": "60b0512e878085d718328b8593b9aeeb50ae2313660359be4ad6b7a3ae9ad6c3",
"time": "2016-05-05 20:55:22",
"balance_change": 22272
},
{
"block_id": 410400,
"hash": "6f57d4621919f424a26b097d0f6ac17528c7d9c2519dad5df293af3ff94a6f6b",
"time": "2016-05-05 20:55:22",
"balance_change": 22272
},
{
"block_id": 410400,
"hash": "91367b3361443bedc0b8f1dd45c6d9fb62ebc9c6b23858cffe155c14c080ea78",
"time": "2016-05-05 20:55:22",
"balance_change": 22302
},
{
"block_id": 410400,
"hash": "41955ccca5522135e14821efeea6b3f4642ca1af24fac8fe59bd0c3cc098ec0b",
"time": "2016-05-05 20:55:22",
"balance_change": 22272
},
{
"block_id": 410400,
"hash": "23512a72fddd90e7c0e74cfbe3d7cf8240a1785db967062fe5ed00ae93eb0287",
"time": "2016-05-05 20:55:22",
"balance_change": 22272
},
{
"block_id": 410400,
"hash": "43962be4fb4bcdd4a20417b9221383228baee5c3db95293cfcc47f3e5d7c00f7",
"time": "2016-05-05 20:55:22",
"balance_change": 22272
},
{
"block_id": 410400,
"hash": "93a1c16f721c001190d8ee686efa80c534938d2ee8b49c98454365f56ecfa3fa",
"time": "2016-05-05 20:55:22",
"balance_change": 22302
},
{
"block_id": 410399,
"hash": "c154aedf3df6f980def3aa25742ae4d176f32c74d43c297cd180e631a1a26f8d",
"time": "2016-05-05 20:50:21",
"balance_change": 22302
},
{
"block_id": 410399,
"hash": "abb898accecb2d066ca772b9b79cdc2140cf2a6efe9e050b6e6eef277007f9f8",
"time": "2016-05-05 20:50:21",
"balance_change": 22273
},
{
"block_id": 410399,
"hash": "dfabb8ce324b16d78f8aa5d66adcfdf823e64c366eb96e7620ad4f02af25dab2",
"time": "2016-05-05 20:50:21",
"balance_change": 22273
},
{
"block_id": 410399,
"hash": "3f7b8ac6e15cd416e739400cf3bae34c97a8d9df153364ae2b6e4974ff514621",
"time": "2016-05-05 20:50:21",
"balance_change": 22274
},
{
"block_id": 410399,
"hash": "d2c03b8a2c595674a842a8feced896a150d9dc592c91ff23aa90c82ecd643c0e",
"time": "2016-05-05 20:50:21",
"balance_change": 22302
},
{
"block_id": 410399,
"hash": "63c9f255d218b88829582b08a32b84c41b2ba3eacdd38d7ecc883583685bdef9",
"time": "2016-05-05 20:50:21",
"balance_change": 22273
},
{
"block_id": 410399,
"hash": "c4cbda5ea11c056dd08553c11be4c36b64bf458ad3cdad525d03ad9e0295ad50",
"time": "2016-05-05 20:50:21",
"balance_change": 22273
},
{
"block_id": 410335,
"hash": "e73a45c936d2ce195f13b5a715614f7d10f94ff7a6593dc24fcf98bf173941eb",
"time": "2016-05-05 10:26:21",
"balance_change": 11189900
},
{
"block_id": 410203,
"hash": "d87ca44bedbba2107a0f8ef732a8ca3857db1754541e99970ce67da9e29d19ee",
"time": "2016-05-04 14:41:54",
"balance_change": 1701000
},
{
"block_id": 410201,
"hash": "85bd6e073db458fcc2a1b7f17d7c3ce2b80001f88c2bcd63e491f8488d250dba",
"time": "2016-05-04 14:06:11",
"balance_change": 1090000
},
{
"block_id": 410055,
"hash": "8dd5bd5f6226f15adc1c0d94afcac45c59314d606616ef805699ed73167502fc",
"time": "2016-05-03 17:20:33",
"balance_change": 10000
},
{
"block_id": 410033,
"hash": "0fc8aa8f0cf52bae75c17167ad438a6e9a6f9c72b35991d6a5efbc9a050b6d60",
"time": "2016-05-03 13:39:52",
"balance_change": 11000000
},
{
"block_id": 409857,
"hash": "5d607ae88c2caf1329e758ccb1eb8a359f6df434ee84e03b9e14cea300a85f97",
"time": "2016-05-02 10:07:57",
"balance_change": 66600
},
{
"block_id": 228208,
"hash": "20fb69a94413637cb50f65e473f91d2599a04d5a0bf9bf6a5e9e843df2710ea4",
"time": "2013-03-27 06:22:50",
"balance_change": 30000
},
{
"block_id": 220151,
"hash": "1554a02d4eb1c7a73e3736922ed99530e360784e709896c42e5756e65b2da341",
"time": "2013-02-08 05:00:43",
"balance_change": 1
},
{
"block_id": 248,
"hash": "828ef3b079f9c23829c56fe86e85b4a69d9e06e5b54ea597eef5fb3ffef509fe",
"time": "2009-01-12 20:04:20",
"balance_change": -1000000000
},
{
"block_id": 183,
"hash": "12b5633bad1f9c167d523ad1aa1947b2732a865bf5414eab2f9e5ae5d5c191ba",
"time": "2009-01-12 06:34:22",
"balance_change": -100000000
},
{
"block_id": 182,
"hash": "591e91f809d716912ca1d4a9295e70c3e78bab077683f79350f101da64588073",
"time": "2009-01-12 06:12:16",
"balance_change": -100000000
},
{
"block_id": 181,
"hash": "a16f3ce4dd5deb92d98ef5cf8afeaf0775ebca408f708b2146c4fb42b41e14be",
"time": "2009-01-12 06:02:13",
"balance_change": -1000000000
},
{
"block_id": 170,
"hash": "f4184fc596403b9d638783cf57adfe4c75c605f6356fbc91338530e9831e9e16",
"time": "2009-01-12 03:30:25",
"balance_change": -1000000000
},
{
"block_id": 9,
"hash": "0437cd7f8525ceed2324359c2d0ba26006d92d856a9c20fa0241106ee5a597c9",
"time": "2009-01-09 03:54:39",
"balance_change": 5000000000
}
],
"utxo": [
{
"block_id": 677929,
"transaction_hash": "bd59cb93d6a22991a5572361e1729bc6a9489660fd847206b89fd754981b60ec",
"index": 0,
"value": 5611
},
{
"block_id": 643172,
"transaction_hash": "7cb8b3623c00e9751333bbd5f7f8aa53f36a156092fc4c4fdde239fe4213ee50",
"index": 79,
"value": 547
},
{
"block_id": 643169,
"transaction_hash": "7775a1204bc445ad9966ee0a1c9acec8115bb2cba02934e247939f83c31be469",
"index": 0,
"value": 547
},
{
"block_id": 580247,
"transaction_hash": "23c3c252d35abdeaed484bc2fbbe373701aac2776365b01692402df4c2bc85b8",
"index": 0,
"value": 10000
},
{
"block_id": 564789,
"transaction_hash": "8f716720ef9caf72149e262748e543df1fc2996cb5ae95d6cec2678dd06601ce",
"index": 1,
"value": 588
},
{
"block_id": 558860,
"transaction_hash": "ba7f6b30ee34bf9bbb6ebbbe1b1a32a01b40dc952c160a35ae7565252fa1ab1e",
"index": 1,
"value": 660619
},
{
"block_id": 550371,
"transaction_hash": "62102bcef551308d081504342083ebf35d7f082738cc510c5cd94b3f7ecb5e23",
"index": 0,
"value": 17932
},
{
"block_id": 550359,
"transaction_hash": "7b9d92b6098a1e5c11e948d9ac1dd18fb18087f6fd4864a4d0413a4345bb8bc7",
"index": 0,
"value": 20977
},
{
"block_id": 541525,
"transaction_hash": "8e8e4148332eefe195c51377d18a95f2c70972e829977d9752888ac1dd45e4ab",
"index": 1,
"value": 100000
},
{
"block_id": 529906,
"transaction_hash": "c7bd29267a338ff592209123b99e37bb8431f0b8511bd485d3d9a68c5f0bb97a",
"index": 0,
"value": 17000000
},
{
"block_id": 515394,
"transaction_hash": "ad38beebfb3f9ecc759787a69ada97c561a11e1a22355a052e5ab750774e5f8b",
"index": 0,
"value": 66593
},
{
"block_id": 496418,
"transaction_hash": "0259713cf98049818691cfa9bf8628823a3eae437e3287ce4896ad3871f65c89",
"index": 1,
"value": 2580
},
{
"block_id": 483666,
"transaction_hash": "0b49e4e83c75005c9863ab868fe7d548451f38095ac79c3304ff012a815ca451",
"index": 0,
"value": 10000
},
{
"block_id": 483210,
"transaction_hash": "ba60b4e0437562402caa17ffce31f6f62e4149986a17b8aa3bab044025763ea9",
"index": 0,
"value": 218000
},
{
"block_id": 464282,
"transaction_hash": "595cf9da27359b36196ad457acba9a409ef68f51d6cd130e5449a4f418fb62f1",
"index": 0,
"value": 80708
},
{
"block_id": 425909,
"transaction_hash": "b6bd983868e1e3944b45dd644832ece3791f86c494c679ea2a8fcd884f1b2769",
"index": 3,
"value": 50000
},
{
"block_id": 411567,
"transaction_hash": "c4b968504a34a27482bf0f1f9d9b93b74fddbf3877cfd92e2fde48c6ba8c791c",
"index": 1,
"value": 6660
},
{
"block_id": 410787,
"transaction_hash": "f5b204652306e30faa99600994482f6fc9df8ba12df3576d0833091eb8270e64",
"index": 3,
"value": 27323
},
{
"block_id": 410520,
"transaction_hash": "cafeea4014228d575610eea291de6288c2125f9ec49a078bcb221c1c30648caa",
"index": 0,
"value": 5430
},
{
"block_id": 410400,
"transaction_hash": "1d21fdbbddc8985ead4079261d9db4608f0b3cc946cb52081c5e347a9cddd63a",
"index": 1,
"value": 22272
},
{
"block_id": 410400,
"transaction_hash": "e82f85e879cba004ff6ed485a4c90b30350aa900d39327e2e37868504af74799",
"index": 1,
"value": 22272
},
{
"block_id": 410400,
"transaction_hash": "fc0bffe90fa4bb922c77ce3a9fc86742cb6bd38f57a7bf28c900c0470de5137f",
"index": 0,
"value": 22272
},
{
"block_id": 410400,
"transaction_hash": "eedbae6778bcf62f7ecd3eaa7bbabdcaf6992e9284ed2b3cc1c90f3a9fece711",
"index": 0,
"value": 22272
},
{
"block_id": 410400,
"transaction_hash": "60b0512e878085d718328b8593b9aeeb50ae2313660359be4ad6b7a3ae9ad6c3",
"index": 1,
"value": 22272
},
{
"block_id": 410400,
"transaction_hash": "6f57d4621919f424a26b097d0f6ac17528c7d9c2519dad5df293af3ff94a6f6b",
"index": 1,
"value": 22272
},
{
"block_id": 410400,
"transaction_hash": "91367b3361443bedc0b8f1dd45c6d9fb62ebc9c6b23858cffe155c14c080ea78",
"index": 0,
"value": 22302
},
{
"block_id": 410400,
"transaction_hash": "41955ccca5522135e14821efeea6b3f4642ca1af24fac8fe59bd0c3cc098ec0b",
"index": 0,
"value": 22272
},
{
"block_id": 410400,
"transaction_hash": "23512a72fddd90e7c0e74cfbe3d7cf8240a1785db967062fe5ed00ae93eb0287",
"index": 1,
"value": 22272
},
{
"block_id": 410400,
"transaction_hash": "43962be4fb4bcdd4a20417b9221383228baee5c3db95293cfcc47f3e5d7c00f7",
"index": 1,
"value": 22272
},
{
"block_id": 410400,
"transaction_hash": "93a1c16f721c001190d8ee686efa80c534938d2ee8b49c98454365f56ecfa3fa",
"index": 0,
"value": 22302
},
{
"block_id": 410399,
"transaction_hash": "c154aedf3df6f980def3aa25742ae4d176f32c74d43c297cd180e631a1a26f8d",
"index": 0,
"value": 22302
},
{
"block_id": 410399,
"transaction_hash": "abb898accecb2d066ca772b9b79cdc2140cf2a6efe9e050b6e6eef277007f9f8",
"index": 0,
"value": 22273
},
{
"block_id": 410399,
"transaction_hash": "dfabb8ce324b16d78f8aa5d66adcfdf823e64c366eb96e7620ad4f02af25dab2",
"index": 1,
"value": 22273
},
{
"block_id": 410399,
"transaction_hash": "3f7b8ac6e15cd416e739400cf3bae34c97a8d9df153364ae2b6e4974ff514621",
"index": 1,
"value": 22274
},
{
"block_id": 410399,
"transaction_hash": "d2c03b8a2c595674a842a8feced896a150d9dc592c91ff23aa90c82ecd643c0e",
"index": 0,
"value": 22302
},
{
"block_id": 410399,
"transaction_hash": "63c9f255d218b88829582b08a32b84c41b2ba3eacdd38d7ecc883583685bdef9",
"index": 0,
"value": 22273
},
{
"block_id": 410399,
"transaction_hash": "c4cbda5ea11c056dd08553c11be4c36b64bf458ad3cdad525d03ad9e0295ad50",
"index": 1,
"value": 22273
},
{
"block_id": 410335,
"transaction_hash": "e73a45c936d2ce195f13b5a715614f7d10f94ff7a6593dc24fcf98bf173941eb",
"index": 0,
"value": 11189900
},
{
"block_id": 410203,
"transaction_hash": "d87ca44bedbba2107a0f8ef732a8ca3857db1754541e99970ce67da9e29d19ee",
"index": 0,
"value": 1701000
},
{
"block_id": 410201,
"transaction_hash": "85bd6e073db458fcc2a1b7f17d7c3ce2b80001f88c2bcd63e491f8488d250dba",
"index": 3,
"value": 1090000
},
{
"block_id": 410055,
"transaction_hash": "8dd5bd5f6226f15adc1c0d94afcac45c59314d606616ef805699ed73167502fc",
"index": 0,
"value": 10000
},
{
"block_id": 410033,
"transaction_hash": "0fc8aa8f0cf52bae75c17167ad438a6e9a6f9c72b35991d6a5efbc9a050b6d60",
"index": 0,
"value": 11000000
},
{
"block_id": 409857,
"transaction_hash": "5d607ae88c2caf1329e758ccb1eb8a359f6df434ee84e03b9e14cea300a85f97",
"index": 0,
"value": 66600
},
{
"block_id": 228208,
"transaction_hash": "20fb69a94413637cb50f65e473f91d2599a04d5a0bf9bf6a5e9e843df2710ea4",
"index": 0,
"value": 30000
},
{
"block_id": 220151,
"transaction_hash": "1554a02d4eb1c7a73e3736922ed99530e360784e709896c42e5756e65b2da341",
"index": 2,
"value": 1
},
{
"block_id": 248,
"transaction_hash": "828ef3b079f9c23829c56fe86e85b4a69d9e06e5b54ea597eef5fb3ffef509fe",
"index": 1,
"value": 1800000000
}
]
}
},
"context": {
"code": 200,
"source": "D",
"limit": "100,100",
"offset": "0,0",
"results": 1,
"state": 700550,
"market_price_usd": 46816,
"cache": {
"live": true,
"duration": 30,
"since": "2021-09-14 18:11:16",
"until": "2021-09-14 18:11:46",
"time": null
},
"api": {
"version": "2.0.88",
"last_major_update": "2021-07-19 00:00:00",
"next_major_update": null,
"documentation": "https://blockchair.com/api/docs",
"notice": ":)"
},
"server": "BTC3",
"time": 1.0580081939697266,
"render_time": 0.04879498481750488,
"full_time": 1.1068031787872314,
"request_cost": 2
}
}I hope this helps.
The code below (adapted from getreceivedbyaddress() RPC) list all received transactions by an address.
I would like to list all received and sent transactions by an address.
How can this be done ?
I would like to list all received and sent transactions by an address.
How can this be done ?
Code:
std::vectortxids;
for (const std::pair& wtx_pair : wallet.mapWallet) {
const CWalletTx& wtx = wtx_pair.second;
if (wtx.IsCoinBase() || !wallet.chain().checkFinalTx(*wtx.tx) || wallet.GetTxDepthInMainChain(wtx) < min_depth) {
continue;
}
for (const CTxOut& txout : wtx.tx->vout) {
CTxDestination address;
if (ExtractDestination(txout.scriptPubKey, address) && wallet.IsMine(address) && address_set.count(address)) {
txids.push_back(wtx.GetHash());
}
}
}
Jump to: