When using Workato's CSV parser, there are a few special characters which will cause an internal error, namely:
Double Quotes: "
Any extended characters (e.g. emojis)
To prevent this, you can use the .gsub formula to sub out double quotes (") for single quotes ('), and dashes (-) for spaces ( )
Here's how it should look like:
What this does is it substitutes this problematic characters for acceptable ones, so the internal error can be avoided