Скачать или смотреть How to Easily Extract Values from an Array of Arrays in JSON Using JQ

Discover how to efficiently retrieve specific values from nested arrays in JSON with JQ, simplifying your data manipulation tasks.
---
This video is based on the question https://stackoverflow.com/q/69480708/ asked by the user 'tomi' ( https://stackoverflow.com/u/9630404/ ) and on the answer https://stackoverflow.com/a/69482855/ provided by the user 'Benjamin W.' ( https://stackoverflow.com/u/3266847/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: JQ get data from an array of array

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Easily Extract Values from an Array of Arrays in JSON Using JQ

When working with JSON data, especially when it contains nested structures like arrays of arrays, it can become tricky to fetch specific values. If you're using JQ, this can be particularly challenging if you don’t know how to navigate through the different layers of arrays efficiently.

In this guide, we’ll walk through a specific problem: extracting desired values from a JSON structure that contains an array of arrays. We’ll also provide a clear solution that you can implement easily.

The Problem

Imagine you have the following JSON data:

[[See Video to Reveal this Text or Code Snippet]]

You want to retrieve the last value from the last array in the values property. However, when you attempt to do so using various JQ commands, you encounter errors, such as:

[[See Video to Reveal this Text or Code Snippet]]

This can be frustrating, as it’s unclear how to index correctly through the nested arrays.

The Solution

Understanding JQ Indexing

JQ is powerful, but understanding how to index arrays can be a bit tricky, especially with nested arrays. In your case, the JSON structure has an outer object, which contains several fields, including an array called result. Each element in this result array is also an object that contains a values array.

How to Extract the Value

To get to the last element of the last array in values, you can utilize negative indices, which enable you to reference elements from the end of an array. Here’s the command you should use:

[[See Video to Reveal this Text or Code Snippet]]

Breakdown of the Command:

.data: This accesses the data field from the root of your JSON.

.result[-1]: This selects the last element in the result array. Since there’s only one object in your example, this effectively targets that object.

.values[-1]: This gets the last array within the values property.

[-1]: Finally, this retrieves the last value from that array.

Example Implementation

Assuming you save your JSON data in a file called input.json, running the command above will yield:

[[See Video to Reveal this Text or Code Snippet]]

This is the value you wanted!

Conclusion

Working with nested JSON structures can be straightforward once you understand how to properly index your way through the layers using JQ. By incorporating negative indices, as demonstrated, you can efficiently extract desired values from complex datasets.

Now you have the power to manipulate JSON data more effortlessly. Practice this technique with your own JSON samples, and you’ll become proficient in no time!

Happy coding!