Flow designer for Bulk request

MercBuilding
Giga Guru

Hi All,

   I have a requirement to create multiple RITM's using excel file. I have created data source, onComplete transform script in Transform map. This is creating multiple RITM's under single request. I tried creating flow designer for this request by adding actions to create data source record, scheduled import etc but the issue here is it is creating 4 RITM's with two requests if the excel has two rows, PFB screenshot of the flow designer. Please suggest me where iam going wrong.

 

sravanthichegur_0-1695257897098.png

 

sravanthichegur_1-1695257954343.png

 

@Saurav11 @OlaN @Pradeep Sharma @AbhishekGardade 

Thanks!!

9 REPLIES 9

OlaN
Giga Sage
Giga Sage

Hi,

I've read your question multiple times now, and I still don't understand what you are asking.

Please elaborate on your question a bit more.

Hi @OlaN ,

  I have a service catalog which has attachment field. Users will attach the attachment which has values for variables of the same service catalog.Now when they submit the request, each row should create an RITM with values from row as catalog variables and each RITM should create a task as well. 

Hope you understand the requirement.

So basically you want the Flow to submit additional requests with data from the Excel file?

Then you probably need to create a custom action to parse the data using the GlideExcelParser API.

And then use the Submit Catalog Item Request action in Flow Designer to submit additional requests, using data from the ExcelParser.

Hi @OlaN ,

   I was able to create custom action for this and was able to create ritm's through excel but the variable section for RITM's created through script(custom action) are not appearing on RITM. Instead of custom action, is it ok to do it through onSubmit client script by calling script include so that RITM's will be created when request is placed?

sravanthichegur_0-1695417013418.png

 

Thanks!