Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Update Profile Attributes

DavidSlaw1
Level 1
Level 1

I create a profile schema containing some attributes that are updated with new values using an external process.  What I want to do is have the updates in a file (e.g. JSON) with the userID and the columns to update.  When I tried this simple approach, the new data does load, but the rest of the profile attributes are no longer there.  I was doing this using the Datasets UI to load more data.  What is the best way to update profile data from the UI?  API is ok as well, it is just harder to demonstrate.

1 Reply
maggod
Level 2
Level 2

What I noticed in the past is that you cannot ingest "some" columns only. If you do this, all other parts/properties of the schema will become empty/zero. It doesn't matter if you do this via API or AEP UI. Maybe you run into the same issue?

A resolution maybe to define another schema/dataset with a reduced set of properties and use this to update data. Or you need to get all existing data/columns/properties first, update the required columns and ingest the full set (non-changed and changed properties).

DavidSlaw1
Level 1
Level 1
@maggod Your solution is what I had started working on. That way each update to the subset of columns can simply replace the old record. The Real-Time profile then gets updated with the new values. I am just hoping there is a way to UPDATE a record without having to specify all the attributes and reload the record. Thank you.