Jolt Transformation (nested array modifications)

[#1]

Hi everyone!

I hope all is well.

I have this json 

{

    "Data": {

        "ID": "09878666",

        "DATE": "2022-01-01",

        "ARRAY_ONE": [

            {

                "NAME": "test_1",

                "details": [

                    {

                        "address": "123123"

                    }

                ]

            },

            {

                "NAME": "test_2",

                "details": [

                    {

                        "address": "123123"

                    },

                    {

                        "address": "123123"

                    }

                ]

            }

        ]

    }

}

and I transformed the structure to this:

[

    {

        "ID": "09878666",

        "DATE": "2022-01-01",

        "NAME": "test_1",

        "details": [

            {

                "address": "123123"

            }

        ]

    },

    {

        "ID": "09878666",

        "DATE": "2022-01-01",

        "NAME": "test_2",

        "details": [

            {

                "address": "123123"

            },

            {

                "address": "123123"

            }

        ]

    }

]

Which is perfect except for the inner arrays, I want to flatten the array  to be like this

[

    {

        "ID": "09878666",

        "DATE": "2022-01-01",

        "NAME": "test_1",

        "details_0_adrress":"123123"

    },

    {

        "ID": "09878666",

        "DATE": "2022-01-01",

        "NAME": "test_2",

        "details_0_adrress":"123123",

        "details_1_adrress":"123123"

    }

]

Here is my spec:

[

    {

        "operation": "shift",

        "spec": {

            "Data": {

                "ARRAY_ONE": {

                    "*": {

                        "@(2,ID)": "[#2].ID",

                        "@(2,DATE)": "[#2].DATE",

                        "NAME": "[#2].NAME",

                        "details": "[#2].details"

                    }

                }

            }

        }

    }

]

I know how to flatten an array but I'm not sure how to do it using the current spec:,

What I would normally do is something like this:

{

        "operation": "shift",

        "spec": {

            "details": {

                "*": {

                    "address": "details_&1_address"

                }

            }

        }

    }

But it did not work so well.

Thank you!

[#2 · Accepted solution]

Great job getting thus far with the Jolt spec, @Ibrahem !

Here's the remaining bit:

[
  {
    "operation": "shift",
    "spec": {
      "Data": {
        "ARRAY_ONE": {
          "*": {
            "@(2,ID)": "[#2].ID",
            "@(2,DATE)": "[#2].DATE",
            "NAME": "[#2].NAME",
            "details": {
              "*": {
                "address": "[#4].detail_&1_address"
              }
            }
          }
        }
      }
    }
  }
]

Cheers,

André

[#3 · Accepted solution]

Great job getting thus far with the Jolt spec, @Ibrahem !

Here's the remaining bit:

[
  {
    "operation": "shift",
    "spec": {
      "Data": {
        "ARRAY_ONE": {
          "*": {
            "@(2,ID)": "[#2].ID",
            "@(2,DATE)": "[#2].DATE",
            "NAME": "[#2].NAME",
            "details": {
              "*": {
                "address": "[#4].detail_&1_address"
              }
            }
          }
        }
      }
    }
  }
]

Cheers,

André

[#4]

Thank you so much @araujo for the help.

Is it possible to have the new flatten array and the original array within one jolt spec?

This is the current structure 

can we change it to this:

[#5 · Accepted solution]

Yes, it is possible:

[
  {
    "operation": "shift",
    "spec": {
      "Data": {
        "ARRAY_ONE": {
          "*": {
            "@(2,ID)": "[#2].ID",
            "@(2,DATE)": "[#2].DATE",
            "NAME": "[#2].NAME",
            "details": {
              "*": {
                "address": "[#4].detail_&1_address"
              }
            },
            "@(0,details)": "[#2].details"
          }
        }
      }
    }
  }
]

[#6]

THANK YOU SO MUCH.

It makes total sense.