Data prep for AA List eVar to custom schema field

[josh1975]

Hi,

Working on Analytics Data Connector (ADC) to import data from AA to AEP Dataset/CJA. We need to map some of the fields to our custom XDM schema fields in the ADC Data Prep, including the List Variables in AA.

List Props are easy, as they are in the form of string array, which can be assigned to our custom string array field directly.

But for the List eVar, they are in the form of object array, and we still have no luck on how to transform the values to our string array.

Tried to put the source field as below, but it doesn't work

_experience.analytics.customDimensions.lists.list1.list[*].value 

Also studied the data prep functions, but still cannot figure out a way.

I think what we need to do is to map below sample,

[{"key":"","value":"peter"},{"key":"","value":"paul"},{"key":"","value":"mary"}]

to

["peter","paul","mary"]

Anyone can share their experience please?

Thanks

[John_Man]

Hi @josh1975 

Based on our experience, using the following as the source field should be able to return an array of string for the list of values, and use it to assign to a custom string array field.

_experience.analytics.customDimensions.lists.list1.list[*].value 

Thanks,

John