API - Upsert Row Set returns 1004 error

Question

API request to insert strings in DE returns 10004 error. As I understand it is related to incorrect usage of brackets I tried various combinations but it still does not work:

endpoint:

https://mc9jm4wv8jc5tqpqwr18x38-t7km.rest.marketingcloudapis.com/hub/v1/dataeventsasync/key:DB57888D-5E26-48DD-B954-F89523D0E315/rowset

body:

    {
        "items": [{
            "PersonId":"sampleId",
            "ActivityCode" : "sample_string",
            "ActivityDate": "12/12/12",
            "ActivitySource": "sample_string"
    }]
}

return error:

{
    "message": "JSON Deserialization Exception: Location Unknown",
    "errorcode": 10004,
    "documentation": ""
}

}

Answer 1

It looks like you are using the undocumented async version of the sync endpoint.

The async endpoint given in the documentation is: /data/v1/async/dataextensions/{id}/rows

This is the endpoint that requires the 'items' payload, like what you have.

{
        "items": [{
            "PersonId":"sampleId",
            "ActivityCode" : "sample_string",
            "ActivityDate": "12/12/12",
            "ActivitySource": "sample_string"
    }]
}

But since you are using an undocumented, but valid, endpoint (/hub/v1/dataeventsasync/key:{key}/rowset), you need to use the same payload as the sync version with 'Key" and 'Values', not 'Items'.

[
    {
        "keys":{
                "Email": "[email protected]"
                },
        "values":{
                "LastLogin": "2013-05-23T14:32:00Z",
                "IsActive": true,
                "FirstName": "John",
                "FollowerCount": 2,
                "LastName": "Smith"
                }
    },
    {
        "keys": {
                "Email": "[email protected]"
                },
        "values":{
                "LastLogin": "2013-05-23T14:32:00Z",
                "IsActive": true,
                "FirstName": "Jane",
                "FollowerCount": 2,
                "LastName": "Smith"
                }
    }
]

Once you change the payload (or the endpoint), the error goes away and it successfully inserts the records. Do note however that the returned payload on the dataeventsasync endpoint is literally an empty string (""). I assume this is because the endpoint is undocumented and therefore not officially supported/completed.

Answer 2

You are missing a closing } at the end of the request body.

You can use a JSON Formatter to validate your JSON.