Attach excel/csv file to catalog item to populate and validate the data in MRVs

Saurabh_dhiman
Tera Contributor

‎05-01-2024 02:20 AM

Hi All,

 

I have a requirement where I need to populate the MRVs using an excel/csv file. right now we can populate only up to 5 entries manually. Although I can change it using system property but that will be impact globally. So I need to populate the multi-row variables for a particular catalog using attachment in which there can be thousands of entries. At the time of populating the data into MRVs I need to validate the data as well whether it is in correct format or not. also I need this process to be running asynchronously.

0 Helpfuls
  • 311 Views
1 REPLY 1

Amitoj Wadhera
Kilo Sage

‎05-02-2024 10:32 AM - edited ‎05-02-2024 10:32 AM

Hi @Saurabh_dhiman ,

 

You can leverage GlideExcelParser API to achieve the requirement.

https://developer.servicenow.com/dev.do#!/reference/api/washingtondc/server/sn_impex/GlideExcelParse...

 

If you find my response helpful, please consider marking it as the 'Accepted Solution' and giving it a 'Helpful' rating. Your feedback not only supports the community but also encourages me to continue providing valuable assistance.

 

Regards,

Amitoj

0 Helpfuls