Hi,
I guess you need to do using scripted rest API.
Please find the sample script below. You can do similar for update as well.
Scripts:
// for insert
(function process( /*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {
var requestBody = request.body;
var requestdata = requestBody.data;
var message = "";
var arraygr = new ArrayUtil();
var obj = null;
if (requestdata instanceof Array) {
obj = requestdata[0];
} else {
obj = requestdata;
}
gs.log('REQUESTBODY:' + requestBody);
gs.log('REQUESTDATA :' +requestBody.data);
gs.log('OBJ:' +obj);
gs.log("Number :" + obj.u_number);
gs.log("Number1 :" + obj.u_state);
if(obj != null){
gs.log('ShortDescription :' + obj.u_short_description);
gs.log('Description :' + obj.u_description);
gs.log('Contact_type :' + obj.u_contact_type);
gs.log('Assignemnt Group :' + obj.assignment_group);
gs.log('Assignemnt Group1 :' + obj.getDisplayValue('assignment_group'));
}
// create the incident :
var gr = new GlideRecord('incident'); // modify your table accordingly
gr.initialize();
gr.short_description = obj.u_short_description;
gr.description = obj.u_description;
gr.contact_type = obj.u_contact_type;
gr.state = obj.U_state;
gr.category = obj.u_category;
gr.subcategory = obj.u_subcategory;
gr.assignment_group= obj.assignment_group;
gr.caller_id = obj.u_caller_id;
gr.work_notes = obj.u_work_notes;
gr.correlation_id = obj.u_number;
gr.insert();
return {
"INCNumber": gr.number, // return the number .
"Message" : message
};
})(request, response);
// For Update:
(function process( /*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {
// implement resource here
var requestBody = request.body;
var requestData = requestBody.data;
var obj = null;
var arraygr = new ArrayUtil();
if (requestData instanceof arraygr) {
obj = requestData[0];
gs.log('obj:' + obj);
} else {
obj = requestData;
}
var objnumber = obj.u_number;
if (obj != null) {
// gs.log('Number_Update' + );
//gs.log('Sysid' + obj.sysid);
//gs.log('Correlation ID:' + obj.correlation_id);
}
try {
gs.log('Enter try');
var gr = new GlideRecord('incident');
// gr.addQuery('sys_id', obj.sysid);
gr.addQuery('correlation_id', objnumber);
gs.log('object' + objnumber);
gr.query();
if(gr.next()) {
gs.log('Enter_update');
gs.log('number_update:' + gr.number);
gr.state = obj.u_state;
gr.short_description = obj.u_short_description;
gr.description = obj.u_description;
gr.work_notes = obj.u_work_notes;
gr.close_code = obj.u_close_code;
gr.close_notes = obj.u_close_notes;
//gr.correlation_id = gr.number;
gr.update();
return {
"Number":gr.number
};
}
else{
return {"Message " : "Incident is not updated"};
}
}
catch(error){}
})(request, response);
