How to check for empty field in Scripted REST API and empty record should not be inserted?

[Devi12]

Hi,

I have created a Scripted REST API to insert data from 3rd party to ServiceNow Vendor Contact table.

I got another requirement to check for the "first name", "last name" and "email" which should not be empty. If these fields are empty then that record should not be inserted. How can I check for empty values of above fields and stop inserting the record if these fields are empty.

Here is the script I am using for inserting and updating the record into Vendor Contact table. Where I need to use the condition for filtering empty field values?

Thanks in advance!

[palanikumar]

Hi,

Can you please share the script. 

Thank you,

Palani

[Devi12]

This is the script:

(function process( /*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {
    var reqdata = request.body.data;
    var parsedData = reqdata;
    gs.info('parseddata ' + parsedData);
    var vendorGr = new GlideRecord('vm_vdr_contact');
    vendorGr.addQuery('name', parsedData.name);
    vendorGr.query();
    gs.info('vendor name', +parsedData.name);
    if (vendorGr.next()) {
        vendorGr.name = parsedData.name;
        vendorGr.first_name = parsedData.first_name;
        vendorGr.last_name = parsedData.last_name;
        vendorGr.email = parsedData.email;
        vendorGr.update();
    } else {
        vendorGr.initialize();
        vendorGr.name = parsedData.name;
        vendorGr.first_name = parsedData.first_name;
        vendorGr.last_name = parsedData.last_name;
        vendorGr.email = parsedData.email;
        vendorGr.insert();
    }
    var body = {};
    body.sys_id = vendorGr.sys_id;
    body.success = "SUCCESS";
    response.setBody(body);

[palanikumar · Accepted solution]

You can try this code. This check whether mandatory fields are present. Else return error message and skip the operation

(function process( /*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {

    var reqdata = request.body.data;
    var parsedData = reqdata;
	// -- Below lines check whether mandatory fields has value. Else throw error and ignore operation
    var missingFields = [];
    if (!parsedData.hasOwnProperty('first_name') || parsedData.first_name == "") {
        missingFields.push("first_name");
    }
    if (!parsedData.hasOwnProperty('last_name') || parsedData.last_name == "") {
        missingFields.push("last_name");
    }
    if (!parsedData.hasOwnProperty('email') || parsedData.email == "") {
        missingFields.push("email");
    }
    if (missingFields.length > 0) {
        return new sn_ws_err.BadRequestError("Missing mandatory fields : " + missingFields.join(","));
    }
	// -- End of customization
    gs.info('parseddata ' + parsedData);
    var vendorGr = new GlideRecord('vm_vdr_contact');
    vendorGr.addQuery('name', parsedData.name);
    vendorGr.query();
    gs.info('vendor name', +parsedData.name);
    if (vendorGr.next()) {
        vendorGr.name = parsedData.name;
        vendorGr.first_name = parsedData.first_name;
        vendorGr.last_name = parsedData.last_name;
        vendorGr.email = parsedData.email;
        vendorGr.update();
    } else {
        vendorGr.initialize();
        vendorGr.name = parsedData.name;
        vendorGr.first_name = parsedData.first_name;
        vendorGr.last_name = parsedData.last_name;
        vendorGr.email = parsedData.email;
        vendorGr.insert();
    }
    var body = {};
    body.sys_id = vendorGr.sys_id;
    body.success = "SUCCESS";
    response.setBody(body);
})(request, response);

[Devi12]

Thanks Palani Kumar for your script. It is working fine and not inserting empty fields. But it is not updating the existing record, only inserting the record into "vm_vdr_contact" table. Can you help me on this as well?