Edit Async helper to disable quote validation and strip enclosing quotes

There may be instances where the data synced from Amazon to NetSuite using the CSV parser may return the error, “Unable to get the required data from export due to the error:Invalid Closing Quote: found non trimmable byte after quote at line xx. To resolve the error, contact Celigo Support.”, when you run the Amazon (FBA) returns to NetSuite RA and item receipts flow.

In such instances, you need to edit the Async helper in the export step of the Amazon (FBA) returns to NetSuite RA and item receipts flow as described below to disable quote validation and strip enclosing quotes. This will enable you to sync data from Amazon to NetSuite where:

• Column values have unbalanced quotes with no delimiter (column or row delimiter).
• Column values have unbalanced quotes with escaped/unescaped delimiters (column or row delimiter).
• Column values enclosed in double quotes with no delimiter (column or row delimiter).
• Column values enclosed in double quotes with escaped/unescaped delimiters (column or row delimiter).

Important: You must switch your account to developer mode to access some features available for use only by developers.

Update Async helper values for the export

1. Go to the export bubble of the Amazon (FBA) returns to NetSuite RA and item receipts flow.
2. In the Edit export pane, go to the Advanced tab.
   
3. Click Edit() next to the Async helper setting.
4. In the Edit Async helper pane, go to the Configure how to get the results section.
5. Click Edit () next to the Result export setting.
   
6. The Edit export pane appears with the option to edit the Async helper settings.
   
7. Select LF(\n) in the Row delimiter setting.
8. Check the Disable quote validation and strip enclosing quotes setting.
9. Click Save & close to save the changes made to the Async helper.
10. Go back to the Amazon (FBA) returns to NetSuite RA and item receipts flow and run the flow again.

You should be able to sync the records without facing the “Invalid closing quote” error.