Formatting IDO Updates for Syteline API

Jim Sweeney

Is it possible to update an IDO without retrieving the IDO to be updated first? I know you can configure an update using the GUID Row ID and timestamp, but I saw a working example from one of our partners that looked like this with a blank _ItemId:

{
"Changes": [
{
"Action": 2,
"_ItemId": "",
"Properties": [
{
"Name": "EmpNum",
"Value": "200776",
"Modified": false,
"IsNull": false
},
{
"Name": "Citizen",
"Value": "1",
"Modified": true,
"IsNull": false
}
],
"UpdateLocking": 0
}
]
}

But when I try this in the API Gateway Swagger interface, I get the following error:

{  "Message": "MGTransactionScope.Commit: transaction has been aborted.",  "Success": false,  "RefreshItems": null}

Can anyone tell me what is wrong? Thanks!

Jim Sweeney

With help from a development partner, I got past this error by making sure that the 7 character EmpNum property is padded with spaces to 7 characters in the update payload. It's one of those odd SyteLine requirements with an utterly cryptic error message!