Client Script: Getting the row from response of createInsertRequest

Hi @JuniSihombing ,

I have tested your client script with some sample data and was able to access the result in the way mentioned below. 

var startDttm = new Date();
var endDttm=startDttm+days(1);
var available = "N";
var personId = getControlValue('person', 'person_id');
var last_name = getControlValue('person', 'last_name');

if (last_name != null && last_name=='TEST')
	{
var newRec = {};
        newRec.person_id = personId;
        newRec.exception_type = "SICK";
        newRec.start_dttm = startDttm;
        newRec.end_dttm = endDttm;
        newRec.available = available;
        var personCalExceptReq = createInsertRequest('person_cal_except', newRec);
        var response = executeRequest(personCalExceptReq);

    	if (response['$type'] == 'ErrorResponse')      
          {
            displayUserToast(getMessage('cUnabletoAddCalException','Information') + personId + '  ' + response.message,'error'); 
          }
        else if (response != null)
          {
            calExceptArray = normalizeToArray(response);
            //if we have only one result from the insertion, simply add this
            var myRow = calExceptArray[0];
            alert('The Cal Except Id is: ' + myRow.item['exception_id']);
            //if we have multiple results from the insertion, then traverse through
            for(var i=0; i < size(calExceptArray); ++i)
			{
	    		var theRow = calExceptArray[i];
	    		alert('The cal except id generated from the loop is: ' + theRow.item['exception_id']);
	    	}

         }

 }

As mentioned, if your response returns only one result, then you do not need to traverse through the elements. You can simply alter your script as below

calExceptArray = normalizeToArray(response);
var myRow = calExceptArray[0];
alert('The cal except id is ' + myRow.item['exception_id']);

Hope this helps.