My Oracle Support Banner

REST API : Merge Records In PET Table Using "mergeIntoProfileExtension REST API Throws Error "Match Column is null" (Doc ID 2894499.1)

Last updated on SEPTEMBER 29, 2022

Applies to:

Oracle Responsys Marketing Platform Cloud Service - Version 6X to 6X [Release 6x]
Information in this document applies to any platform.

Symptoms

API "mergeIntoProfileExtension" getting errors in HTTP Response:

Changes

Here is a sample payload that failed:

{
     "recordData": {
           "fieldNames": ["EMAIL_ADDRESS", "PRIMARY", "TYPE", "AGE_RANGE", "PRODUCT_NAME", "SKU_NUMBER"],
           "records": [ ["recipientABC@outlook.com", null, null, null, null, null] ],
           "mapTemplateName": null 

     },
     "insertOnNoMatch": true,
     "updateOnMatch": "REPLACE_ALL",
     "matchColumnName1": "EMAIL_ADDRESS",
     "matchColumnName2": null
}

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.