Retrieving and processing JSON data (BTC example), (Sat, Jul 14th)

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:

https://blockchain.info/multiaddr?active=…

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”

Didier Stevens
Senior handler
Microsoft MVP
blog.DidierStevens.com DidierStevensLabs.com

(c) SANS Internet Storm Center. https://isc.sans.edu Creative Commons Attribution-Noncommercial 3.0 United States License.