Скачать или смотреть How to Extract a Single Value from JSON with jq

Learn how to efficiently get specific values from JSON data using `jq`, including an example to find a UID based on a collection name.
---
This video is based on the question https://stackoverflow.com/q/73124660/ asked by the user 'servusMori' ( https://stackoverflow.com/u/5549556/ ) and on the answer https://stackoverflow.com/a/73124767/ provided by the user 'chepner' ( https://stackoverflow.com/u/1126841/ ) 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: Getting a single value from JSON using jq

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.
---
Understanding JSON Parsing with jq

When working with JSON data, it's common to need specific values for various applications, whether you’re dealing with APIs, configuration files, or data storage. One powerful tool in the command-line toolkit for processing JSON is jq. This lightweight and flexible command-line JSON processor will help you parse JSON data, extract the values you need quickly, and manipulate the data as needed.

The Challenge: Extracting a Specific Value

Let's say you have the following JSON data about collections. Imagine you want to find the user ID (uid) for a specific collection named "Collection Three":

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

You might be wondering: How can I get the uid for the collection with the name "Collection Three"? It's akin to a SQL query where you want to select a specific field based on the condition of another field, such as: SELECT uid FROM collections WHERE "name" = "Collection Three".

The Solution: Using jq to Select Values

The good news is that jq has a built-in select filter that allows you to filter items based on specific conditions. You can achieve the desired result with a concise command. Here’s how you can extract the uid for "Collection Three".

Step-by-Step Command

Open your terminal or command line where you have access to jq and your JSON file.

Enter the following command to parse the JSON array and select the specific value you need:

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

Breaking Down the Command

.collections[]: This iterates over each element in the collections array.

select(.name == "Collection Three"): This filters the results to only include the collection where the name matches "Collection Three".

.uid: This retrieves the uid field from the filtered object.

Result

Executing the command will yield the output:

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

This output is the uid that corresponds to "Collection Three".

Conclusion

In summary, jq is a powerful tool for parsing JSON data and extracting specific values with ease. The select filter is particularly useful when you need to filter based on certain criteria. With just a simple line of code, you can extract any value you need from your JSON data structure, making your data processing tasks much more efficient and effective.

With this knowledge, you can now confidently handle JSON data in your applications and automate various data extraction tasks seamlessly! Happy coding!