CCCPaste

Parsing User JSON Data to CSV

#get csv2json script here:
# https://pastebin.com/qZc1V5Nm

wget -qO- "https://randomuser.me/api/?nat=us&results=100&format=csv"  > users.csv
csv2json -i users.csv -o users.json -f pretty

cut -d\, -f1,2,3,7 users.csv

jq -r '.[]|(.phone+","+.email+","+."dob.age")' users.json
jq -r '.[]|(.phone+"|"+.email+"|"+."dob.age")' users.json

jq -r '.[]|(."name.first"+","+."name.last"+","+."dob.age"+","+.phone)' users.json
jq -r '.[]|"\(."name.first"),\(."name.last"),\(."dob.age"), \(.phone)"' users.json