Expand my Community achievements bar.

Tuesday tech Bytes: RTCDP - Week 03 - Update specific profile attributes using upsert

Avatar

Community Advisor

7/23/24


In today’s tech byte post we will discuss how to update a specific attribute of a profile using the upsert feature of Adobe Experience Platform. 

Let’s understand the meaning of “Upsert” in Adobe Experience platform context. Typically, when you ingest a record into the Platform with just a specific attribute, it updates that attribute but sets the other attributes to null. Upsert, however, allows you to update only the desired attribute while keeping the remaining fields unchanged.

 

A good example is when one wants to update only city, state and zip code request works fine, but overwrites any other existing attributes to NULL 

The upsert feature enables the ability to update the selected attribute for a profile, here’s how you would enable it and get started 

 

Let’s have a look at how we would do this via API 

 

1. Disable dataset for profile

disable_profile.jpeg

2.Enable for Upserts & Profile

The request body includes a path to unifiedProfile setting the value to include the enabled and isUpsert tags, both set to true, and a path to unifiedIdentity setting the value to include the enabled tag set to true.

 

enable_upsert.jpeg

In the example below, the attributes such as state and homePhone.number are upserted with their respective values into the Profile associated with the primary identity sampleEmail@gmail.com

 

upsert_example.jpeg

You can refer to below documentation to read more around the feature 

https://experienceleague.adobe.com/en/docs/experience-platform/catalog/datasets/enable-upsert#enable...

https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/upserts#payload-with-identi...

 

1 Comment