Hi,
I have a Flat File Schema that primarily needs to validate a CSV file from
a
Third-Party. I need to validate a couple of mandatory fields, but if the
delimiter is missing inaccurate XML is returned, the XML might look
something
like this:
<Body>
- <FSETrxnRequest>
<TrxnId>xxxxxxxxx</TrxnId>
<ClientIDNumber>RSA-ID</ClientIDNumber>
<ClientIDType>xxxxxx</ClientIDType>
<ClientInitials>xxxxxxxx</ClientInitials>
<ClientSurname>1900/00/050/ClientSurname>
<ClientDateOfBirth>LIB</ClientDateOfBirth>
<Provider>12345 1</Provider>
<PolicyNumber>xxxxxxx,RSA-ID,xx,xxxxxxxx,1900/00/00,LIB,12345</PolicyNumber>
</FSETrxnRequest>
</Body>
You will notice in the last <PolicyNumber> tag the entire preceding line
in
the CSV file is squezed into one tag. This is incorrect, and BizTalk seems
to
validate this fine.
Is there any way of overcoming this issue?
I tried changing the "Group Order Type" from "sequence" to "all" but this
causes more issues.
Thanks in advance
|
