Bottom line up front
Get the most important information about the functionality in this section, and continue below to the other sections in the document for detailed information.
- For cloud storage destinations, the ability to export arrays, maps, and objects depends on your selection of the Export arrays, maps, objects toggle. Read more about it further down on the page.
- You can export arrays, maps, and objects to cloud storage destinations in
JSON
andParquet
files. For enterprise and edge personalization destinations, the exported data type isJSON
. People and prospect audiences are supported, account audiences are not. - For file-based cloud storage destinations, you can export arrays, maps, and objects to CSV files, but only by using the calculated fields functionality and concatenating them into a string by using the
array_to_string
function.
Arrays and other object types in Experience Platform
In Experience Platform, you can use XDM schemas to manage different field types. Before support for array exports was added, you were able to export simple key-value pair type fields such as strings out of Experience Platform to your desired destinations. An example of such a field that was supported for export previously is personalEmail.address
:johndoe@acme.org
.
Other field types in Experience Platform include array fields. Read more about managing array fields in the Experience Platform UI. You can now export array objects such as the example below.
organizations = [{
id: 123,
orgName: "Acme Inc",
founded: 1990,
latestInteraction: "2024-02-16"
}, {
id: 456,
orgName: "Superstar Inc",
founded: 2004,
latestInteraction: "2023-08-25"
}, {
id: 789,
orgName: 'Energy Corp',
founded: 2021,
latestInteraction: "2024-09-08"
}]
Prerequisites
Connect to a desired cloud storage destination, progress through the activation steps for cloud storage destinations and get to the mapping step. When connecting to the desired cloud destination, you must select the Export arrays, maps, objects toggle on. Get more information in the section below.
Export arrays, maps, objects toggle
When connecting to a file-based cloud storage destination, you can set the Export arrays, maps, objects toggle on or off.
Toggle this setting on to enable the export of arrays, maps, and objects to JSON or Parquet files. You can select these object types in the source field view of the mapping step when activating audiences to cloud storage destinations. However, with this setting on, you cannot use the calculated fields option to transform data on activation.
With this toggle off, you can use the calculated fields option and apply various data transformation functions when activating audiences. However, you can not export arrays, maps, and objects to JSON or Parquet files and must configure a separate destination for that purpose.