I have this input JSON:
[
{
"id": "05301",
"nome": "Região Metropolitana de Sorocaba",
"UF": {
"id": 35,
"sigla": "SP",
"nome": "São Paulo",
"regiao": {
"id": 3,
"sigla": "SE",
"nome": "Sudeste"
}
},
"sub-regioes-metropolitanas": [
{
"id": "0530101",
"nome": "Sub-região 1",
"municipios": [
{
"id": 3500758,
"nome": "Alambari"
},
{
"id": 3507001,
"nome": "Boituva"
},
{
"id": 3510302,
"nome": "Capela do Alto"
},
{
"id": 3511508,
"nome": "Cerquilho"
},
{
"id": 3511607,
"nome": "Cesário Lange"
},
{
"id": 3522307,
"nome": "Itapetininga"
},
{
"id": 3525854,
"nome": "Jumirim"
},
{
"id": 3551108,
"nome": "Sarapuí"
},
{
"id": 3554003,
"nome": "Tatuí"
},
{
"id": 3554508,
"nome": "Tietê"
}
]
}]},
{
"id": "05101",
"nome": "Região Metropolitana de Campinas",
"UF": {
"id": 35,
"sigla": "SP",
"nome": "São Paulo",
"regiao": {
"id": 3,
"sigla": "SE",
"nome": "Sudeste"
}
},
"sub-regioes-metropolitanas": [],
"municipios": [
{
"id": 3501608,
"nome": "Americana"
},
{
"id": 3503802,
"nome": "Artur Nogueira"
}
]
}
]
I need this output:
[ [ {
"id_rgia_mptn" : "05301",
"nome_rgia_mptn" : "Região Metropolitana de Sorocaba",
"id_sub_rgia_mptn" : "0530101",
"nome_sub_rgia_mptn" : "Sub-região 1",
"id_mcpo" : 3500758,
"id_uf" : 35,
"sgla_uf" : "SP",
"id_rgia" : 3,
"sgla_rgia" : "SE"
},
{
"id_rgia_mptn" : "05301",
"nome_rgia_mptn" : "Região Metropolitana de Sorocaba",
"id_sub_rgia_mptn" : "0530101",
"nome_sub_rgia_mptn" : "Sub-região 1",
"id_mcpo" : 3507001,
"id_uf" : 35,
"sgla_uf" : "SP",
"id_rgia" : 3,
"sgla_rgia" : "SE"
},
{
"id_rgia_mptn" : "05301",
"nome_rgia_mptn" : "Região Metropolitana de Sorocaba",
"id_sub_rgia_mptn" : "0530101",
"nome_sub_rgia_mptn" : "Sub-região 1",
"id_mcpo" : 3510302,
"id_uf" : 35,
"sgla_uf" : "SP",
"id_rgia" : 3,
"sgla_rgia" : "SE"
},
{
"id_rgia_mptn" : "05301",
"nome_rgia_mptn" : "Região Metropolitana de Sorocaba",
"id_sub_rgia_mptn" : "0530101",
"nome_sub_rgia_mptn" : "Sub-região 1",
"id_mcpo" : 3511508,
"id_uf" : 35,
"sgla_uf" : "SP",
"id_rgia" : 3,
"sgla_rgia" : "SE"
},
{
"id_rgia_mptn" : "05301",
"nome_rgia_mptn" : "Região Metropolitana de Sorocaba",
"id_sub_rgia_mptn" : "0530101",
"nome_sub_rgia_mptn" : "Sub-região 1",
"id_mcpo" : 3511607,
"id_uf" : 35,
"sgla_uf" : "SP",
"id_rgia" : 3,
"sgla_rgia" : "SE"
},
{
"id_rgia_mptn" : "05301",
"nome_rgia_mptn" : "Região Metropolitana de Sorocaba",
"id_sub_rgia_mptn" : "0530101",
"nome_sub_rgia_mptn" : "Sub-região 1",
"id_mcpo" : 3522307,
"id_uf" : 35,
"sgla_uf" : "SP",
"id_rgia" : 3,
"sgla_rgia" : "SE"
},
{
"id_rgia_mptn" : "05301",
"nome_rgia_mptn" : "Região Metropolitana de Sorocaba",
"id_sub_rgia_mptn" : "0530101",
"nome_sub_rgia_mptn" : "Sub-região 1",
"id_mcpo" : 3525854,
"id_uf" : 35,
"sgla_uf" : "SP",
"id_rgia" : 3,
"sgla_rgia" : "SE"
},
{
"id_rgia_mptn" : "05301",
"nome_rgia_mptn" : "Região Metropolitana de Sorocaba",
"id_sub_rgia_mptn" : "0530101",
"nome_sub_rgia_mptn" : "Sub-região 1",
"id_mcpo" : 3551108,
"id_uf" : 35,
"sgla_uf" : "SP",
"id_rgia" : 3,
"sgla_rgia" : "SE"
},
{
"id_rgia_mptn" : "05301",
"nome_rgia_mptn" : "Região Metropolitana de Sorocaba",
"id_sub_rgia_mptn" : "0530101",
"nome_sub_rgia_mptn" : "Sub-região 1",
"id_mcpo" : 3554003,
"id_uf" : 35,
"sgla_uf" : "SP",
"id_rgia" : 3,
"sgla_rgia" : "SE"
},
{
"id_rgia_mptn" : "05301",
"nome_rgia_mptn" : "Região Metropolitana de Sorocaba",
"id_sub_rgia_mptn" : "0530101",
"nome_sub_rgia_mptn" : "Sub-região 1",
"id_mcpo" : 3554508,
"id_uf" : 35,
"sgla_uf" : "SP",
"id_rgia" : 3,
"sgla_rgia" : "SE"
},
{
"id_rgia_mptn" : "05101",
"nome_rgia_mptn" : "Região Metropolitana de Campinas",
"id_sub_rgia_mptn" : "",
"nome_sub_rgia_mptn" : "",
"id_mcpo" : 3501608,
"id_uf" : 35,
"sgla_uf" : "SP",
"id_rgia" : 3,
"sgla_rgia" : "SE"
},
{
"id_rgia_mptn" : "05101",
"nome_rgia_mptn" : "Região Metropolitana de Campinas",
"id_sub_rgia_mptn" : "",
"nome_sub_rgia_mptn" : "",
"id_mcpo" : 3503802,
"id_uf" : 35,
"sgla_uf" : "SP",
"id_rgia" : 3,
"sgla_rgia" : "SE"
}]]
I tried with this JOLT and I didn't get the expected output:
[
{
"operation": "shift",
"spec": {
"*": {
"id": "[&1].id_rgia_mptn",
"nome": "[&1].nome_rgia_mptn",
"sub-regioes-metropolitanas": {
"*": {
"id": "[&1].id_sub_rgia_mptn",
"nome": "[&1].nome_sub_rgia_mptn",
"municipios": {
"*": {
"id": "[&3].id_mcpo"
}
}
}
},
"UF": {
"id": "[&2].id_uf",
"sigla": "[&2].sgla_uf",
"regiao": {
"id": "[&3].id_rgia",
"sigla": "[&3].sgla_rgia"
}
}
}
}
}
]
You should add more identifier those will represent the indexes of the respective arrays from different levels in order to partition more while handling the issue dynamically after labeling each group by differently(others and Main) such as
[
{
"operation": "shift",
"spec": {
"*": {
"*": "&1.others.&_rgia_mptn",
"municipios": {
"*": {
"id": "&3.Main[&1].&_mcpo"
}
},
"sub-regioes-metropolitanas": {
"*": {
"*": "&1.others.&_sub_rgia_mptn",
"municipios": {
"*": {
"id": "&3.Main[&1].id_mcpo"
}
}
}
},
"UF": {
"id": "&2.others.&_uf",
"*i*": "&2.others.&(0,1)&(0,2)_uf",
"*e*o": {
"id": "&3.others.&_&(1,1)&(1,2)",
"*i*": "&3.others.&(0,1)&(0,2)_&(1,1)&(1,2)"
}
}
}
}
},
{
"operation": "shift",
"spec": {
"*": {
"Main": {
"*": {
"@2,others": {
"*": "&4_&2.&"
}, // go two levels up the tree to grab the values of the "others" array
"*": "&3_&1.&"
}
}
}
}
},
{ // get rid of the object keys
"operation": "shift",
"spec": {
"*": ""
}
}
]