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

Harish27 · ‎10-19-2020

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!

Ankur Bawiskar · ‎10-19-2020

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

Rizwan Shaikh · ‎07-19-2023

Hi @Harish27

Did you managed to get the output as an excel? I mean is the file extension is .xls?

Harish27 · ‎07-20-2023

Hi Rizwan,

I was able to get the output in csv.

Thanks!