Data Prep UI - Calculated Fields - Map JSON array of objects into XDM map structure

[bjoern__koth]

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, ....

https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/functions#special-operation...

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!

[nnakirikanti]

Hello @bjoern__koth Please check below threads and let me know if you need more details.

https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/mapping-set#iterative-opera...

https://experienceleague.adobe.com/en/docs/experience-platform/datastreams/data-prep#create-mapping

~cheers,

NN.

[bjoern__koth]

Hi @nnakirikanti 

I need this for calculated fields where the asterisk notation is not supported.

In terms of mapping sets, is this an API-only feature? By any chance, would you have an example that could work for my above transformation?

[nnakirikanti · Accepted solution]

Hello @bjoern__koth I would recommend to generate payload of requirement form upstream rather than relaying on data prep for a such contract change. 

~cheers,

NN.

[bjoern__koth]

Thx @nnakirikanti , this is likely the way it has to be done. Still feel like this puts a lot of effort on the data providing side whereas this could be easily done on AEP side. Downside of the AEP side approach mightly be performance though.