How to create a file using flow designer and save it in my Local machine

Pooja Khatri
Tera Contributor

Hello All ,

I have a requirement where I want to extract data from User table .. that data should be copied to one file and that file should be created using the flow designer once that data is copied to the file .. need to store that file in a local machine .

The entire functionality I need to implement it through Flow designer only .

Can anyone please help me with the implementation ?

 

 

8 REPLIES 8

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

what type of file? csv etc?

which local machine?

Regards
Ankur

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

Hi @Ankur Bawiskar - Yes either a csv or txt file .. and local machine means in my C Drive .

Can you please help me with the implementation 

Hi,

are you using mid server?

Why to push it to mid server?

Why not use scheduled export set module which can push csv or excel file to particular path in mid server for a table daily?

you can create csv file from a record but you need to attach it to that record and then push it to mid server

I would suggest to use scheduled job as it involves lot of scripting

Generate CSV file through script

Regards
Ankur

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

Hi @Ankur Bawiskar - 

No currently I am not using a mid server .

For your query : 

 

Why not use scheduled export set module which can push csv or excel file to particular path in mid server for a table daily? -- actually using flow designer I am filtering out the data from the user table ... can I use scheduled export set module in my flow designer ? and if yes how will be the actual flow look like ? .. I am using the 'look up record' action which will look up the sys_user table and extract the data which I am looking for .. post that is the csv work .

 

you can create csv file from a record but you need to attach it to that record and then push it to mid server . I would suggest to use scheduled job as it involves lot of scripting -- can you please help me with the actual background and how will the actual implementation I should do in this ?