Service Connect - pass sub workflow response back to parent workflow

Okay, I’ve started on my actual Sales Order import workflows, and so far, so good. The data are on one worksheet in an Excel workbook that is collected from a file drop. My order header records are being created/verified based on Customer P/O and I’m about to start on the order lines. I’d like to be able to pass back a container from the sub-workflow to the parent workflow with information for an email post at the end of the execution. At the moment, I have a email poster in the sub-workflow to verify that it is working on a per-worksheet-line basis, but that will have to be replaced with the summary email sent by the parent workflow. I created a schema for the information I want to pass back. This is the configuration I have currently have in the parent workflow. This the Process Properties configuration:

And this is the sub-workflow configuration:

In the sub-workflow, the last operation before the finish is populating the dsSubWorkflow container with the data I want to pass back. The Activity Log detail shows the container being populated before it leaves the sub-workflow, but is null upon returning to the parent workflow. This isn’t holding me up at the moment, but I want to be able to inform the operator of the order status upon completion. Thoughts?

Hi Bryan,

Make sure you set the Output Schema of the Sub-Workflow to the same schema of the Parent Workflow’s data container used as Return schema (dsSubWorkflow). On the last conversion within the sub-workflow, send all info you need on the DTA section.

Look at this example:

I add a container on the parent workflow.

Then I set it as return schema for the sub-workflow

On the Sub-Workflow I set the Exit node to the Schema I need to pass back to the parent.

I finally add a conversion that with the expected output schema.

and within the conversion you set the values on the DTA section not to the USR

2 Likes

Carlos, thank you. This is far more explanatory than what I received from Epicor Support. Much appreciated.