question Re: Jolt Transformation (nested array modifications) in Support Questions

Jolt Transformation (nested array modifications)

Ibrahem — Fri, 18 Feb 2022 15:31:47 GMT

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!

Re: Jolt Transformation (nested array modifications)

araujo — Sat, 19 Feb 2022 07:07:29 GMT

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é

Re: Jolt Transformation (nested array modifications)

Ibrahem — Tue, 22 Feb 2022 11:46:43 GMT

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:

Re: Jolt Transformation (nested array modifications)

araujo — Tue, 22 Feb 2022 23:42:10 GMT

Yes, it is possible:

Re: Jolt Transformation (nested array modifications)

Ibrahem — Wed, 23 Feb 2022 07:48:32 GMT

THANK YOU SO MUCH.

It makes total sense.