Expand my Community achievements bar.

SOLVED

Creating UPSERT dataflow from DLZ into a XDM Individual Profile class schema

Avatar

Level 1

Hi everyone,

I have tried reading the documentation but it's pretty unclear how to do this.
Let me explain the situation, to put it simply, we have a XDM Individual Profile class schema, with its dataset. We need to do a partial profile update (updating one object in a profile using the primary ID). Basically the primary dataflow brings all the data except the one object which comes from this dataflow.

I updated the dataset with "isUpsert:true" to the unifiedProfile tag, but seems it still acts like create and just takes the last insert as the whole profile.

To be more specific we are uploading test data over DLZ, and should later connect the dataflow to a GCS bucket.

Thanks in advance.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hey @FlorijanGa 

 

I assume when you mentioned above you read the documentation, you referred to this link ? https://experienceleague.adobe.com/en/docs/experience-platform/catalog/datasets/enable-upsert

 

Basee on what you just mentioned, it should work except there is one thing you need to ensure. If this is an existing dataset, enabled for profile, then you would first beed to disable it for profile then set the upsert flag to true and then enable it back for profile.

 

Did you follow the above steps in order?

 

Cheers,

Abhinav

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hey @FlorijanGa 

 

I assume when you mentioned above you read the documentation, you referred to this link ? https://experienceleague.adobe.com/en/docs/experience-platform/catalog/datasets/enable-upsert

 

Basee on what you just mentioned, it should work except there is one thing you need to ensure. If this is an existing dataset, enabled for profile, then you would first beed to disable it for profile then set the upsert flag to true and then enable it back for profile.

 

Did you follow the above steps in order?

 

Cheers,

Abhinav