Use Adobe Experience Platform data for personalization aep-data

Open the personalization editor, which is available in every context where you can define personalization such as messages. Learn how to work with the personalization editor

Navigate to the helper functions list and add the datasetLookup helper function to the code pane.

This function provides a predefined syntax to allow you to call fields from your Adobe Experience Platform datasets. The syntax is as follows:

{{datasetLookup datasetId="datasetId" id="key" result="store" required=false}}

• datasetId is the ID of the dataset you are working with.

• id is the ID of the source column that should be joined with the primary identity of the look up dataset.

  note
  NOTE
  The value entered for this field can be either a field ID (profile.packages.packageSKU), a field passed in a journey event (context.journey.events.event_ID.productSKU), or a static value (sku007653). In any case, the system will use the value and lookup into the dataset to check if it matches a key.
  If using a literal string value for the key, keep the text in quotes. Eg: {{datasetLookup datasetId="datasetId" id="SKU1234" result="store" required=false}}. If using an attribute value as a dynamic key, remove the quotes. Eg: {{datasetLookup datasetId="datasetId" id=category.product.SKU result="SKU" required=false}}

• result is an arbitrary name that you need to provide to reference all the field values you are going to retrieve from the dataset. This value will be used in your code to call each field.

• required=false: If required is set to TRUE, the message will only be delivered if a matching key is found. If set to false, a matching key is not required and the message can still be delivered. Note that, if set to false, it is recommended that you account for fallback or default values in your message content.

Adapt the syntax to suit your needs. In this example, we want to retrieve data related to passengers’ flights. The syntax is as follows:

{{datasetLookup datasetId="1234567890abcdtId" id=profile.upcomingFlightId result="flight"}}

• We are working in the dataset whose ID is “1234567890abcdtId”,
• The field we want to use to make a join with the look up dataset is profile.upcomingFlightId,
• We want to include all the field values under the “flight” reference.

Once that the syntax to call in the Adobe Experience Platform dataset has been configured, you can specify which fields you want to retrieve. The syntax is as follows:

{{result.fieldId}}

• result is the value that you have assigned to the result parameter in the datasetLookup helper function. In this example, “flight”.

• fieldID is the ID of the field you want to retrieve. This ID is visible in Adobe Experience Platform user interface when browsing the record schema related to your dataset:

  accordion
  Where to retrieve a field ID?
  Fields IDs can be retrieved when previewing a dataset in Adobe Experience Platform user interface. Learn how to preview datasets in the Adobe Experience Platform documentation.

In this example, we want to use information related to the passengers’ boarding time and gate. We therefore add these two lines:

• {{flight._myorg.booking.boardingTime}}
• {{flight._myorg.booking.gate}}

Now that your code is ready, you can complete your content as usual, and test it using either simulation method: click Simulate content to test content variations with sample input data or AI auto-generation, or click Simulate content, then select Simulate content (AEP profiles) from the dropdown to preview with test profiles. Learn how to preview and test content