I am attempting to process a 4010 835 EDI file that contains multiple TRN segments by
1) having the receive location pick it up
2) the receive port contains an inbound map between the single X12_00401_835 schema and custom schema (structure below) to extract information from the EDI file
<TransactionRefId /> (Mapped to the TRN segment)
<Date /> (Mapped to the TRN segment)
<Payee /> (Mapped to the TRN segment)
3) The EdiReceive pipeline then splits the EDI file on the TRN segment, so if there are 4 TRN segments in the file, then the EDI file is split into 4 files.
4) My send port then picks up each of the mapped XML blocks and calls a stored procedure over the WCF-SQL adapter 4 or however many files the EDI file has been split into.
My question is how can I process the EDI file so that I am just calling the stored procedure once? I know that the mapping needs to be in place & run through the EdiReceive pipeline in order to get the data in the format of my custom schema above,
so I am wondering if leveraging an orchestration to call the EdiReceive pipeline & split the file, then eseentially put the contents back together before calling the stored procedure?