Using jq with bash to run command for each object in array

Question

How can I run a Bash command for every JSON object in a JSON array using jq? So far I have this:

cat credentials.json | jq -r '.[] | .user, .date, .email' | mycommand -u {user} -d {date} -e {email} 

This doesn't seem to work. How can I take the parameters out of the JSON array into my command?

My JSON file looks something like this:

[    "user": "danielrvt",    "date": "11/10/1988",    "email": "[email protected]",    ... ] 

Answer 1

Your best bet is probably to output each record in something like TSV format, then read that from a shell loop.

jq -r '.[]|[.user, .date, .email] | @tsv' |   while IFS=$'\t' read -r user date email; do     mycommand -u "$user" -d "$date" -e "$email"   done 

jq itself doesn't have anything like a system call to run an external command from within a filter, although it seems that they are working on it.