To find the updated records in the table which is done by transform map through background scripts

[sai153]

• Create Transform maps and update the data of the table and show the updated records using background scripts

Please help me how to approach along with scripting.

Thanks in advance.

[Anil Lande]

Hi,

Can you please share more details or an example what you want to achieve?

Thanks,
Anil Lande

[sai153]

Whenever the data is uploading through transform maps, after the data is uploaded to that 'x' table. I need to get updated records using background scripts.

[Rajat_Choudhary]

Hi Sai,

You can query sys_import_set_row_list table. To get the records which are updated / changed after the transform map has run.

You can get the import set details from transform history table

Please use below script.

var abc=new GlideRecord('sys_import_set_row_list');
abc.addEncodedQuery('sys_import_set='+<sys_id of current importset>);
abc.query();
while (abc.next()){
gs.print(abc.sys_target_sys_id);
}

 Thanks,

Hope it will be helpful.

Please mark answer as correct and helpful. If solution seems feasible.

[Ankur Bawiskar]

Hi,

you can get details of which import set records got updated by checking in transform history

what script have you started with?

Regards
Ankur