Hi All,
Today I would cover the topic "Automate executing Data Source from Flow"
Topic: Automate executing Data Source from Flow
Month: December
With the help of this automation, you can execute any scheduled data Import from Flow designer and do the automation of insertion or updating of rows in ServiceNow
1. Create a Scheduled Data Import and attach that to a data source and create the transform map against it. Now next is how do we automate hitting execute button on scheduled data source via Flow. See below:
Flow:
2. Call subflow from Flow
3. What all action we need in Sub Flow:
Sub Flow:
Look up attachment from portal form which we need to process. It could excel,csv or any other format file.
Look up data source where we need to copy the file or process the file
Delete the existing attachment from data source
Copy attachment from attachment record to data source
Look up Scheduled Data Import
Call event, pass event name and in record we pass scheduled data import record
4. What script is required to execute Scheduled Data Import
Script Action:
Hope it helps you.
It will automate the processing of any file via data source/data import.
It will help you saving time and doing the automation of file processing via Flow. Hope it helps you.
Mark it helpful if it helps you.
Thanks,
Shamma
3 Comments
