question Onbefore script transfrom map in Developer forum

Onbefore script transfrom map

abhijee — Wed, 20 Mar 2024 06:15:00 GMT

Hello Experts,

I'm currently delving into the sources.row method within a transform map script. I have an Excel sheet containing ten records, and I'm looking to import only two specific records: those corresponding to rows 1 and 5. However, despite writing the following script, it doesn't seem to be functioning correctly. Could someone please guide me on this?

Thank you.

Onbefore Script.

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) { if(source.row==1 ||source.row==5) { gs.log("do nothing"); } else{ gs.log("Ignore records"+source.row); ignore=true; } })(source, map, log, target);

Re: Onbefore script transfrom map

Iraj Shaikh — Wed, 20 Mar 2024 07:11:31 GMT

Hi @abhijee

The `onBefore` script in a ServiceNow transform map is used to manipulate data before it is transformed into the target table. If you want to import only the records from rows 1 and 5, you should set `ignore` to `true` for all other rows except for rows 1 and 5. However, the `source.row` property does not exist in ServiceNow's data source API. Instead, you should use `source.getRow()` to get the current row number.

Here's how you can modify your script to correctly ignore all rows except for 1 and 5:

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) { var currentRow = source.getRow(); // Get the current row number if (currentRow == 1 || currentRow == 5) { // If it's row 1 or 5, do not ignore (import the record) gs.log("Importing record from row: " + currentRow); } else { // If it's any other row, ignore (do not import the record) gs.log("Ignoring record from row: " + currentRow); ignore = true; // Set ignore to true to skip the record } })(source, map, log, target);

Make sure to place this script in the `onBefore` script field of your transform map. This script will log a message for each row that is processed, indicating whether the row is being imported or ignored. Only rows 1 and 5 will be imported, and all other rows will be ignored.

Please mark this response as correct or helpful if it assisted you with your question.

Re: Onbefore script transfrom map

abhijee — Wed, 20 Mar 2024 10:07:00 GMT

Hello @Iraj Shaikh

Thank you for your assistance.

I attempted to use the script you provided in the OnBefore script event, but it doesn't seem to be functioning correctly. In the system log, I noticed that the current row is showing as undefined. I have attached a screenshot for your reference.

Thank You.

Re: Onbefore script transfrom map

James Chun — Wed, 20 Mar 2024 10:25:40 GMT

Hey @abhijee,

Can you try the following instead:

source.getValue('sys_import_row') == 1 || source.getValue('sys_import_row') == 5

And FYI, I don't think using the row to ignore the data is recommended. Instead, you should define a logic by using the actual value of the imported data.

Cheers

Re: Onbefore script transfrom map

abhijee — Thu, 21 Mar 2024 08:41:02 GMT

Thank You @James Chun

Its working.