Rowset API call to a DE with required field doesn't validate correctly
Trailblazer Community

Rowset API call to a DE with required field doesn't validate correctly

Marketing Cloud Integrations , Marketing Cloud API

Last updated 2022-02-03 ·Reference W-9681358 ·Reported By 2 users

Fixed in version Marketing Cloud Release October 2021

Summary
https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/postDataExtensionRowsetByKey.htm

POST /hub/v1/dataevents/key:{key}/rowset

API request is returning 200 status even when column names in the payload do no match the column names in the DE, this can causes a scenario where the request looks to be successful but the DE never gets updated.

Repro
Data Extension with Columns
- Subscriberkey
- Name1

"keys": {
"SubscriberKey": "abc123"
},
"values": {
"Name1": "Test Test Test"

This resulted in a 200 status. The information was added to the DE.

However, if we alter the field name "Name1" to something else (that doesn't exist in the DE), such as:

"keys": {
"SubscriberKey": "abcd1234"
},
"values": {
"Name2": "Test Test Test"

It also results in a 200, however no data is added to the DE.

Workaround
At this moment we need to advise that you double check your API configuration whether it's a custom script or handled by a third party application and ensure that all columns in the payload match the targeted DE when using this endpoint.

Reported By (2)

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.