How can I call an ETL Application in flow designer.

JabbarN
Tera Contributor

‎08-19-2025 12:41 AM - edited ‎08-19-2025 12:46 AM

Hi All,

I am working on a CMDB integration using IntegrationHub ETL. I have already created an ETL Application which contains all the mapping logic and runs fine when I trigger it manually.

Now I want to automate this process using Flow Designer:

  • The Flow Trigger is a Service Catalog Item where users upload the template (Excel) and select a location.

  • Once submitted, the request should go for approval.

  • If approved, I want the flow to automatically call/run the ETL Application instead of running it manually.

 How can I run an ETL Application directly from Flow Designer? Is there a way to invoke it (script, REST, or other method) since I don’t see a ready-made ETL spoke action in Flow Designer?

0 Helpfuls
  • 484 Views
1 REPLY 1

mugi-san
Tera Guru

2 weeks ago

Hello, @JabbarN .

When defining and executing ETL, do you create an import schedule?

If so, you can create an action using the following script to run the import schedule in any flow.
https://www.servicenow.com/docs/csh?topicname=r_SpecialCasesInJobSchedules.html&version=latest

//Execute a scheduled script job
var rec = new GlideRecord('sysauto_script');
rec.get('name', 'YOUR_JOB_NAME_HERE');
SncTriggerSynchronizer.executeNow(rec);

 

 regards.

If you found this post helpful, I would appreciate it if you could click the “Good” button or close the case.

0 Helpfuls