How to transform data in target table using flow designer

akshay parekar1
Tera Contributor

Hello, i have one task to do, but i'am so new to flow designer ,so please help me on this

I have one import set table which has stored some data and i need to create a record in incident table from that data for every one hour

i have to achieve this only by flow designer 

Has anyone  done something like this before?

1 ACCEPTED SOLUTION

Hi,

you can use Custom Action with script

check this link and script shared by Fabian

Usage of GlideImportSetLoader & GlideImportSetTransformerWorker API's from scoped Application

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

11 REPLIES 11

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

So basically you want each row of import set to be processed after every 1 hour using flow?

You can run transform via server side script using Custom Action script in Flow but it will process complete import set i.e. all the records into that import set table

Can you explain is this a business requirement or some assignment/exercise?

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Thanks for replying , it's an assignment i need to do not any business requirement

can't we write a custom action script in flow so that it will process each row of import set after every 1 hr

can you share me the script if possible, it will help a lot me