Skip to main content
gengaipandi03
gengaipandi03
Level 4
Oct 9, 2025 6:35 AM UTC
Question

How to ingest a Flat Json like the below format into an array

Hi, 

 

Is there any option to upload the following format to be uploaded into array object?

 

vcClientHashadhoc_object
1PhAha2uRgKsNk99BHMl[{"Updatedate":"2025-07-24","CampaignName":"MR_ETAOEA_202506_90_CS1DailyDose","Cell":"unsubscribed"}]
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Devyendar
User Group Leader
DevyendarUser Group Leader
User Group Leader
Oct 9, 2025 11:48 PM UTC

@gengaipandi0 are you converting string to array in Data Prep functions in any Source Data Flow? You can use functions such as to_array(true, "Hello", "world") to convert static to array that meets your array object structure.

Here is a list of all supported data prep functions : https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/functions

Translate
    gengaipandi03
    gengaipandi03Author
    Level 4
    Oct 10, 2025 5:00 AM UTC

    Hi, 

    VcclientHash is one column and adhoc_object is the another column where i want to separate the updatedate, campaignname and cell values into their respective fields. Can you show me the formula to do so. 

     

    vcClientHashadhoc_object
    1PhAha2uRgKsNk99BHMl[{"Updatedate":"2025-07-24","CampaignName":"MR_ETAOEA_202506_90_CS1DailyDose","Cell":"unsubscribed"}]
    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...