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": "john_smith@somewhere.com", "LastLogin": "2013-05-23T14:32:00Z", "IsActive": true, "FirstName": "John", "FollowerCount": 2, "LastName": "Smith" } }, { "keys": { "mypk": "12347" }, "values":{ "Email": "jane_smith@somewhere.com", "LastLogin": "2018-05-23T14:32:00Z", "IsActive": false, "FirstName": "Jane", "FollowerCount": 3, "LastName": "Smythe" } } ]

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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.