Скачать или смотреть How to Fetch Values from JSON in Ansible Playbooks

Learn how to extract specific IP addresses from JSON data in Ansible playbooks with this step-by-step guide.
---
This video is based on the question https://stackoverflow.com/q/72050711/ asked by the user 'tzemler' ( https://stackoverflow.com/u/18980884/ ) and on the answer https://stackoverflow.com/a/72051010/ provided by the user 'Vladimir Botka' ( https://stackoverflow.com/u/6482561/ ) 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: Fetch values from json

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 Fetch Values from JSON in Ansible Playbooks

Are you new to Ansible playbooks and struggling with fetching specific values from JSON output? If you find yourself in need of extracting selective data, like IP addresses from a list of servers, you're in the right place! This guide will guide you through the process by focusing on a practical example involving F5 GTM/DNS devices.

The Problem

You want to extract all the IPs utilized by your F5 GTM/DNS devices, specifically those associated with a "bigip" product type. JSON output from your Ansible task contains multiple server entries, and your goal is to filter and list only the relevant IP addresses.

Sample JSON Output

Your initial JSON output looks something like this:

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

In this output, you want to focus only on the IPs 10.1.1.1 and 10.1.1.2 from the first server, while ignoring the second server since it falls under the "generic-host" product type.

The Solution: Filter and Fetch IPs

To achieve this, you can utilize Ansible's powerful json_query feature, which allows you to query your JSON data and retrieve specific pieces of information.

Step-by-Step Instructions

Register the Output: Ensure you have already registered the output from your Ansible task into a variable. In your case, let's assume it is stored in out.

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

Use set_fact with json_query: To extract the desired IP addresses, you can write a task that uses set_fact along with json_query.

Here’s how it looks:

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

This query does the following:

Filters the gtm_servers array to include only elements where the product is bigip.

Extracts the IP addresses from the nested addresses array.

Example Output

When you run the above task, the resulting server_ips variable will contain:

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

Conclusion

By leveraging Ansible’s json_query, you can efficiently extract specific pieces of data from complex JSON structures. In this instance, we successfully pulled relevant IP addresses for "bigip" products, leaving out those associated with "generic-host" types.

Whether you are just starting with Ansible or looking to refine your playbook practices, mastering tools like json_query can significantly enhance your scripting capabilities.

Feel free to reach out if you have any further questions or need assistance with your Ansible tasks! Happy automating!