Select
From (Get the property nodes as XML node)
xpath(
xml(json(concat('{"Root":', outputs('Output_1'),'}'))),
'/Root/*'
)
Map Key (Get the node names and decode characters that are not allowed in XML node names)
replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(
xpath(
item(),
'name(/*)'
),
'_x0020_',' '),'_x0021_','!'),'_x0023_','#'),'_x0024_','$'),'_x0025_','%'),'_x0026_','&'),'_x0027_',''''),'_x0028_','('),'_x0029_',')'),'_x002A_','*'),'_x002B_','+'),'_x002C_',','),'_x002D_','-'),'_x002E_','.'),'_x002F_','/'),'_x0030_','0'),'_x0031_','1'),'_x0032_','2'),'_x0033_','3'),'_x0034_','4'),'_x0035_','5'),'_x0036_','6'),'_x0037_','7'),'_x0038_','8'),'_x0039_','9'),'_x003A_',':'),'_x003B_',';'),'_x003C_','<'),'_x003D_','='),'_x003E_','>'),'_x003F_','?'),'_x0040_','@'),'_x005B_','['),'_x005D_',']'),'_x005E_','^'),'_x005F_','_'),'_x0060_','`'),'_x007B_','{'),'_x007C_','|'),'_x007D_','}'),'_x007E_','~')
Map Value (Get the according values from json Array B)
outputs('json_Array_B')[
first(
xpath(
item(),
'/*/text()'
)
)
]
Compose
(Convert the array from the Select into an object)
first(
json(
replace(
string(body('Select')),
'},{',
','
)
)
)
Output:
{
"1190567550": "2023-12-20T14:34:12.5453567Z",
"2016726499": "Whatever",
"-1161693587": "Whatever",
"-1526857583": "2023-12-20T14:34:12.5453567Z"
}
