How to integrate with Salesforce Marketing Cloud to Push to a Data Extension

You can push data to a data extension in SFMC by following these instructions. (If you are looking to trigger a journey as well, please use these instructions)

  1. Create a Package by following these steps: Install Packages
  2. When you “Add Component” choose “API Integration” then “Sever-to-Server”: More info.
  3. After you create a Package, record this information:
    • API Endpoint URL (example: rest.marketingcloudapis.com/interactionv1/events)
    • Subdomain (example: mptq…)
    • Account ID (also referred to as MID. example: 100019327)
    • Client ID
    • Client Secret
    • the DE External Key for the Data Extension
    •  What field on the Data Extension is marked as the “Primary Key”
    • Scopes (example: email_send_journeys_read, list_and_subscribers_read, etc). Here are the scopes we must have:
      • email_send
      • journeys_read
      • ​list_and_subscribers_read
      • ​list_and_subscribers_write
      • data_extensions_read
      • data_extensions_write
  4. Click on the “Integrations” tab in your Digioh account and select “Salesforce Marketing Cloud” from the drop down. Then enter in the information you collected in Step 3 and Build out the payload based on your fields in the Data Extension. Or send us the field names inside the data extension (a screenshot will do) as well as the other info mentioned above to setup the integration for you.

Here is what the End Point Looks like if there is only one Primary Key and is it is the Email Address

https://{Subdomain}.rest.marketingcloudapis.com/hub/v1/dataevents/key:{DE External Key}/rows/{Primary Key Name}:[EMAIL]

Here is what the JSON Payload looks like if the fields are just Name, Phone and Address

{
"values":{
"Name":"[NAME]",
"Phone":"[PHONE]",
"Address":"[CUSTOM_1]"}
}

Example of another Payload for Single Primary Key Setup:

Format for the endpoint:
https://{Subdomain}.rest.marketingcloudapis.com/hub/v1/dataevents/key:{DE External Key}/rows/{Primary Key Name}:[CUSTOM_10]

Format for the payload:
{
"values":{
"LastLogin":"2013-05-23T14:32:00Z",
"IsActive":true,
"FirstName":"John",
"FollowerCount":2,
"LastName":"Smith"}
}

Here is a screenshot of the SFMC to Data Extension integration in the Digioh Platform

Multiple Primary Key Setup

Format for the endpoint:
https://{Subdomain}.rest.marketingcloudapis.com/hub/v1/dataevents/key:{DE External Key}/rowset

Format for the payload:

[
{
"keys":{
"Email": "someone@example.com",
"SubscriberId": "12345",
},
"values":{
"LastLogin": "2013-05-23T14:32:00Z",
"IsActive": true,
"FirstName": "John",
"FollowerCount": 2,
"LastName": "Smith"
}
}
]
Here is a screenshot of what it looks like in the Integrations section: