iteration - objects - Recorriendo una matriz con jq para JSON(en la línea de comando)

jq play

Question

Tengo una matriz:

[
{
"AssetId": 14462955,
"Name": "Cultural Item",
"Description": "It/u0027s... you know... an item. People love items!!!",
"AbsoluteUrl": "http://www.roblox.com/Cultural-Item-item?id=14462955",
"PriceInRobux": "300",
"PriceInTickets": "",
"Updated": "3 years ago",
"Favorited": "370 times",
"Sales": "55",
"Remaining": "",
"Creator": "ROBLOX",
"CreatorAbsoluteUrl": "http://www.roblox.com/users/1/profile",
"PrivateSales": "3 Private Sellers",
"PriceView": 1,
"BestPrice": "666,666,666",
"ContentRatingTypeID": 0,
"IsServerSideThumbnailLookupInCatalogEnabled": true,
"IsLargeItem": false,
"IsThumbnailFinal": true,
"IsThumbnailUnapproved": false,
"ThumbnailUrl": "http://t3.rbxcdn.com/cfbab57cabc6090d078c5f7af403caaa",
"BcOverlayUrl": null,
"LimitedOverlayUrl": "http://images.rbxcdn.com/793dc1fd7562307165231ca2b960b19a.png",
"DeadlineOverlayUrl": null,
"LimitedAltText": "Limited",
"NewOverlayUrl": null,
"SaleOverlayUrl": null,
"IosOverlayUrl": null,
"XboxOverlayUrl": null,
"IsTransparentBackground": false,
"AssetTypeID": 8,
"CreatorID": 1,
"CreatedDate": "//Date(1250206710313)//",
"UpdatedDate": "//Date(1340756728887)//",
"IsForSale": true,
"IsPublicDomain": false,
"IsLimited": true,
"IsLimitedUnique": false,
"MinimumMembershipLevel": 0
},
{
"AssetId": 114385498,
"Name": "Redspybot",
"Description": "How could something so conspicuous be a spy? Beats me! This item was awarded to users who redeemed a ROBLOX card from F.Y.E. in May 2013.",
"AbsoluteUrl": "http://www.roblox.com/Redspybot-item?id=114385498",
"PriceInRobux": "",
"PriceInTickets": "",
"Updated": "2 years ago",
"Favorited": "218 times",
"Sales": "0",
"Remaining": "",
"Creator": "ROBLOX",
"CreatorAbsoluteUrl": "http://www.roblox.com/users/1/profile",
"PrivateSales": "2 Private Sellers",
"PriceView": 1,
"BestPrice": "862,133,799",
"ContentRatingTypeID": 0,
"IsServerSideThumbnailLookupInCatalogEnabled": true,
"IsLargeItem": false,
"IsThumbnailFinal": true,
"IsThumbnailUnapproved": false,
"ThumbnailUrl": "http://t3.rbxcdn.com/173f5636efac35199e40740b3839b3d3",
"BcOverlayUrl": null,
"LimitedOverlayUrl": "http://images.rbxcdn.com/793dc1fd7562307165231ca2b960b19a.png",
"DeadlineOverlayUrl": null,
"LimitedAltText": "Limited",
"NewOverlayUrl": null,
"SaleOverlayUrl": null,
"IosOverlayUrl": null,
"XboxOverlayUrl": null,
"IsTransparentBackground": false,
"AssetTypeID": 8,
"CreatorID": 1,
"CreatedDate": "//Date(1367270100170)//",
"UpdatedDate": "//Date(1370113730937)//",
"IsForSale": false,
"IsPublicDomain": false,
"IsLimited": true,
"IsLimitedUnique": false,
"MinimumMembershipLevel": 0
},
{
"AssetId": 29715011,
"Name": "American Cowboy",
"Description": "...or Cowgirl! You know how to rope in some lookieloos to your America place. Yee haw! Rating prize for the July 4, 2010 Building Contest.",
"AbsoluteUrl": "http://www.roblox.com/American-Cowboy-item?id=29715011",
"PriceInRobux": "",
"PriceInTickets": "",
"Updated": "3 years ago",
"Favorited": "507 times",
"Sales": "0",
"Remaining": "",
"Creator": "ROBLOX",
"CreatorAbsoluteUrl": "http://www.roblox.com/users/1/profile",
"PrivateSales": "3 Private Sellers",
"PriceView": 1,
"BestPrice": "950,000,000",
"ContentRatingTypeID": 0,
"IsServerSideThumbnailLookupInCatalogEnabled": true,
"IsLargeItem": false,
"IsThumbnailFinal": true,
"IsThumbnailUnapproved": false,
"ThumbnailUrl": "http://t2.rbxcdn.com/972ae5b4376523dcfdfdcd16c1cef90d",
"BcOverlayUrl": null,
"LimitedOverlayUrl": "http://images.rbxcdn.com/793dc1fd7562307165231ca2b960b19a.png",
"DeadlineOverlayUrl": null,
"LimitedAltText": "Limited",
"NewOverlayUrl": null,
"SaleOverlayUrl": null,
"IosOverlayUrl": null,
"XboxOverlayUrl": null,
"IsTransparentBackground": false,
"AssetTypeID": 8,
"CreatorID": 1,
"CreatedDate": "//Date(1277767354190)//",
"UpdatedDate": "//Date(1277769099607)//",
"IsForSale": false,
"IsPublicDomain": false,
"IsLimited": true,
"IsLimitedUnique": false,
"MinimumMembershipLevel": 0
},
{
"AssetId": 98253651,
"Name": "Mahem/u0026#39;s ROBLOX Tablet",
"Description": "Winner: Mahem. ROBLOX will be in touch to redeem this prize. Void if sold, traded, or deleted.",
"AbsoluteUrl": "http://www.roblox.com/Mahems-ROBLOX-Tablet-item?id=98253651",
"PriceInRobux": "90,000",
"PriceInTickets": "",
"Updated": "3 years ago",
"Favorited": "429 times",
"Sales": "1",
"Remaining": "0",
"Creator": "ROBLOX",
"CreatorAbsoluteUrl": "http://www.roblox.com/users/1/profile",
"PrivateSales": "1 Private Sellers",
"PriceView": 1,
"BestPrice": "999,999,999",
"ContentRatingTypeID": 0,
"IsServerSideThumbnailLookupInCatalogEnabled": true,
"IsLargeItem": false,
"IsThumbnailFinal": true,
"IsThumbnailUnapproved": false,
"ThumbnailUrl": "http://t7.rbxcdn.com/1dc64223edd569ea698191c86c124928",
"BcOverlayUrl": "http://images.rbxcdn.com/4fc3a98692c7ea4d17207f1630885f68.png",
"LimitedOverlayUrl": "http://images.rbxcdn.com/d649b9c54a08dcfa76131d123e7d8acc.png",
"DeadlineOverlayUrl": null,
"LimitedAltText": "Limited Unique",
"NewOverlayUrl": null,
"SaleOverlayUrl": null,
"IosOverlayUrl": null,
"XboxOverlayUrl": null,
"IsTransparentBackground": false,
"AssetTypeID": 19,
"CreatorID": 1,
"CreatedDate": "//Date(1353368761747)//",
"UpdatedDate": "//Date(1355363144050)//",
"IsForSale": true,
"IsPublicDomain": false,
"IsLimited": false,
"IsLimitedUnique": true,
"MinimumMembershipLevel": 1
}
]

Me gustaría recorrer cada objeto de esta matriz y seleccionar el valor de cada clave llamada AssetId y AssetId console.log() . ¿Cómo haría esto usando jq para la línea de comandos?

Answer 1

La herramienta de línea de comandos jq escribe en STDOUT y / o STDERR. Si desea escribir la información de .AssetId en STDOUT, una posibilidad sería la siguiente:

jq -r ".[] | .AssetId" input.json

Salida:

14462955
114385498
29715011
98253651

Un conjuro más robusto sería:. .[] | .AssetId? .[] | .AssetId? pero su elección dependerá de lo que desee si no hay una clave llamada "AssetId".

Answer 2

También puedes hacerlo a través de este comando.

jq ".[].AssetId" input.json

Si el conjunto es como el que está en mi caso.

{
"resultCode":0,
"resultMsg":"SUCCESS",
"uniqueRefNo":"111222333",
"list":[
{
"cardType":"CREDIT CARD",
"isBusinessCard":"N",
"memberName":"Bank A",
"memberNo":10,
"prefixNo":404591
},
{
"cardType":"DEBIT CARD",
"isBusinessCard":"N",
"memberName":"Bank A",
"memberNo":10,
"prefixNo":407814
},
{
"cardType":"CREDIT CARD",
"isBusinessCard":"N",
"memberName":"Bank A",
"memberNo":10,
"prefixNo":413226
}
]
}

puede obtener el prefixNo con el siguiente comando jq.

jq ".list[].prefixNo" input.json

Para un caso más específico sobre la matriz que itera en jq puede consultar este blogpost