How to Trigger flow when a record is created or updated in import set table

[rksnow]

Hello, I have an import set table wherein data gets imported periodically. I have created a flow in designer to get triggered when a new record is created or updated in import set table and Run the action - update the "target record" in import set table record. But, the problem I am facing is, when the data is getting imported my flow is not getting triggered. Could you please suggest any other best possible way?

I tried changing the state to is "not pending" or "one of" but nothing worked.

[Sajilal]

Maybe could you have a BR to trigger and execute the flow via script?

https://developer.servicenow.com/dev.do#!/learn/learning-plans/madrid/servicenow_application_develop...

Please Mark as ✅ Correct if this solves your issue and also mark ???? Helpful if it helps resolve your problem.

Thanks,
Saji

[Ashutosh Munot1]

Hi,

No BR will cause performance issue on import set table.

Now the thing is why you are not using ETL spoke. If you dont have integration hub then we have to check condition. Try with only one condition and then check if it runs.

Thanks,
Ashutosh

[rksnow]

Hello Ashutosh, Thank you for your reply.

We do have IntegrationHub ETL and I am using it for Transforming and mapping my data to CMDB Tables.

So, Once Data is mapped to cmdb table, I want to collect the record sys id and add it to the target record field in import set table and add the same record to discovery sources table as well, which I want to do via flow designer.

I have tried removing all the conditions in flow designer and it works! Flow is getting triggered. Problem occuring when I am adding a condition be it one or multiple.

We have to have the condition for sure as when data is loaded to import set table, state is set to pending, and will get changed only after record is inserted or updated to cmdb table. So, I need to have the condition in order to get the sys id of the cmdb record.

I am not familiar with ETL Spoke. I will take a look at that.

[Ashutosh Munot1]

Hi,

Nice. SO now you can proceed with adding one condition at a time and test it.

Thanks,
Ashutosh