How to import records into the sc_req_item table using an Excel file and the ServiceCatalog API?

[Smith Johnson]

Hello,

I have the following requirement that I am trying to implement.

1. I have created a simple catalog item that looks like this:

Variables:
Requested for (requested_for)
Request summary (request_summary)

Detailed description (detailed_description)

2. I have an Excel file where each row represents a distinct requested item. Three columns in the file store the values for each of the variables defined in the catalog item above (see Step 1).

Requirement: I want to implement a logic where an Excel file is imported, and RITMs are automatically created. Each row in the Excel file represents one RITM. The values in the row’s columns should be mapped to the corresponding variables of the catalog item.

For example, when the first row of the Excel file is imported, it should result in the creation of a RITM (e.g. RITMXXXXXX) with the following variable values:

• Requested for: Abel Tuter
• Request summary: First request
• Detailed description: This is a dummy first request
  
  

3. I created a data source, like the following:

4. Then, I created a transform map, as shown below. 

But starting from here, I am confused. I put as target the sc_request table, but not sure if this is correct.

What the target table should be?
How can I invoke the ServiceCatalog API, Order Now, for each of the rows?

Thank you in advance,
Smith.

[Ankur Bawiskar]

@Smith Johnson 

simply ask the end user to add attachment on that item using paper-clip icon

then that file gets attached to RITM record which is generated

From there you can handle the BR logic

links I already shared about excel parsing and cart JS

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Smith Johnson]

Ahh, maybe there is a confusion on my requirement.
The excel file contains rows that should be mapped to RITMs in the system.
This means that I don't have end users to add attachments.

It's only one excel file that should be imported by an admin into the system, and each of the rows should be mapped to an automatically created RITM. Therefore, I am not sure that the after BR approach is in line with my requirement.