How to integrate with Salesforce Marketing Cloud to Push to a Data Extension (Advanced Method)

If you are setting up a Digioh integration by yourself, we first recommend reading about Digioh Integration Basics.

Using Digioh’s Salesforce Marketing Cloud integration, 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 the “Integrations” tab in your Digioh account and select “Salesforce Marketing Cloud” from the drop-down. Enter the information you collected in Step 3 and build out the payload based on your fields in the Data Extension. If you send us the field names inside the data extension (a screenshot will do), as well as the other info mentioned above, we can set up the integration for you.

Here is what the End Point Looks like if the only Primary Key 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:

sample fields and json payload for a salesforce integration

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"
}
}
]
This is what it looks like in the Integrations section:

sample configuration for salesforce marketing cloud integration in digioh

 

Related Reading: