Hi Pavel.
I am experiencing issues with json_query() filter plugin. I am hitting
the issue as reported to upstream at:
https://github.com/ansible-collections/community.general/pull/10539
On my end the code fails as follows:
fatal: [testmachine10]: FAILED! => {"changed": false, "msg": "Task failed:
Finalization of task args for 'ansible.builtin.set_fact' failed: Error
while resolving value for 'tokens_to_deploy_transformed': The filter
plugin 'community.general.json_query' failed: JMESPathError in
json_query filter plugin:\nIn function join(), invalid type for value:
vault-test-a, expected one of: ['array-string'], received:
\"_AnsibleTaggedStr\""}
Ansible task definition looks as:
- name: transform target tokens for easier lookup
ansible.builtin.set_fact:
tokens_to_deploy_transformed: "{{
tokens_to_deploy
| json_query('[].join(`/`, [cluster, prefix])')
| zip(tokens_to_deploy | map(attribute='name'))
| map('pathjoin')
| zip(tokens_to_deploy)
| items2dict(key_name=0, value_name=1)
}}"
Diff from above GitHub pull request 10539 fixes the problem for me. See
below diff for OpenBSD port.
Index: Makefile
===================================================================
RCS file: /cvs/ports/sysutils/ansible/Makefile,v
diff -u -p -u -r1.207 Makefile
--- Makefile 17 Jul 2025 20:44:55 -0000 1.207
+++ Makefile 6 Aug 2025 15:23:01 -0000
@@ -2,6 +2,7 @@ COMMENT = radically simple IT automatio
MODPY_DISTV = 11.8.0
DISTNAME = ansible-${MODPY_DISTV}
+REVISION = 0
CATEGORIES = sysutils
@@ -22,7 +23,7 @@ RUN_DEPENDS = sysutils/ansible-core>=2.
post-install:
${INSTALL_DATA_DIR} ${PREFIX}/share/doc/ansible
${INSTALL_DATA} ${WRKSRC}/CHANGELOG-v*.rst ${PREFIX}/share/doc/ansible
- find ${PREFIX} -type f \( -name '.*' -o -name '*.orig' \) -delete
+ find ${PREFIX} -type f \( -name '.*' -o -name '*.orig' -o -name
'*.orig.port' \) -delete
find ${PREFIX} -type d \( -name '.*' -o -name changelogs \
-o -name docs -o -name tests \) -exec rm -rf {} +
Index:
patches/patch-ansible_collections_community_general_plugins_filter_json_query_py
===================================================================
RCS file:
patches/patch-ansible_collections_community_general_plugins_filter_json_query_py
diff -N
patches/patch-ansible_collections_community_general_plugins_filter_json_query_py
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++
patches/patch-ansible_collections_community_general_plugins_filter_json_query_py
6 Aug 2025 15:23:01 -0000
@@ -0,0 +1,28 @@
+# json_query: extend list of type aliases for compatibility with
ansible-core 2.19
+- https://github.com/ansible-collections/community.general/pull/10539
+
+Index: ansible_collections/community/general/plugins/filter/json_query.py
+--- ansible_collections/community/general/plugins/filter/json_query.py.orig
++++ ansible_collections/community/general/plugins/filter/json_query.py
+@@ -124,10 +124,17 @@ def json_query(data, expr):
+ 'json_query filter')
+
+ # Hack to handle Ansible Unsafe text, AnsibleMapping and AnsibleSequence
+- # See issue:
https://github.com/ansible-collections/community.general/issues/320
+- jmespath.functions.REVERSE_TYPES_MAP['string'] =
jmespath.functions.REVERSE_TYPES_MAP['string'] + ('AnsibleUnicode',
'AnsibleUnsafeText', )
+- jmespath.functions.REVERSE_TYPES_MAP['array'] =
jmespath.functions.REVERSE_TYPES_MAP['array'] + ('AnsibleSequence', )
+- jmespath.functions.REVERSE_TYPES_MAP['object'] =
jmespath.functions.REVERSE_TYPES_MAP['object'] + ('AnsibleMapping', )
++ # See issues
https://github.com/ansible-collections/community.general/issues/320
++ # and https://github.com/ansible/ansible/issues/85600.
++ jmespath.functions.REVERSE_TYPES_MAP['string'] =
jmespath.functions.REVERSE_TYPES_MAP['string'] + (
++ 'AnsibleUnicode', 'AnsibleUnsafeText', '_AnsibleTaggedStr',
++ )
++ jmespath.functions.REVERSE_TYPES_MAP['array'] =
jmespath.functions.REVERSE_TYPES_MAP['array'] + (
++ 'AnsibleSequence', '_AnsibleLazyTemplateList',
++ )
++ jmespath.functions.REVERSE_TYPES_MAP['object'] =
jmespath.functions.REVERSE_TYPES_MAP['object'] + (
++ 'AnsibleMapping', '_AnsibleLazyTemplateDict',
++ )
+ try:
+ return jmespath.search(expr, data)
+ except jmespath.exceptions.JMESPathError as e:
Index:
patches/patch-ansible_collections_community_general_tests_integration_targets_filter_json_query_tasks_main_yml
===================================================================
RCS file:
patches/patch-ansible_collections_community_general_tests_integration_targets_filter_json_query_tasks_main_yml
diff -N
patches/patch-ansible_collections_community_general_tests_integration_targets_filter_json_query_tasks_main_yml
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++
patches/patch-ansible_collections_community_general_tests_integration_targets_filter_json_query_tasks_main_yml
6 Aug 2025 15:23:01 -0000
@@ -0,0 +1,31 @@
+# json_query: extend list of type aliases for compatibility with
ansible-core 2.19
+- https://github.com/ansible-collections/community.general/pull/10539
+
+Index:
ansible_collections/community/general/tests/integration/targets/filter_json_query/tasks/main.yml
+---
ansible_collections/community/general/tests/integration/targets/filter_json_query/tasks/main.yml.orig
++++
ansible_collections/community/general/tests/integration/targets/filter_json_query/tasks/main.yml
+@@ -11,4 +11,23 @@
+ - name: Test json_query filter
+ assert:
+ that:
+- - "users | community.general.json_query('[*].hosts[].host') ==
['host_a', 'host_b', 'host_c', 'host_d']"
++ - >-
++ users | community.general.json_query('[*].hosts[].host') ==
['host_a', 'host_b', 'host_c', 'host_d']
++ - >-
++ ports | json_query("[?contains(ports, `22`)]") == [ports[0]]
++ - >-
++ ports | json_query("[?contains(rule_desc, `ssh`)]") == [ports[0]]
++ - >-
++ my_complex_data | json_query('users[?id==`1`]') ==
[my_complex_data['users'][0]]
++ vars:
++ my_complex_data:
++ users:
++ - id: 1
++ name: Alice
++ roles: ["admin", "dev"]
++ status: active
++ ports:
++ - ports: [22]
++ rule_desc: "ssh"
++ - ports: [80]
++ rule_desc: "http"
--
Regards,
Mikolaj
