A customer is writing its own custom web application, which should insert service call into Service desk. At the time, they are using an old one, which writes parameters correctly into SD. By looking into source code of the old application the customer has found out which parameters are necessary and how they are generated.
The problem is however the ITSM_SERVICECALLS.SER_OID field, table ITSM_SERVICECALLS.
I would therefore have two questions;
1.) What does this field mean and how can it be generated? 2.) Which other tables and are also populated, when a new service call is created ?
Any further information would be fully appreciated.
I think what George means is that the OID is determined by the system and so you shouldNOT attempt to insert a record using SQL because you cannot generate a valid OID.
But if you use the web API to create a new record then the OID will we generated in legal fashion.
Generally I would strongly recommend that if you want to write a new web front end that you get your developers to look at the web API documentation and they should be able to determine what they need to do from that.