How to ingest a Flat Json like the below format into an array | Community
Skip to main content
gengaipandi03
gengaipandi03
Level 4
October 9, 2025
Question

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

  • October 9, 2025
  • 1 reply
  • 243 views

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"}]

1 reply

Devyendar
Devyendar
Level 6
October 9, 2025

@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

    gengaipandi03
    gengaipandi03Author
    Level 4
    October 10, 2025

    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"}]
    Terms & ConditionsAccessibility statement

    Loading footer...