Given simplified data for testing
nsadc:
- id: "1042"
ipaddress: "10.162.5.120"
- id: "1050"
ipaddress: "10.162.5.250"
Q: "Loop to get the record for a specific ID."
A: Put the query into a variable. This will simplify the quoting and escaping. For example
- debug:
msg: "{{ nsadc|json_query(query) }}"
loop: ["1042", "1050", "9999"]
vars:
query: "[?id == '{{ item }}']"
gives
ok: [localhost] => (item=1042) => {
"msg": [
{
"id": "1042",
"ipaddress": "10.162.5.120"
}
]
}
ok: [localhost] => (item=1050) => {
"msg": [
{
"id": "1050",
"ipaddress": "10.162.5.250"
}
]
}
ok: [localhost] => (item=9999) => {
"msg": []
}
- The attribute id is not an integer
- debug:
msg: "{{ nsadc.0.id|type_debug }}"
gives
"msg": "AnsibleUnicode"
An integer is declared without quotes. For example
id: 1042
would give
"msg": "int"
Q: "Jinja template error"
{% set query = '[?id == '{{ item_0.id }}']' %}
A: If you insist on creating the query in Jinja then the string must be concatenated. For example
- debug:
msg: >-
{% set query = "[?id == '" ~ item_0.id ~ "']" %}
{{ nsadc|json_query(query) }}
vars:
item_0:
id: "1042"
gives
"msg": " [{'id': '1042', 'ipaddress': '10.162.5.120'}]"
Dear Vladimir! Many thanks for Your prompt answer. I have tried placing the item between double curly braces, but when I try to run it, I'm still getting error message: template error while templating string: expected token 'end of statement block', got '{'. Is the mentioned method valid also when using json_query in a Jinja file? {% set query = '[?bind_vlan_id == '{{ item_0.add_vlan_id }}']' %} {% if (nsadc_config_file_textfsm_nsadc_vlan_binding_parsed | json_query(query)) %}
You're welcome. I've added a Jinja example. Open new question if you have other issues.
Works perfectly! Thank You very much, Vladimir!