Create RITM from Excel sheet using Excelparser

[Ashwini Priyadh]

Hi There,

I have a requirement where multiple Excel sheets will be imported to Servicenow tables. For example: An excel sheet with 10 rows of data is attached to story -> this will trigger the flow designer -> create RITMS for each row (10 RITMs). using  

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.

[Arun_Manoj]

Hi @Ashwini Priyadh ,

Please go through the document,

https://www.servicenowelite.com/blog/2014/2/6/request-generation-methods

[Ashwini Priyadh]

Hi @Arun_Manoj,

Thank you for your response, I am already able to achieve what was given in that article, however I would like to know ways to create RITMs for each row for single REQ.. Currently, it creates REQ for each RITMs. So, if there is 10 rows in Excel, it creates 10 REQs and 10 RITMs.

[Arun_Manoj]

Hi @Ashwini Priyadh ,

If it is helpful please mark it