Retrieving and processing JSON data (BTC example)
Last Updated: 2018-07-14 23:04:08 UTC
by Didier Stevens (Version: 1)
This week, several handlers started to watch Bitcoin transactions, due to Johannes receiving a new type of sextortion email and I reporting on the profitability of such emails.
Rick Wanner came up with the following blockchain.info API call to retrieve data for Bitcoin addresses we want to monitor:
The addresses we want to monitor, together with their properties, appear in the JSON data.
To extract just the data we want (address and balance), I use jq, a command-line JSON processor:
curl -s https://blockchain.info/multiaddr?active=1BDmpLvmt2atwR2hLqvYfacEhR9hWwimfB%7C1Dvd7Wb72JBTbAcfTrxSJCZZuf4tsT8V72 | jq -r ".addresses | . | [.address,.final_balance/100000000] | @csv"