Fail transform map if the reference field data does not exist

[Manikandan2]

Hi,

I have 2 tables, Service Offering and company. Company table has a reference field referencing Service Offering table. When i do a data import to the company table, if the serivce offering does not exist in the service offering table then it creates an entry in the Service offering table. The requirement is if the Service offering value does not exist in the Service Offering table then the transform map should fail and the data import should not happen to company table.

How do i achieve this?

[Varsha21]

// Add your code here

targate.addQuery('compony field service offering','source.u_bci_peer_name');

targate.query();

gs.log(targate.getRowcount());

if(targate.next()){
var ci = new glideRecord('Service offering table name');
ci.addQuery('field name from this table(ci_offer)',source.u_bci_peer_name);
ci.query();
//gs.log(ci.getRowCount()+"no of record");
if(ci.next()){

//if you want to insert data inthis table then initialize() and insert();
//ignoring that record if it is true
}

else{

ignore = true;//if Service off data is not there then it will ignore record

}

}

[Harish Murikina · Accepted solution]

Hi Manikandan,

Open the field map and set action reject.

2. If you would like to ignore entire row , write onBefore transform script .

var serviceOffering = source.getValue("please give service offering var name");

if (action == ïnsert && JSUtil.notNil(serviceOffering)) {

var serviceOfferinGr = new GlideRecord("ServiceOffering table name");

serviceOfferinGr.addQuery("Please give variable name which you would like to compare from service offering table", serviceOffering);

serviceOfferinGr.setLimit(1);

serviceOfferinGr.query();

if (!serviceOfferinGr.next()) {

ignore = true;

}

}

Regards,

Harish Murikinati.

[Manikandan2]

Thanks Harish. This solved my issue

[Harish Murikina]

Hi Manikandan,

Great to hear , have a nice day/evening.

Regards,

Harish Murikinati.

[Ishan4]

Hi Harish,

Thanks a ton. Could you please explain what is the difference between ignore vs reject.