I need help in groovy script nested array

Question

I need to loop over the below Json array and transform the data into the expected output. However, I am facing problem in looping over the nested array.

input : 


   [{"DomainName":"Access Supplier",
   "Data_Category" :
  [{"Data_Category_Name":"System","Data_Category_AssetID":"2"}],
     "Data_Fields":
     [{"Field_Name":"First Name","WID":"7a"},
      {"Field_Name":"Last Name","WID":"213"}]},


  {"DomainName":"Access Talent",
"Data_Category":
  [{"Data_Category_Name":"Talent culture","Data_Category_AssetID":"54c"}],
   "Data_Fields":
  [{"Field_Name":"Key Resp","WID":"de7"},
    {"Field_Name":"Talent","WID":"043b5"}]}]

Expected Output:

  [{
"Field_Name": "First Name"
"Data_Category": [
{
 "Data_Category_AssetID": "2"
"Data_Category_Name": "System"
 }
],

"Field_Name":"Last Name"
"Data_Category": [
 {
"Data_Category_AssetID": "2"
"Data_Category_Name": "System"
 }],

 "Field_Name":"Key Resp"
 "Data_Category": [
{
"Data_Category_AssetID": "54c"
 "Data_Category_Name": "Talent culture"
   }],


  "Field_Name":"Talent"
 "Data_Category": [ 
   {
 "Data_Category_AssetID": "54c"
"Data_Category_Name": "Talent culture"
   }]



   }  ]

cfrick · Accepted Answer · 2021-01-01 20:26:04Z

1

You can use submap to copy only what you want from your Data_Fields (e.g. only Field_Name). Then assign all of those new maps the Data_Category from your source.

import groovy.json.JsonOutput

def data = ["Domain Name": "test", 
            "Data_Category":[["Data_Category_AssetID":"1","Data_Category_Name": "worker1"],
                             ["Data_Category_AssetID":"2","Data_Category_Name": "worker2"]],
            "Data_Fields":  [["WID":"1", "Field_Name":"First Name"],
                             ["WID":"2", "Field_Name":"Last Name"]]]

def allDataFields = data.Data_Fields.collect{
  it.subMap(["Field_Name"]).tap{
    Data_Category = data.Data_Category
  }
}

println(JsonOutput.prettyPrint(JsonOutput.toJson(allDataFields)))
// [
//     {
//         "Field_Name": "First Name",
//         "Data_Category": [
//             {
//                 "Data_Category_AssetID": "1",
//                 "Data_Category_Name": "worker1"
//             },
//             {
//                 "Data_Category_AssetID": "2",
//                 "Data_Category_Name": "worker2"
//             }
//         ]
//     },
//     {
//         "Field_Name": "Last Name",
//         "Data_Category": [
//             {
//                 "Data_Category_AssetID": "1",
//                 "Data_Category_Name": "worker1"
//             },
//             {
//                 "Data_Category_AssetID": "2",
//                 "Data_Category_Name": "worker2"
//             }
//         ]
//     }
// ]

answered Jan 1, 2021 at 20:26

cfrick

37.3k7 gold badges62 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

mohammmed sohail Over a year ago

Thanks, The avbove script doesnt work if we have multiple "Domain Name"

mohammmed sohail Over a year ago

input : [{"DomainName":"Access Supplier", "Data_Category" : [{"Data_Category_Name":"System","Data_Category_AssetID":"2"}], "Data_Fields": [{"Field_Name":"First Name","WID":"7a"}, {"Field_Name":"Last Name","WID":"213"}]}, {"DomainName":"Access Talent", "Data_Category": [{"Data_Category_Name":"Talent culture","Data_Category_AssetID":"54c"}], "Data_Fields": [{"Field_Name":"Key Resp","WID":"de7"}, {"Field_Name":"Talent","WID":"043b5"}]}]

mohammmed sohail Over a year ago

Expected output : [{ "Field_Name": "First Name" "Data_Category": [ { "Data_Category_AssetID": "2" "Data_Category_Name": "System" }], "Field_Name":"Last Name" "Data_Category": [ { "Data_Category_AssetID": "2" "Data_Category_Name": "System" }], "Field_Name":"Key Resp" "Data_Category": [{ "Data_Category_AssetID": "54c" "Data_Category_Name": "Talent culture" }], "Field_Name":"Talent" "Data_Category": [{ "Data_Category_AssetID": "54c" "Data_Category_Name": "Talent culture" }]}]

cfrick Over a year ago

Of course it works - it works for one element, you now just need to apply it to all your elements. If you simplify a problem, make sure, you don't simplify it so much, it no longer is your actual problem. Also if you have changes, please edit the question. And next: neither this nor the original "expected output" are valid JSON.

Collectives™ on Stack Overflow

I need help in groovy script nested array

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related