Requirement to create a request based on excel sheet data.

[Jyo090]

Hi All,

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

[Astik Thombare]

Hi @Jyo090 ,

Could you please elaborate the requirement more ?

Thanks,

-Astik!

[Dr Atul G- LNG]

Hi @Jyo090 

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

[Ankur Bawiskar]

@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.

[Ashwini Priyadh]

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.