OnBefore TransformScript to delete Target records

[swaroop]

Hello All,

When a record is passed using Transform Map, and if sys_id of the source record matches with Target record and if it contains all the fields empty then it should delete the target record. Can anyone suggest me how to do that.

Thanks & Regards,

S.Swaroop.

[Amit Gujarathi]

Hi Swaroop,

You have the scenario if the record is already present with the same sys_id then it should delete the record.

you can achieve by writing in the onBefore transform script , it will validate before inserting the record in the target table .

Please mark correct if its helpful.

Regards,

Amit Gujarathi

[swaroop]

Hello Amigujarathi,

Excatly, i stuck with the script. Can you help me with the Onbefore Script for validation and deletion of the record.

Thanks & Regards,

S.Swaroop.

[Ankur Bawiskar]

@swaroop 

update as this in onBefore transform script

I have taken an example of incident table and Coalesce on number field

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

    // Add your code here

var incNumber = source.u_number;

var gr = new GlideRecord('incident');

gr.addQuery('number', incNumber);

gr.query();

if(gr.next()){

// check here for all target fields are empty or not

// if yes then delete the record using gr.deleteRecord()

ignore = true;

}

else{

ignore = true;

}


})(source, map, log, target);

Regards
Ankur

[Ankur Bawiskar]

Hi,

I just shared the script.

But would like to understand the business use-case/requirement around this

Regards
Ankur