Run/trigger a transform map from flow designer or business rule

[Aindrila Mondal]

Hi All,

We have a requirement, where we just want to call/run two existing transform maps sequentially from flow designer or business rule using script .

Can anyone guide me how to call/trigger a transform from flow designer/business rule whichever is the best approach?

Any help is appreciated.

Thanks,

Aindrila

[Aindrila Mondal]

I am not very much aware of this API, Can you please give me example of how to use it to run a transform map.

Thanks,

Aindrila

[Aman Kumar S]

Hi @Aindrila Mondal 

You need to create a custom action and call it in the flow designer, if youare alright to run the transform map asynchronously.

If you want the Transform map to be run synchronously then BR is the way to go.

For either case, you will need access to use GlideImportsetTransformerAPI.

Refer below link to understand better:

https://www.servicenow.com/community/now-platform-forum/usage-of-glideimportsetloader-glideimportset...

[Aindrila Mondal]

I am able to progress something.

I used the below script to run the transform maps. This code run all the transform maps assosiated with the source table "ldap_import" successfully.

var importSet = new GlideRecord('sys_import_set');

importSet.short_description = 'Import set from test';

importSet.table_name = "ldap_import";

var importSetID = importSet.insert();

var importSetRun = new GlideImportSetRun(importSetID);

var transformer = new GlideImportSetTransformer();

transformer.setImportSetRun(importSetRun);

transformer.transformAllMaps(importSet);

And if i want to run a particular transform map using the below code helped:

var importSet = new GlideRecord('sys_import_set');

importSet.short_description = 'Import set from test';

importSet.table_name = "ldap_import";

var importSetID = importSet.insert();

var importSetRun = new GlideImportSetRun(importSetID);

var transformer = new GlideImportSetTransformer();

transformer.setImportSetRun(importSetRun);

transformer.setMapID("e817468a0a0a0b260050ef1ab53941c6");

transformer.transformAllMaps(importSet);

But can anyone guide me what to do if i wanna run two particular transform maps from one script??

Thanks,

Aindrila