# \#json **URL:** https://forum.ansible.com/tag/json/310.md [Latest](https://forum.ansible.com/latest.md) · [Categories](https://forum.ansible.com/categories.md) · [Tags](https://forum.ansible.com/tags.md) --- ## [Are there any validated procedures for handling complex JSON structures?](https://forum.ansible.com/t/are-there-any-validated-procedures-for-handling-complex-json-structures/44590)
**Author:** [@StefanSchnell](https://forum.ansible.com/u/StefanSchnell)\ **Replies:** 3\ **Last updated:** [October 2, 2025, 5:25am UTC](https://forum.ansible.com/t/are-there-any-validated-procedures-for-handling-complex-json-structures/44590 "2025-10-02T05:25:43Z")
Hello Community :waving\_hand:, the last few days I’ve been working with HTTP requests via ansible.builtin.uri. So far this works as expected. The return value of this API call is a complex JSON structure. It looks somet… --- ## [Help with json\_query filtering](https://forum.ansible.com/t/help-with-json-query-filtering/40789)
**Author:** [@Lyle\_McKarns](https://forum.ansible.com/u/Lyle_McKarns)\ **Replies:** 10\ **Last updated:** [March 5, 2025, 3:50pm UTC](https://forum.ansible.com/t/help-with-json-query-filtering/40789 "2025-03-05T15:50:30Z")
I’m pulling some information from Active Directory and trying to use json\_query to filter it, without success. I’ve written up equivalent code and mock data that reproduces my issue. using data from here with the follow… --- ## [Json\_query/jmespath help with JSON output of ansible-playbook execution](https://forum.ansible.com/t/json-query-jmespath-help-with-json-output-of-ansible-playbook-execution/39733)
**Author:** [@iamroddo](https://forum.ansible.com/u/iamroddo)\ **Replies:** 1\ **Last updated:** [January 21, 2025, 12:52pm UTC](https://forum.ansible.com/t/json-query-jmespath-help-with-json-output-of-ansible-playbook-execution/39733 "2025-01-21T12:52:44Z")
I am looking to do some meta analysis of the execution of a playbook by setting stdout\_callback = json in ansible.cfg and analysing the output. Specifically I’d like to extract a list of tasks and whether for each host … --- ## [Insert a JSON containing double quoted Strings using SQL statment](https://forum.ansible.com/t/insert-a-json-containing-double-quoted-strings-using-sql-statment/10408)
**Author:** [@botboy](https://forum.ansible.com/u/botboy)\ **Replies:** 4\ **Last updated:** [October 29, 2024, 9:43pm UTC](https://forum.ansible.com/t/insert-a-json-containing-double-quoted-strings-using-sql-statment/10408 "2024-10-29T21:43:32Z")
I am trying to execute an Ansible play to execute a MySQL statement that inserts a JSON object where all the keys and values are Strings. However, with my current code, the resulting JSON does not have double quotes arou… --- ## [Passing password variable into API raw json giving an error and code failing](https://forum.ansible.com/t/passing-password-variable-into-api-raw-json-giving-an-error-and-code-failing/5216)
**Author:** [@ahawker](https://forum.ansible.com/u/ahawker)\ **Replies:** 2\ **Last updated:** [May 2, 2024, 2:03pm UTC](https://forum.ansible.com/t/passing-password-variable-into-api-raw-json-giving-an-error-and-code-failing/5216 "2024-05-02T14:03:55Z")
Hi, I believe I am getting the syntax wrong for passing in a variable to an API, raw json body but googling on and off for days has not helped. Hopefully someone can point me in the right direction on here. The playbook… --- ## [Playbook showing as failed but actually runs successfully](https://forum.ansible.com/t/playbook-showing-as-failed-but-actually-runs-successfully/5146)
**Author:** [@ahawker](https://forum.ansible.com/u/ahawker)\ **Replies:** 3\ **Last updated:** [April 25, 2024, 2:13pm UTC](https://forum.ansible.com/t/playbook-showing-as-failed-but-actually-runs-successfully/5146 "2024-04-25T14:13:22Z")
Hello, Created a simple playbook to add Dell iDRACs into OME (Open Manage Enterprise). The playbook runs successfully. By that I mean the device is added to OME every time I’ve tested the code. My issue is the playbook’… --- ## [Ansible module for file conversion excel to json](https://forum.ansible.com/t/ansible-module-for-file-conversion-excel-to-json/2691)
**Author:** [@deenas2108](https://forum.ansible.com/u/deenas2108)\ **Replies:** 2\ **Last updated:** [December 2, 2023, 7:45pm UTC](https://forum.ansible.com/t/ansible-module-for-file-conversion-excel-to-json/2691 "2023-12-02T19:45:46Z")
I’m looking for Ansible module for file conversion from excel to json. I cannot go with Python script, since I had to install pandas, openpyxl packages/ modules to convert files. Since we have Ansible implemented, I wou… --- ## [Ansible nested Dictionary parsing](https://forum.ansible.com/t/ansible-nested-dictionary-parsing/2594)
**Author:** [@vicks](https://forum.ansible.com/u/vicks)\ **Replies:** 2\ **Last updated:** [November 28, 2023, 1:09am UTC](https://forum.ansible.com/t/ansible-nested-dictionary-parsing/2594 "2023-11-28T01:09:07Z")
How to Parse deeply nested dictionary in Ansible to get key / value pair that is all nested inside ? My dictionary output: parser\_output": { “changed”: false, “failed”: false, “parsed”: { “isis”: { “2”: { “vrf”: { …