Marketing Cloud Upsert and Read Data Extension Rows
A 3-step recipe with Salesforce. We can help you get access.
Recipe · 3 steps
Marketing Cloud Upsert and Read Data Extension Rows
with Salesforce
Upsert rows into a Data Extension and read a page of rows back.
- Obtain an OAuth 2.0 access token using the client credentials grant for server-to-server access to the Marketing Cloud REST API.
- Insert or upsert the supplied rows into the Data Extension identified by its external key. Rows matching an existing primary key are updated.
- Read a page of rows back from the Data Extension to confirm the upserted data is present.
What you'll need to have ready
- clientId: The client ID of the Marketing Cloud installed package API integration.
- clientSecret: The client secret of the Marketing Cloud installed package API integration.
- key: The external key of the Data Extension to upsert rows into.
- rows: Array of row objects to insert or upsert. Each object contains key-value pairs matching the Data Extension column names.
- pageSize: Number of rows to read back per page.
For your developer
Arazzo workflow salesforce:manage-data-extension, 3 operations: getAccessToken → insertDataExtensionRows → getDataExtensionRows. Specs on APIs.io.