Netsuite source connector dateformat error

[ChloeBellm]

Environment

• Airbyte version: 0.40.27
• OS Version / Instance: AWS EC2
• Deployment: docker
• Source Connector and version: Netsuite 0.1.3

Current Behavior

Getting an error with a %Y-%m-%d dateformat.

DATE FORMAT exception. Cannot read using known formats ['%m/%d/%Y', '%Y-%m-%d']
Search error occurred: Parse of date/time "2022-12-31" failed with date format "dd/MM/yy" in time zone America/Los_Angeles

Expected Behavior

Given it's in the known formats list this should retry with the date format and succeed.

It seems as if it log that it should retry with %Y-%m-%d dateformat (after trying the first date format) but it doesn't go through the list, only uses the default value (first one in the list).

Logs

airbyte_netsuite_salesorder_error_logs.zip

Are you willing to submit a PR?

Yes