Update specific profile attributes using upsert
Last update: February 14, 2025
- Topics:
- Profiles
- Data Ingestion
CREATED FOR:
- Experienced
- Developer
Learn how to update a specific attribute of a profile using the upsert
feature of Adobe Experience Platform. Usually, when you ingest a record into Platform with only the specific attribute, it updates the value but also updates the other attributes with null
values. Upsert
allows you to update just the desired attribute, while allowing the remaining fields to keep their current values.
Transcript
Hello everyone, today we will be discussing how to update a profile attribute without overwriting the other attributes. Usually every time we try to ingest a record in a dataset, it overwrites the entire previous record which makes it difficult for a user to update some particular attributes. If we try to ingest the record only with the desired attribute, it updates the attribute value but also updates the remaining fields with a null value. What if we want to ingest the record in such a way that it holds the previous value for other attributes and also updates the value for the desired attribute. For that, we have an upsort feature in A8v that enables us to update the selected attribute for a profile. To enable this feature, we need to turn off profiling for the dataset where we are working on. This is the curled request that needs to be sent for the same. After profiling has been disabled, we need to send a new curled request with a new parameter that is isUpsort. Along with adding a new upsort feature, this curled request will enable profiles again for the dataset. Now, let’s try to look at the current attributes for the profile with identity namespace as 1at1.com. Go to profiles and add the required filter. Look for attributes of this profile. Let’s try to update the current age of this user to 100 without changing any other fields. Ingest the record with primary identity and desired attribute value as mentioned in this JSON file. Let’s update this JSON file to the dataset. The status shows success. Now, let’s look for the updated attributes of the user with identity namespace as 1at1.com. As you can see, the age was previously 1 which has now been updated to 100 and no other field has been overwritten. Thus, we were able to update the desired attribute for a specific value. Hope this was helpful. Please contact our support team for any further assistance on this matter. Thank you.
Previous pageDelete profiles
Next pageIntroduction to Privacy Service
Experience Platform
- Platform Tutorials
- Introduction to Platform
- A customer experience powered by Experience Platform
- Behind the scenes: A customer experience powered by Experience Platform
- Experience Platform overview
- Key capabilities
- Platform-based applications
- Integrations with Experience Cloud applications
- Key use cases
- Basic architecture
- User interface
- Roles and project phases
- Introduction to Real-Time CDP
- Getting started: Data Architects and Data Engineers
- Authenticate to Experience Platform APIs
- Import sample data to Experience Platform
- Administration
- AI Assistant
- Audiences and Segmentation
- Introduction to Audience Portal and Composition
- Upload audiences
- Overview of Federated Audience Composition
- Connect and configure Federated Audience Composition
- Create a Federated Audience Composition
- Audience rule builder overview
- Create audiences
- Use time constraints
- Create content-based audiences
- Create conversion audiences
- Create audiences from existing audiences
- Create sequential audiences
- Create dynamic audiences
- Create multi-entity audiences
- Create and activate account audiences (B2B)
- Demo of streaming segmentation
- Evaluate batch audiences on demand
- Evaluate an audience rule
- Create a dataset to export data
- Segment Match connection setup
- Segment Match data governance
- Segment Match configuration flow
- Segment Match pre-share insights
- Segment Match receiving data
- Audit logs
- Data Collection
- Collaboration
- Dashboards
- Data Governance
- Data Hygiene
- Data Ingestion
- Overview
- Batch ingestion overview
- Create and populate a dataset
- Delete datasets and batches
- Map a CSV file to XDM
- Sources overview
- Ingest data from Adobe Analytics
- Ingest data from Audience Manager
- Ingest data from cloud storage
- Ingest data from CRM
- Ingest data from databases
- Streaming ingestion overview
- Stream data with HTTP API
- Stream data using Source Connectors
- Web SDK tutorials
- Mobile SDK tutorials
- Data Lifecycle
- Destinations
- Destinations overview
- Connect to destinations
- Create destinations and activate data
- Activate profiles and audiences to a destination
- Export datasets using a cloud storage destination
- Integrate with Google Customer Match
- Configure the Azure Blob destination
- Configure the Marketo destination
- Configure file-based cloud storage or email marketing destinations
- Configure a social destination
- Activate through LiveRamp destinations
- Adobe Target and Custom Personalization
- Activate data to non-Adobe applications webinar
- Identities
- Intelligent Services
- Monitoring
- Partner data support
- Profiles
- Understanding Real-Time Customer Profile
- Profile overview diagram
- Bring data into Profile
- Customize profile view details
- View account profiles
- Create merge policies
- Union schemas overview
- Create a computed attribute
- Pseudonymous profile expirations (TTL)
- Delete profiles
- Update a specific attribute using upsert
- Privacy and Security
- Introduction to Privacy Service
- Identity data in Privacy requests
- Privacy JavaScript library
- Privacy labels in Adobe Analytics
- Getting started with the Privacy Service API
- Privacy Service UI
- Privacy Service API
- Subscribe to Privacy Events
- Set up customer-managed keys
- 10 considerations for Responsible Customer Data Management
- Elevating the Marketer’s Role as a Data Steward
- Queries and Data Distiller
- Overview
- Query Service UI
- Query Service API
- Explore Data
- Prepare Data
- Adobe Defined Functions
- Data usage patterns
- Run queries
- Generate datasets from query results
- Tableau
- Analyze and visualize data
- Build dashboards using BI tools
- Recharge your customer data
- Connect clients to Query Service
- Validate data in the datalake
- Schemas
- Overview
- Building blocks
- Plan your data model
- Convert your data model to XDM
- Create schemas
- Create schemas for B2B data
- Create classes
- Create field groups
- Create data types
- Configure relationships between schemas
- Use enumerated fields and suggested values
- Copy schemas between sandboxes
- Update schemas
- Create an ad hoc schema
- Sources
- Use Case Playbooks
- Experience Cloud Integrations
- Industry Trends