Скачать или смотреть How to Find a Value of a Non-Unique Key in JSON Using jq

Learn how to efficiently find the value of a non-unique key in JSON with `jq`, by leveraging the key's known value.
---
This video is based on the question https://stackoverflow.com/q/63903553/ asked by the user 'Invisible999' ( https://stackoverflow.com/u/6319555/ ) and on the answer https://stackoverflow.com/a/63903817/ 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 - find a value of a non-unique key when another value is known

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 Find a Value of a Non-Unique Key in JSON Using jq

Working with JSON data can often be challenging, especially when you need to locate specific values based on known criteria. Many users encounter difficulties when trying to find the value of a non-unique key, particularly when dealing with nested structures.

In this guide, we'll walk you through a common scenario involving jq, a powerful command-line tool for parsing and processing JSON data. Specifically, we’ll show you how to find the value of a specific key when you already know the value of another key.

The Problem

You might come across JSON data structured similarly to the following:

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

In this structure, each Tenant has associated attributes stored in the Body.values array. Your objective is straightforward: for a given name, retrieve its corresponding id. However, navigating through arrays and finding data based on nested conditions can be overwhelming.

The Specifics

For instance, if you want to find the id of an attribute named Attribute1 for a specific tenant, your conditions would look something like this:

Condition: When Header.Tenant is equal to "TenantX" AND Body.values[].name equals "Attribute1"

Result: Display the corresponding id.

The Solution

To solve this problem using jq, we can break down the approach into straightforward steps.

Step 1: Access the Values Array

First, access the array of objects within Body.values:

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

This command will give you all the objects within the values array, making it easier to work with individual keys.

Step 2: Select the Specific ID

Next, we want to filter these objects based on the specified name and retrieve the id. Use the following command:

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

Explanation:

.[].Body.values[]: This part allows you to look through each tenant's values.

select(.name == "Attribute1"): This filters the array down to only those objects where the name matches "Attribute1".

.id: Finally, this extracts the id corresponding to the filtered name.

Conclusion

With jq, finding the value corresponding to a non-unique key based on another key's known value can be achieved in just a couple of lines of code. Utilizing select() alongside the structured query can simplify your JSON data queries greatly.

By comprehending the hierarchical structure of your JSON and leveraging the power of jq, you can efficiently manipulate and extract the data you need.

Feel free to try this solution in your own JSON scenarios, adjusting the values as needed!