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 On Jan 27, 2023, at 8:06 AM, 'Rowe, Walter P. (Fed)' via Ansible Project <[email protected]> wrote: raidurl1['json'].Members should get you Members JSON list. raidurl1 | json_query('json.Members[*][email protected]') OR raidurl1.json.Members | json_query('[*][email protected]') Walter -- Walter Rowe, Division Chief Infrastructure Services, OISM Mobile: 202.355.4123 On Jan 27, 2023, at 2:04 AM, Linux Study <[email protected]> wrote: Hi dick, Please check raidurl1 output attached. Please advice... Regards, Abhijit On Thu, 26 Jan 2023, 00:16 Dick Visser, <[email protected]<mailto:[email protected]>> wrote: 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 <[email protected]<mailto:[email protected]>> wrote: I tried earlier but no luck... Any other suggestions? On Wed, 25 Jan 2023, 19:22 'Rowe, Walter P. (Fed)' via Ansible Project, <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAEcjLFwnqUC727hEDyW%2BoAiM%2B7hCOm3sNcA-oQ54JNvvHYob6A%40mail.gmail.com<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Fansible-project%2FCAEcjLFwnqUC727hEDyW%252BoAiM%252B7hCOm3sNcA-oQ54JNvvHYob6A%2540mail.gmail.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cwalter.rowe%40nist.gov%7C24d5b33f192f48fcf89008db00676226%7C2ab5d82fd8fa4797a93e054655c61dec%7C1%7C0%7C638104216249929020%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=zbR7rs7%2BR9RJAFWc8H%2F%2F1C%2FFa3DuTEMGEyk%2BuPO80Ok%3D&reserved=0>. -- 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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/757E593A-9436-4CA5-A795-C9473E0985DA%40nist.gov<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Fansible-project%2F757E593A-9436-4CA5-A795-C9473E0985DA%2540nist.gov%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cwalter.rowe%40nist.gov%7C24d5b33f192f48fcf89008db00676226%7C2ab5d82fd8fa4797a93e054655c61dec%7C1%7C0%7C638104216249929020%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=c9YaZ1z8ggDppoVmPYhiVVzSrVVjfBj1lDtjiH0Ps4o%3D&reserved=0>. -- 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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAEcjLFxK7j3nXBXhEMZ5U8nbHGmowxhwQWCzOKv6K%2B91DKy3Ag%40mail.gmail.com<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Fansible-project%2FCAEcjLFxK7j3nXBXhEMZ5U8nbHGmowxhwQWCzOKv6K%252B91DKy3Ag%2540mail.gmail.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cwalter.rowe%40nist.gov%7C24d5b33f192f48fcf89008db00676226%7C2ab5d82fd8fa4797a93e054655c61dec%7C1%7C0%7C638104216249929020%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=oN2nD%2FfAx8RfStkziQmEQdyNHqtwbioxZn4uNzzQ1p4%3D&reserved=0>. -- Sent from Gmail Mobile -- 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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAF8BbLbUHaGnChZi6n_jC6B%2BYhwS60Ecafoc%2B%2BFRUcuDppazTQ%40mail.gmail.com<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Fansible-project%2FCAF8BbLbUHaGnChZi6n_jC6B%252BYhwS60Ecafoc%252B%252BFRUcuDppazTQ%2540mail.gmail.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cwalter.rowe%40nist.gov%7C24d5b33f192f48fcf89008db00676226%7C2ab5d82fd8fa4797a93e054655c61dec%7C1%7C0%7C638104216249929020%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=e1tjC4dGI%2BSmxQ1Oeg6SyEy13TICnz7z5CLFZjEk4R8%3D&reserved=0>. -- 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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAEcjLFxBXv41bfcEecWdZum5HWDpTGZUBn-EVUC5ZBP2w3iFGA%40mail.gmail.com<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Fansible-project%2FCAEcjLFxBXv41bfcEecWdZum5HWDpTGZUBn-EVUC5ZBP2w3iFGA%2540mail.gmail.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cwalter.rowe%40nist.gov%7C24d5b33f192f48fcf89008db00676226%7C2ab5d82fd8fa4797a93e054655c61dec%7C1%7C0%7C638104216250085270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=F7b%2BWxuQSiCS3Wv7G6t5N4nRYzCYC5l2gs%2BgXkcGvWM%3D&reserved=0>. <IMG_20230127_123227.jpg> -- 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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/0E83F61C-931B-4B93-ABD9-19555484F803%40nist.gov<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Fansible-project%2F0E83F61C-931B-4B93-ABD9-19555484F803%2540nist.gov%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cwalter.rowe%40nist.gov%7C24d5b33f192f48fcf89008db00676226%7C2ab5d82fd8fa4797a93e054655c61dec%7C1%7C0%7C638104216250085270%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=r9pcmKGD8OMJF1VqthPTT8r%2FujAo0S%2BFkSEpR65OZlg%3D&reserved=0>. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/C5F0F952-BDF8-4FFA-A43B-D865E7DC56CB%40nist.gov.
