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 and Parquet files. For enterprise and edge personalization destinations, the exported data type is JSON. 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"
}]

In addition to arrays, you can also export maps and objects from Experience Platform to your desired cloud storage destination. Read more about maps and objects in Experience Platform.

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.

NOTE
For enterprise and edge personalization destinations, export support for map-type fields is available without the need to select an Export arrays, maps, objects toggle on. This toggle is not available or required when connecting to these types of destinations.

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.

Export arrays, maps, objects toggle shown with an on or off setting, as well as highlighting the popover.

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.