我有以下JSON格式:
"MediaContainer": {
"Metadata": [
{
"Key": "5d77682c151a60001f24bbe8",
"Image": [
{
"alt": "image",
"type": "background",
"url": "https://image.tmdb.org/t/p/original/f8Q3Sug5Sa42psw2b3Gdd1aT8t.jpg"
},
{
"alt": "image",
"type": "clearLogoWide",
"url": "http://assets.fanart.tv/fanart/movies/2639/hdmovielogo/deconstructing-harry-60f13837ee6aa.png"
},
{
"alt": "image",
"type": "coverArt",
"url": "https://metadata-static.imdb.com/4/gracenote/44a1852151a726d730c214b97986c27e.jpg"
},
{
"alt": "image",
"type": "coverPoster",
"url": "https://image.tmdb.org/t/p/original/i7Z5DdznqANJUjqWISEFu9bw6J7.jpg"
},
{
"alt": "image",
"type": "coverSquare",
"url": "https://metadata-static.imdb.com/c/gracenote/c8c351b348baf43a909e4a3b1c60a443.jpg"
},
{
"alt": "image",
"type": "snapshot",
"url": "https://metadata-static.imdb.com/a/gracenote/ab5a905958de8d43c763d74153242690.jpg"
}
],
},
我正在try 输出TSV,其中每行都包含"key"和"Image"数组中的第一个"url"值,该数组包含字符串"fan art".因此,以上面的JSON为例,我要寻找的输出是:
5d77682c151a60001f24bbe8 http://assets.fanart.tv/fanart/movies/2639/hdmovielogo/deconstructing-harry-60f13837ee6aa.png
下面是我失败的try ,它只是吐出编译错误:
jq -r '.MediaContainer.Metadata[] | [.ratingKey,.Image[] | select( .url as $items | "fanart" | IN($items[]) )] | @tsv' 'trending.json'
个