Interested in a ServiceNow event built for developers? Registration for now[dev]26 is officially open!

I have to do Bulk import license key in the in the license key (samp_sw_license_key)

KAkanksha15
Tera Contributor

I have to do Bulk import license key in the in the license key (samp_sw_license_key) once bulk upload is completed i have to send the error logs for duplicate keys in the notification and i have to upload the excel using catalog request .

1 REPLY 1

gimewip253
Kilo Explorer

To accomplish this in ServiceNow, you can create a Service Catalog item with an attachment variable for the Excel file, backed by a workflow or Flow Designer action. The underlying script should process the attachment using a GlideExcelParser (or Data Source and Transform Map), check for existing entries in the samp_sw_license_key table to filter out duplicates, insert the unique keys, and programmatically attach an error log file containing the skipped duplicate keys to an email notification sent directly to the user.