Articles in this section

Edit Async helper to disable quote validation and strip enclosing quotes

Saikumar Rachamalla
Updated

There may be instances where data synced from Amazon to NetSuite using the CSV parser returns 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." This can occur in any Amazon (FBA) - NetSuite flow that uses the Async helper with the CSV parser, including:

  • Amazon (FBA) returns to NetSuite RA and item receipts
  • Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments

If you run another Amazon - NetSuite flow that uses the same Async helper / CSV parser pattern and see the same error, the steps below apply there too.

In such instances, you need to edit the Async helper in the export step of the affected flow as described below to disable quote validation and strip enclosing quotes. The procedure is identical regardless of which Amazon (FBA) - NetSuite flow is producing the error. 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).

Update Async helper values for the export

  1. Go to the export bubble of the affected flow (for example, Amazon (FBA) returns to NetSuite RA and item receipts or Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments).

  2. In the Edit export pane, go to the Advanced tab.

    Edit Async helper.png
  3. Click Edit pencil.svg 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 pencil.svg next to the Result export setting.

    Configure how to get the result.png

  6. The Edit export pane appears with the option to edit the Async helper settings.

    Disable quote validation.png
  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 affected flow and run it again.

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