# Parsing json outputs not returning expected results.

**URL:** <https://forum.ansible.com/t/parsing-json-outputs-not-returning-expected-results/34599>\
**Category:** Ansible Project\
**Created:** [February 10, 2021, 3:10am UTC](https://forum.ansible.com/t/parsing-json-outputs-not-returning-expected-results/34599 "2021-02-10T03:10:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Darshan\_Yamakanamard](https://avatars.discourse-cdn.com/v4/letter/d/a88e4f/32.png) [@Darshan\_Yamakanamard](https://forum.ansible.com/u/Darshan_Yamakanamard)\
**Post date:** [February 10, 2021, 3:10am UTC](https://forum.ansible.com/t/parsing-json-outputs-not-returning-expected-results/34599/1 "2021-02-10T03:10:13Z")

</div>

Hello All,

I am trying to parse JSON output and use it as a variable in a playbook. Whilst the JSON query works perfectly fine if I run it on the bash command line, but for some reason, Ansible is not parsing the JSON output as expected. The play book and play recap are available at the below URL.

[---- hosts: ora-pp user: ansible become: yes become\_method: sudo c - Pastebin.com](https://pastebin.com/0whuMdK8) – playbook

[ansible-playbook check\_updates.yml [WARNING]: Invalid characters were found in - Pastebin.com](https://pastebin.com/BqwihDwY) – play recap

In the play recap, the debug output returns a null value. msg = " "  
However, in the below screenshot from [https://jsonpath.com/](https://jsonpath.com/) which I used to test the JSON query. I am not sure if I am missing something in the playbook. I reviewed the ansible documentation but I couldn’t find any pointers. Could you please help me to achieve the expected result?

Regards,  
Darshan

 ![Screen Shot 2021-02-10 at 1.23.23 pm.png](https://us1.discourse-cdn.com/ansible/original/2X/8/8e21cd6073169ff0b8f46cf91a5521a977a366c6.png)

---

<div class="post-metadata">

**Author:** ![Dick\_Visser](https://avatars.discourse-cdn.com/v4/letter/d/d9b06d/32.png) [@Dick\_Visser](https://forum.ansible.com/u/Dick_Visser)\
**Post date:** [February 10, 2021, 5:15am UTC](https://forum.ansible.com/t/parsing-json-outputs-not-returning-expected-results/34599/2 "2021-02-10T05:15:50Z")

</div>

1. Try:

> **(attachments)**
>
> ![Screen Shot 2021-02-10 at 1.23.23 pm.png](https://us1.discourse-cdn.com/ansible/original/2X/8/8e21cd6073169ff0b8f46cf91a5521a977a366c6.png)

---

<div class="post-metadata">

**Author:** ![Darshan\_Yamakanamard](https://avatars.discourse-cdn.com/v4/letter/d/a88e4f/32.png) [@Darshan\_Yamakanamard](https://forum.ansible.com/u/Darshan_Yamakanamard)\
**Post date:** [February 10, 2021, 5:34am UTC](https://forum.ansible.com/t/parsing-json-outputs-not-returning-expected-results/34599/3 "2021-02-10T05:34:30Z")

</div>

Thank you mate. It worked. I appreciate your help on this.

Regards,  
Darshan

> **(attachments)**
>
> ![Screen Shot 2021-02-10 at 1.23.23 pm.png](https://us1.discourse-cdn.com/ansible/original/2X/8/8e21cd6073169ff0b8f46cf91a5521a977a366c6.png)