Need to crate multiple RITMs when I attach excel using the catalog item.

[prasannasun]

Hi Team,

I have a requirement where I have a catalog item and using attachment I insert a records and submit the form.

Based on the number of rows in the attachment I need to create multiple requests and requested RITms.

For example in variables I have in that attachment is 

Title

Department

Entity

Needed by

Phone Number

Requested For

If I insert multipke records like for example 5 then I need to get 5 RITMs and 5 requests is there any ways I tried some of the solutions but I couldn't trigger the RITM except the original request.

[GlideFather]

Hey @prasannasun,
it is possible to insert data to any table, but for RITM it is not a good idea.

RITM is always related to a Request. Imagine Request as your eshop order and RITM each item in that order...
There are states and stages synchronising among these and it you insert only RITM, there will be missing data and it will not work correctly.

Also, request fulfilment often requires approval, how do you plan to design it here?

Remember that inserting/creating RITMs can trigger notifications and other workflows and flows.

Your example with 6 columns is not enough, catalog items (= RITM before submission) usually have variables.

Please what is the business justification for this and why RITMs? What kind of data do you want to add into ServiceNow? Perhaps another Task type would be better.

Load data:

https://developer.servicenow.com/dev.do#!/learn/learning-plans/xanadu/new_to_servicenow/app_store_le... 

[prasannasun]

Actually we have an item which is like Access Request and they wanted to bulk upload data instead of manually creating the item individually every item. They wanted to have bulk upload option through attachment or any other way and then they wanted to have multiple requests created for the catalog item "Access Request".

This way they can bulk upload records and we are having not only 6 variables around 20 variables we are having as an example just provided 6.

Is there any best possible way to have this to work