0

I have a DataExtension containing a primary key that is not an email address. I'd like to use a RESTful API that allows me to insert several rows into the DataExtension in a single request (https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/postDataExtensionRowsetByKey.htm). So I've created a DataExtension that is a modified version of the example.

Thanks to @JayantDas for help with this!

JSON payload: [ { "keys":{ "mypk": "12345" }, "values":{ "Email": "[email protected]", "LastLogin": "2013-05-23T14:32:00Z", "IsActive": true, "FirstName": "John", "FollowerCount": 2, "LastName": "Smith" } }, { "keys": { "mypk": "12347" }, "values":{ "Email": "[email protected]", "LastLogin": "2018-05-23T14:32:00Z", "IsActive": false, "FirstName": "Jane", "FollowerCount": 3, "LastName": "Smythe" } } ]

Improve this question
5
  • Are you missing a comma (,) after "Email" in the values?
    – Jayant Das
    Commented Apr 5, 2018 at 22:45
  • Would also help if we saw an example of the endpoint you are using
    – Travis Naughton
    Commented Apr 5, 2018 at 23:00
  • @TravisNaughton Thanks for the comment. The endpoint was in the link I posted.
    – Mohammed Shamma
    Commented Apr 6, 2018 at 16:04
  • Updated my question with the answer.
    – Mohammed Shamma
    Commented Apr 6, 2018 at 16:10
  • Sure, I added that as an answer to be able to close this.
    – Jayant Das
    Commented Apr 6, 2018 at 16:12

1 Answer 1

Reset to default
1

The JSON payload had a missing comma(,) after Email attribute. Fixing that resolved the issue.

Improve this answer
1
  • great catch. :+1:
    – Pranay Jaiswal
    Commented Apr 6, 2018 at 16:14

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .