Transform Map Script to get the Name of field of reference field

[Shubham Bongulw]

Hi Community,

I got the data from client were they have provided the reference of other field of the table. For example-

I have reference field as Asset which is referring to the name field of Asset Table. There is one field called serial number of which client has provided the data in sheet. I tried mapping and tried transform map script as well using gliderecord as below-

var gr= new GlideRecord('x_asset'); //x_asset is asset table name
gr.addEncodedQuery('serial_no='+source.serial_no.); //serial_no is serial number field in asset table
gr.query();
if(gr.next())
{
target.asset = gr.name;   
target.update();
}

Note source field is also mapped to target field

Can someone please help me what i am missing?

[Sagar Pagar · Accepted solution]

Hi @Shubham Bongulw,

Are you updating asset reference field? try by replacing the line

target.asset = gr.getUniqueValue();

Thanks,
Sagar Pagar

[Shubham Bongulw]

Yes Sagar I am trying to update reference field. Let me try your solution.

[Shubham Bongulw]

Thankyou Sagar it worked.

[Ankur Bawiskar]

@Shubham Bongulw 

you should set the sysId of the record.