Fail transform map if the reference field data does not exist

Manikandan2 · ‎03-19-2019

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?

Harish Murikina · ‎03-19-2019

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.

View solution in original post

Jyoti Ranjan Se · ‎01-04-2024

i did this but still its not working . can anyone help me out