question transform map script is not working in Virtual Agent forum

transform map script is not working

Community Alums — Tue, 16 Dec 2025 02:13:13 GMT

HI all ,

For the single user it is goving correct answer but for the multiple users it is giving undefined answer

Can anyone correct this script :

source.u_owner_name:- multiple user id is coming ,

return: undefined output is coming

// Transform Map Script (Single reference field: return the first matched user sys_id)

answer = (function transformEntry(source) {

var owners = source.u_owner_name;

var userIds = [];

var arr = owners.split(',');

gs.log('TM Owners tokens=' + arr.length);

for (var i = 0; i < arr.length; i++) {

var userVal = (arr[i] || '').trim();

if (!userVal) continue;

var userGR = new GlideRecord('sys_user');

userGR.addQuery('user_name', userVal);

userGR.query();

while (userGR.next()) {

userIds.push(userGR.name);

gs.log('test_123'+userIds);

return userIds.join(',') ;

}

})(source);

Re: transform map script is not working

Matthew_13 — Tue, 16 Dec 2025 02:32:18 GMT

Updated Script

This version:

Handles single or multiple users
Returns comma-separated sys_ids
Returns after all users are processed

answer = (function transformEntry(source) {

if (!source.u_owner_name)
return '';

var owners = source.u_owner_name;
var userIds = [];
var arr = owners.split(',');

gs.log('TM Owners tokens=' + arr.length);

for (var i = 0; i < arr.length; i++) {
var userVal = (arr[i] || '').trim();
if (!userVal)
continue;

var userGR = new GlideRecord('sys_user');
userGR.addQuery('user_name', userVal);
userGR.query();

if (userGR.next()) {
userIds.push(userGR.sys_id.toString());
gs.log('Matched user: ' + userVal);
}
}

return userIds.join(',');

})(source);

Re: transform map script is not working

Matthew_13 — Tue, 16 Dec 2025 02:33:42 GMT

Remember If your target field is a single reference field, ServiceNow will only accept one sys_id.
If it’s a List field, comma-separated sys_ids are correct.

If you tell me:

Target field type (Reference vs List)
Source value format (username, email, name)

I can tailor this exactly to your use case.

Re: transform map script is not working

Ankur Bawiskar — Tue, 16 Dec 2025 03:29:15 GMT

@Community Alums

the target field is reference or list type?

you are returning name of users

share some screenshots

Re: transform map script is not working

Community Alums — Tue, 16 Dec 2025 03:30:42 GMT

@Matthew_13 : list collector field type

Re: transform map script is not working

Community Alums — Tue, 16 Dec 2025 03:32:33 GMT

target field is list collector :list @Ankur Bawiskar

Re: transform map script is not working

Matthew_13 — Tue, 16 Dec 2025 03:38:50 GMT

Source: u_owner_name
Target: List Collector (sys_user)
Input format: user1,user2,user3

answer = (function transformEntry(source) {

if (!source.u_owner_name)
return '';

var owners = source.u_owner_name;
var userIds = [];
var arr = owners.split(',');

for (var i = 0; i < arr.length; i++) {
var userVal = (arr[i] || '').trim();
if (!userVal)
continue;

var userGR = new GlideRecord('sys_user');
userGR.addQuery('user_name', userVal); // change if using email or name
userGR.query();

if (userGR.next()) {
userIds.push(userGR.sys_id.toString());
}
}

// List Collector expects comma-separated sys_ids
return userIds.join(',');

})(source);

Re: transform map script is not working

Ankur Bawiskar — Tue, 16 Dec 2025 03:43:37 GMT

@Community Alums

Would you mind closing your earlier questions by marking appropriate response as correct?

Members have invested their time and efforts in helping you.

Re: transform map script is not working

Ankur Bawiskar — Tue, 16 Dec 2025 03:56:18 GMT

@Community Alums

then you should pass sysId and push array

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏