Automatically export the table data as csv/excel file and attach it in RITM

Harish27
Kilo Guru

Hi ,

I am doing bulk upload of data into custom table. I am using data source and transform map to validate the data in the excel sheet and dump the data to a custom table.

Now I want to automatically export the data from custom table as csv/excel format and attach it in RITM.?

How can i achieve this?

Any help would be massively appreciated. Thank you!

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Harish,

you can use script to create csv file and then attach to RITM

refer below links on how to create file from script and how to attach

you can enhance your script accordingly.

Generate csv file with the catalog variables and attaching to RITM record

Generate CSV file through script

Regards
Ankur

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

View solution in original post

16 REPLIES 16

Oops I have missed the extension.. (.csv)

Now its working fine.

Hi,

Glad to know

Please mark my response as correct and helpful to close the thread as answered so that it helps future readers

Regards
Ankur

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

Hi @Ankur Bawiskar ,

@Pradeep Sharma 

 

I have requirment where i need to download new user list of record as csv file on user  table every friday and then i need to email downloaded user list  csv file to  BDO team via mail.How can i automate this requiment.

 

 

Thank you.

sai153
Tera Contributor

Hi Ankur,

 

I need to export data of table list records in excel format automatically with scripting?