Good day SnapLogic Community
I would greatly appreciate your help with the following. We have a cloud pipeline reading data from a REST service and returns the data in a comma delimited string. It send the data via a pipeline execute with label “Store Transactions” and this child pipeline has a CSV Parser configured as below. A runtime error occurs because one field contains XML data as follows with also contains commas so an error is being thrown.
Is there any way that I can design the pipeline to deal with these extra commas before the line feed?
<Policy> <PolicyId>5002919511</PolicyId> <PlanCode>LB85 1</PlanCode> <Status>UNDERWRITING INCOMPLETE, MISSING REQTS, ERROR ON POLICY</Status> <IssueDate>2019-03-15</IssueDate> <Mode>SEMI ANNUAL</Mode> <ModalPremium>6078.75</ModalPremium> <PremiumDueDate>1900-01-01</PremiumDueDate> <Quantity>1</Quantity> </Policy>
Thank you very much in advance!