SQL Insert into UD Table view

Thanks @Aaron_Moreng we are just trying to protect people from shooting themselves in the foot

2 Likes

Completely understand :slight_smile:

1 Like

No problem: UD02 is actually our custom change log table.
The regular change log table is cumbersome to use for my project.

Anyhow I was able write to the UD02 table using REST. The following minimalist payload got me there:

{
  "Company": "SD",
  "Key1": "1605290605",      <- unix timestamp provides uniqueness
  "RowMod": "A",
  "Plant_c": "MfgSys",
  "UserID_c": "smason",
  "PartNum_c": "test123",
  "OldStatus_c": false,
  "NewStatus_c": true
}

And Mark_Wonsil was correct, this is the REST endpoint I used: https://server-name/E10Train//api/v1/Ice.BO.UD02Svc/UD02s

2 Likes

Hi,
I have a question please.
If we manage primary key by BPM, what should we put in Key1 (in the DMT Template) ?. I just posted a post against this, I was wondering if you had any answers ?
I increment Key1 in a BPM, in GetaNewUD10 more exactly, but when I upload my file to DMT, I don’t know what to put in key1 to trigger my BPM.

Here is my topic if you want answer me there since this one i old or maybe solved.

ADD RECORDS IN UD TABLE WITH DMT

Thank you