Forgive the noob question. I am new to Ansible. I am attempting to filter the json results of my playbook to only get specific information. Looking at the Ansible documentation, it is possible using community.general.json_query. It appears to work on some of the data but I am unable to come up with the correct syntax for what I need. Below is some sample output along with a snippet of my code. Please help me with the correct syntax. Thanks!
I am trying to get only the value of “author”.
My code snippet:
- name:
ansible.builtin.debug:
var: item
loop: “{{ results | community.general.json_query(‘json.body[*].book_details’) }}”
Sample json output:
“ansible_loop_var”: “item”,
“item”: {
“asterisk”: 0,
“bestsellers_date”: “2016-12-31”,
“book_details”: [
{
“age_group”: “”,
“amazon_product_url”: “https://www.amazon.com/Undoing-Project-Friendship-Changed-Minds-ebook/dp/B01GI6S7EK?tag=NYTBSREV-20”,
“author”: “Michael Lewis”,
“book_image”: “https://storage.googleapis.com/du-prd/books/images/9780393254600.jpg”,
“book_uri”: “nyt://book/5ecd45ad-8552-5f5f-8d7b-6ab0bb3bf624”,
“contributor”: “by Michael Lewis”,
“contributor_note”: “”,
“description”: “How the psychologists Daniel Kahneman and Amos Tversky upended assumptions about the decision-making process and invented the field of behavioral economics. Their close friendship and porous collaboration style became one of the greatest partnerships in the history of science.”,
“price”: “0.00”,
“primary_isbn10”: “0393254593”,
“primary_isbn13”: “9780393254594”,
“publisher”: “Norton”,
“title”: “THE UNDOING PROJECT”
}
],
