Authentication

Please refer to this document for a guide to authenticating Salesforce connectors.

Upsert Custom Data Extension Rows

The Salesforce Marketing Cloud connector gives you have the ability to Upsert (create or update) a batch of data extension rows.

When using the method ‘Upsert Custom Data Extension Rows’, custom fields must be provided for both the request and response objects.

You can do this is one of two ways:

If you have a sample of the JSON that will be posted you can:

  1. Click the magnifying glass icon

    monday dot com api token

  2. Paste in the sample JSON

    monday dot com api token

  3. Click ‘Generate’

Or you can add the fields manually:

  1. Click the plus icon

    monday dot com api token

  2. Enter the Field Location, Display Name, Data Type and (optionally) a Description

    monday dot com api token

  3. Click ‘Create’

Your custom fields will be created. This process should be carried out for both the request and response fields.

monday dot com api token

Important

  1. Your request object must include the property ‘keys’. This is assigned an object containing the primary key you will be using to upsert the data

  2. Your mappings must start with an array. This endpoint expects an array of objects, even if that array only contains one item

For example, if generating fields from sample JSON:

Invalid - no keys property

{
  "values: {
    "FirstName": "John",
    "LastName": "Doe"
  }
}
Invalid - no parent array

{
  "keys": {
    "EmailAddress": "test@test.com"
  },
  "values: {
    "FirstName": "John",
    "LastName": "Doe"
  }
}
Valid - keys property and parent array

[
  {
    "keys": {
      "EmailAddress": "test@test.com"
    },
    "values: {
      "FirstName": "John",
      "LastName": "Doe"
    }
  }
]

If adding fields manually, for Field Location:

Invalid - no parent array

keys.EmailAddress

Valid - property has parent array

[].keys.EmailAddress

Tags: connector
Edit me