How to create Request, Req Item and Catalog Task from Excel Sheet records instead of Catalog Item?

VIKAS45
Tera Guru

‎03-12-2024 06:07 AM

How to create Request, Req Item and Catalog Task from Excel Sheet records instead of Catalog Item?

0 Helpfuls
  • 217 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

‎03-12-2024 06:15 AM

Hi @VIKAS45 

 

It is not that easy , you need to parse the excel sheet and then map it with the Request Item. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Harish KM
Kilo Patron
Kilo Patron

‎03-12-2024 06:23 AM

Hi @VIKAS45 how is the excel sheet coming to ServiceNow? Via email? You need to parse the excel file and then do the logic, 

Refer below example on how to parse

https://www.servicenow.com/community/developer-articles/parsing-the-excel-sheet-data-use-the-data-in...

Regards
Harish