Can I run a transform map from within a workflow?

[kvvijay1979]

I am exploring the possibility of automating an import, load and run transform map - all 3 entirely from within scripts defined inside a workflow. The idea here being, we present the   data import functionality as a catalog item that can be requested from a catalog. The request will include an excel file with the data to be imported. The workflow   defined on the resulting request will include scripts that will populate the base table in this sequence:

1. Create a data source with the attachment in the RITM.

2. Create an import set and identify the above data source in this import set.

3. Load the data from the data source into the import set.

4. Run a transform on this import set.

I am guessing steps 1 & 2 are doable. I am not sure if Steps 3 and 4 are even doable because I am not sure how to scriptify the 'Load Data' and 'Run Transform' actions. Any thoughts?

[Pradeep Sharma]

Hi Vijay,

You can GlideRecord the import set table and insert the request based on the input value. Once the record is created in import set table then the transformation will be automatically triggered.

Please let me know if you have any questions.

[kvvijay1979]

Thanks Pradeep! I understand the part where I would 1) GliderRecord 'sys_data_source' table with the excel attachment (with all the import data) and 2) populate the GlideRecord for sys_import_set with the above data source record. But the 'Load Data' and 'Run Transform' seem to be physical actions in the system that I am not sure how to trigger in the script. If I am understanding you correctly, you are saying that the above 2 actions will automatically trigger the load and transform. is that correct?

[She Sull]

I'm working on a similar requirement. I can trigger the import fine from a business rule using SncTriggerSynchronizer.executeNow(); so I'm trying to get this to work in a workflow run script. This method calls the Execute Now function from the Scheduled Import record using the name or sys_id of the sched import as the parameter for the function. Hope that helps!

[abdellah00]

How Can I use that in two transform map  and table different