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

Hi,

I don't think it can happen 1 row every 1 hour.

You can run the import set directly using flow but it will start processing for all the rows under that import set.

Regards
Ankur

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

Even it is ok if it processes all the rows under import set

can you please share the demo custom action script?

 

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

Thanks for sharing , i'm going through this now

@akshay parekar 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards
Ankur

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