Flow designer for Bulk request

[MercBuilding]

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.

@Saurav11 @OlaN @Pradeep Sharma @AbhishekGardade 

Thanks!!

[OlaN]

Yes, I guess that will also work, but it seems a bit more complicated doing it through an onSubmit script.

Also, I'm not sure where the data source and the transforms/imports you mentioned in your question should fit into this requirement.

[MercBuilding]

Sorry @OlaN . I didnt understand what you are saying, can you elaborate.

[OlaN]

In your question, you also write about a Data source and having created a Transform map to this source.

I don't see how these things are needed if you create a custom action to process the excel data, or if you choose to do it through an onSubmit client script.

[MercBuilding]

Hi @OlaN ,

   Thats correct, iam not going to use the data source/schedule import i created since they are creating another request and ritm instead of the same request when request is raised. Although i tried using custom action to parse the excel and insert the RITM record under same request, iam able to create RITM since iam not using cart API , it is not showing variables on the RITM... do you have any better way of doing it?

Thanks in advance.

[OlaN]

The only Flow designer way (not coding) is to use the Submit Catalog Item Request.

Which will generate an additional REQ that's connected to the RITM you are submitting.

If needed you can, after submitting the request, reconnect the new RITM to an existing REQ, and delete the newly created REQ.