jqでREST APIの結果を整形する

以下のデータをExcelで扱いやすいようにCSVライクに抽出する。

$ head parent_product_groups.json 
{"rows":[
{"key":["Apparel","B00062WSNO"],"value":6},
{"key":["Apparel","B000BKP2E8"],"value":3},
{"key":["Apparel","B000BRCYT2"],"value":1},
{"key":["Apparel","B000BRGWYK"],"value":3},
{"key":["Apparel","B000BRGY0W"],"value":2},
{"key":["Apparel","B000BRH0CS"],"value":5},
{"key":["Apparel","B000BRJYGI"],"value":1},
{"key":["Apparel","B000BRK3T0"],"value":1},
{"key":["Apparel","B000BRKSL8"],"value":1},

rows配列の要素を全て抜き出して・・・

$ cat parent_product_groups.json | jq -c '.rows[]' | head
{"value":6,"key":["Apparel","B00062WSNO"]}
{"value":3,"key":["Apparel","B000BKP2E8"]}
{"value":1,"key":["Apparel","B000BRCYT2"]}
{"value":3,"key":["Apparel","B000BRGWYK"]}
{"value":2,"key":["Apparel","B000BRGY0W"]}
{"value":5,"key":["Apparel","B000BRH0CS"]}
{"value":1,"key":["Apparel","B000BRJYGI"]}
{"value":1,"key":["Apparel","B000BRK3T0"]}
{"value":1,"key":["Apparel","B000BRKSL8"]}
{"value":1,"key":["Apparel","B000BRLD58"]}

邪魔なkeyとvalueを削除。

$ cat parent_product_groups.json | jq -c '.rows[] | .key[], .value' | head
"Apparel"
"B00062WSNO"
6
"Apparel"
"B000BKP2E8"
3
"Apparel"
"B000BRCYT2"
1

CSVっぽくしたいので、keyとvalueの値をひとつの配列にする。

$ cat parent_product_groups.json | jq -c '.rows[] | [.key[], .value]'
["Apparel","B00062WSNO",6]
["Apparel","B000BKP2E8",3]
["Apparel","B000BRCYT2",1]
["Apparel","B000BRGWYK",3]
["Apparel","B000BRGY0W",2]
["Apparel","B000BRH0CS",5]
["Apparel","B000BRJYGI",1]
["Apparel","B000BRK3T0",1]
["Apparel","B000BRKSL8",1]
["Apparel","B000BRLD58",1]

tr -d "[]" で配列の括弧を除去すれば完成。