We use the Bulk Query function of the Salesforce Connector to kick off a job on the Lead object. The data is returned as a payload and we use DataWeave to parse it and prepare it for consumption to Snowflake.
The issue is that a field on the Lead Objected called Subject will sometimes have a comma. When this happens, the Mule App breaks because it breaks the data on the comm and ends up pushing a text field to, say, a Date field.
We have used the Write connector to write the CSV file to local disk and when we open the file the Subject has a backslash (\) where the comma would be.
We need the app to handle the comma as it really is, a comma, and not consider it a field delimiter. We've tried to change the Delimiter to PIPE on the Salesforce Connector configuration for the Bulk Query, but that didn't solve the issue.
UPDATE:
I was able to handle the comma's but the description field sometimes has HTML code in it:
<html doctype="html">
<head>
<title>Email Template</title>
</head>
<body>
<p>Email Message</p>
</body>
</html>
After each HTML tag, the file is breaking to a new row (not a new column).
