Requirement to create a request based on excel sheet data.

Jyo090
Tera Contributor

Hi All,

 

I have requirement to create a request based on excel input. how should i achieve this.

5 REPLIES 5

Astik Thombare
Tera Sage

Hi @Jyo090 ,

 

Could you please elaborate the requirement more ?

 

Thanks,

-Astik!

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Jyo090 

 

Your statements are not clear. Please elaborate more or provide some screen shot references.

*************************************************************************************************************
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]

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

Ankur Bawiskar
Tera Patron
Tera Patron

@Jyo090 

I assume this is what you require.

you have an excel and based on rows of excel you need to create REQ and RITM?

if yes then you can use GlideExcel parser and then for each row use Cart API

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

Hi @Ankur Bawiskar ,

 

I have achieved creating RITMs from Excel sheet using Excelparser and cart API, however the cart API creates REQ for every RITM. Is there a way that we could create only one REQ and creates RITM for every row in the excel but not REQ.

Example: I have 10 rows in excel with variable values in 7 columns. I should create 10 RITMs for every row but only one REQ that has all the 10 RITMs in it.