Solved
Data Prep UI - Calculated Fields - Map JSON array of objects into XDM map structure
Hey guys,
just a quick question: in a calculated field, has anyone applied an AEP data prep in the UI which transforms an incoming array of JSON objects into a new map/object structure like below?
array_to_map(items, "id") seems to only generate an object structure that gives little control over what the target structure.
Are there no "real" array functions in the source data prep? Destinations however seem to support a lot more functions like transformArray, filterArray, ....
Source structure:
{
"items": [{
"id": "12345",
"hello": "foo",
"bla": "blub"
},{
"id": "26480",
"hello": "bar",
"bla": "something else"
}]
}
Target object structure:
{
"12345_foo": {
"id": "12345",
"hello": "foo"
},
"26480_bar": {
"id": "26480",
"hello": "bar"
}
}
Thx for any input!