Reference field in transform map does not accept display name

[Alison11]

Hello,

I'm currently making a transform map to bulk upload requests - requests are already being inserted however, I need the ff requirements:

1. Link the request to an existing Incident (scoped app)
2. Get the "requested for" value from the source file (excel)

My issue now is that the transform map doesn't accept the display values from the excel file and instead only accepts it if the source value is the sys_id - which we don't want since other users won't normally get the sys_id of the records themselves.

Is this issue mainly because the reference fields are being maintained in the scoped app and my transform map is in the Global app?

Thank you in advance!

Regards,
Ali

[Harsh Vardhan]

can you add exact script which you have added and the record screenshot where it has populated ?

[Alison11]

Hello,

Here's the script:

Record created:

Linked the target variable to the variable set field included in 2nd screenshot

[Harsh Vardhan]

kindly try to use inside "run script" >> "script" field on your transform map. 

[Sudhanshu Talw1]

Hi, 

"transform map doesn't accept the display values from the excel file", so you are getting sys_id in excel,then transform should take place.

First check:

Make sure Can create & Can update be checked as well on the application access.

Try once create the field type as reference in your transform map & try.

I don't think there will be an issue of scopped as transform map will be triggered as soon as the records are inserted in import set. You are getting record in the import set.

Right?

Thanks

Sudhanshu

[MrMuhammad]

Hi,

Does your scope app has permission to create/write from another scope? You can check in the table configuration under application access. Can create and can update must be checked.

As you are getting display value of reference field in the import set, so now have you set the target field to compare with in the field map?

Thanks,

Sharjeel