question Re: UI Action Needed to Transform Staging Records to Target Table in Community Central forum

UI Action Needed to Transform Staging Records to Target Table

Karthik152 — Thu, 27 Nov 2025 04:29:06 GMT

I am trying to build a UI Action that will automatically transform selected records from my custom staging (import set) table into the target em_event table using a specific Transform Map(already created and works manually).

The requirement is that users should be able to select multiple staging records, click the UI Action, and the system should run the Transform Map programmatically—just like the standard “Transform” button.

I will attach my current UI Action script and Script Include.
Please review and help me correct the code so the transform executes properly.

UI Action - Create Event

function transformSelected() {

try {

var selected = g_list.getChecked(); // Now valid because this is client-side

if (!selected) {

alert("Please select at least one import set row.");

return false;

} else {

var ga = new GlideAjax("customTransformUtils");

ga.addParam("sysparm_name", "transformRecords");

ga.addParam("sysparm_ids", selected);

ga.addParam("sysparm_transform_map", "f52a2dd32b193a105f76fb13ed91bf78");

ga.getXMLAnswer(function(answer) {

if (!answer) {

alert('No response from server.');

return;

}

var payload;

try {

payload = JSON.parse(answer);

} catch (e) {

alert('Failed to parse response: ' + e.message);

return;

}

if (payload.success) {

g_form.addInfoMessage(payload.message || 'Transformation completed.');

// If you need to trigger a server-side UI Action after success:

// gsftSubmit(null, g_form.getFormElement(), '<server_ui_action_sys_id>');

} else {

alert(payload.message || 'Transformation failed.');

}

});

}

} catch (err) {

g_form.addErrorMessage('Unexpected error: ' + err.message);

}

---------------------------------------------------------------------------------------------------

Script Include:

var customTransformUtils = Class.create();

customTransformUtils.prototype = Object.extendsObject(AbstractAjaxProcessor, {

transformRecords: function() {

gs.info('KS LOG: ');

// var ids = (gs.getProperty("sysparm_ids") || gs.getUser().getSession().getProperty("sysparm_ids"));

var ids = this.getParameter("sysparm_ids");

var transformMap = this.getParameter("sysparm_transform_map");

gs.info('KS LOG: ' + ids);

gs.info('KS LOG: ' + transformMap);

if (!ids || !transformMap)

return "Missing parameters.";

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

var count = 0;

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

var gr = new GlideRecord(current.getTableName ? current.getTableName() : ""); // fallback

gr = new GlideRecord("u_event_table");

if (!gr.get(arr[i]))

continue;

if (gr.state != 'unprocessed')

continue;

var ts = new GlideImportSetTransformer();

ts.setImportSetTable(gr.getTableName());

ts.setImportSetRun(gr.sys_id);

ts.setMap(transformMap);

ts.transform();

count++;

}

return count + " record(s) transformed successfully.";

getParameter: function(name) {

return gs.getSession().getProperty(name) || gs.getProperty(name) || this.getParameter(name);

type: 'customTransformUtils'

});

Re: UI Action Needed to Transform Staging Records to Target Table

Deepak Shaerma — Thu, 27 Nov 2025 06:19:51 GMT

Hi @Karthik152

UI Action (Client Side)

I added the sysparm_table parameter so the script is dynamic and removed the hardcoded table name in the server script.

Name: Transform Selected
Client: True OnClick: transformSelected()

Script Include

Name: customTransformUtils
Client Callable: True

Happy to help! If this resolved your issue, kindly mark it as the correct answer and Helpful and close the thread so others can benefit too.

Warm Regards,

Deepak Sharma

Community Rising Star 2025

Re: UI Action Needed to Transform Staging Records to Target Table

Karthik152 — Thu, 27 Nov 2025 08:01:05 GMT

Thanks for yours efforts, but records are not transferring to target table, If you have any idea to achieve in other way, would be helpful 🙂

Re: UI Action Needed to Transform Staging Records to Target Table

lakshaysharma — Thu, 27 Nov 2025 08:06:07 GMT

Hey, I had a look at the transform setup. Two things to check on the Script Include side: 1. Right now it’s returning a plain string, but the client script is doing JSON.parse(answer), so the server response should be proper JSON. 2. is getParameter has been overridden in the Script Include and is calling this.getParameter() again which causes recursion and will eventually blow up. We should remove that override and just use the default getParameter from AbstractAjaxProcessor.