Remove bracket and u from json data in ansi le

[Linux Study]

Hello All,

I want remove bracket and u from json data in ansible. I am trying to retrieve data from json.

 I executed this code in playbook

- debug:

       msg: "{{ item }}"

    loop:  "{{ raidurl1 | json_query('json.Members[*].[*]') }}"

I am getting output like

(item=[[u' /refish/v1/Systems/1']])

But i want output like

 (item= /redfish/v1/Systems/1 )

How can i remove bracket and u from item. Do i need to change anything in to debug loop? Please help

Thanks and regards,

Abhi

[Rowe, Walter P. (Fed)]

Try piping thru "from_json | to_json" or just "to_json" filter. One of those worked for me. Cannot remember which one.

Walter
--
Walter Rowe, Division Chief
Infrastructure Services, OISM
Mobile: 202.355.4123

--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAEcjLFwnqUC727hEDyW%2BoAiM%2B7hCOm3sNcA-oQ54JNvvHYob6A%40mail.gmail.com.

[Linux Study]

I tried earlier but no luck... Any other suggestions?

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/757E593A-9436-4CA5-A795-C9473E0985DA%40nist.gov.

[Dick Visser]

The bracket and the u are not just some stray characters, which you seem to think. 

Your data is structured like a nested list, and that is what is being displayed. 

Adjust the json_query to remove the nested structure. 

Also you didn't post your raidurl1 data so it's mostly guessing...

On Wed, 25 Jan 2023 at 17:45, Linux Study <linux...@gmail.com> wrote:

I tried earlier but no luck... Any other suggestions?

On Wed, 25 Jan 2023, 19:22 'Rowe, Walter P. (Fed)' via Ansible Project, <ansible...@googlegroups.com> wrote:

Try piping thru "from_json | to_json" or just "to_json" filter. One of those worked for me. Cannot remember which one.

Walter
--
Walter Rowe, Division Chief
Infrastructure Services, OISM
Mobile: 202.355.4123

On Jan 25, 2023, at 2:39 AM, Linux Study <linux...@gmail.com> wrote:

Hello All,

I wantremove bracket and u from json data in ansible. I am trying to retrieve data from json.

 I executed this code in playbook

- debug:

       msg: "{{ item }}"

    loop:  "{{ raidurl1 | json_query('json.Members[*].[*]') }}"

I am getting output like

(item=[[u' /refish/v1/Systems/1']])

But i want output like

 (item= /redfish/v1/Systems/1 )

How can i remove bracket and u from item. Do i need to change anything in to debug loop? Please help

Thanks and regards,

Abhi

--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAEcjLFwnqUC727hEDyW%2BoAiM%2B7hCOm3sNcA-oQ54JNvvHYob6A%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/757E593A-9436-4CA5-A795-C9473E0985DA%40nist.gov.

--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAEcjLFxK7j3nXBXhEMZ5U8nbHGmowxhwQWCzOKv6K%2B91DKy3Ag%40mail.gmail.com.

--

Sent from Gmail Mobile

[Linux Study]

Hi dick,

 Please check raidurl1 output attached. Please advice...

Regards,

Abhijit

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAF8BbLbUHaGnChZi6n_jC6B%2BYhwS60Ecafoc%2B%2BFRUcuDppazTQ%40mail.gmail.com.

[Rowe, Walter P. (Fed)]

raidurl1['json'].Members should get you Members JSON list.

raidurl1 | json_query('json.Members[*].@odata.od')

OR

raidurl1.json.Members | json_query('[*].@odata.od')

Walter
--
Walter Rowe, Division Chief
Infrastructure Services, OISM
Mobile: 202.355.4123

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAEcjLFxBXv41bfcEecWdZum5HWDpTGZUBn-EVUC5ZBP2w3iFGA%40mail.gmail.com.
<IMG_20230127_123227.jpg>

[Rowe, Walter P. (Fed)]

https://docs.ansible.com/ansible/5/collections/community/general/docsite/filter_guide_selecting_json_data.html

Walter
--
Walter Rowe, Division Chief
Infrastructure Services, OISM
Mobile: 202.355.4123

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/0E83F61C-931B-4B93-ABD9-19555484F803%40nist.gov.

[Rowe, Walter P. (Fed)]

This is the latest documentation.

https://docs.ansible.com/ansible/latest/collections/community/general/json_query_filter.html

Walter
--
Walter Rowe, Division Chief
Infrastructure Services, OISM
Mobile: 202.355.4123

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/C5F0F952-BDF8-4FFA-A43B-D865E7DC56CB%40nist.gov.

[Linux Study]

I tried this things as well but getting error... attached screenshot

Regards, 

Abhi

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/0E83F61C-931B-4B93-ABD9-19555484F803%40nist.gov.

[Rowe, Walter P. (Fed)]

I sense it doesn't like the @ sign as part of an identifier.

Walter
--
Walter Rowe, Division Chief
Infrastructure Services, OISM
Mobile: 202.355.4123

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAEcjLFxf%2BN%2BF-t6Z9YfcghmZrHCGj%3DOmWFdcTR%3DfVnM62-PsSw%40mail.gmail.com.
<IMG_20230128_124419.jpg>