Open
Description
Connector Name
source-amazon-seller-partner
Connector Version
4.3.1
What step the error happened?
During the sync
Relevant information
Trying to extract return report into Bigquery, data is dropped due to schema validation errors during sync. Here is the destination _airbyte_meta example:
{
"changes": [
{
"change": "NULLED",
"field": "Order date",
"reason": "DESTINATION_TYPECAST_ERROR"
},
{
"change": "NULLED",
"field": "Return request date",
"reason": "DESTINATION_TYPECAST_ERROR"
},
{
"change": "NULLED",
"field": "Return delivery date",
"reason": "DESTINATION_TYPECAST_ERROR"
},
{
"change": "NULLED",
"field": "SafeT claim creation time",
"reason": "DESTINATION_TYPECAST_ERROR"
}
],
"sync_id": 0
}Relevant log output
2024-06-14 15:51:37 platform > Schema validation errors found for stream _GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE. Error messages: [$.Order date: 16-Mar-2024 is an invalid date-time, $.Order date: 17-Mar-2024 is an invalid date-time, $.Order date: 01-May-2024 is an invalid date-time, $.Return request date: 11-Jun-2024 is an invalid date-time, $.Return request date: 13-Jun-2024 is an invalid date-time, $.Order date: 16-Apr-2024 is an invalid date-time, $.Return request date: 12-Jun-2024 is an invalid date-time, $.Order date: 02-May-2024 is an invalid date-time, $.Order date: 06-May-2024 is an invalid date-time, $.Order date: 18-Apr-2024 is an invalid date-time, $.Order date: 21-May-2024 is an invalid date-time, $.Order date: 30-Apr-2024 is an invalid date-time, $.Order date: 31-May-2024 is an invalid date-time, $.Return request date: 14-Jun-2024 is an invalid date-time, $.Order date: 11-Mar-2024 is an invalid date-time, $.Order date: 12-Mar-2024 is an invalid date-time, $.Order date: 18-May-2024 is an invalid date-time, $.Order date: 15-May-2024 is an invalid date-time, $.Order date: 09-Jun-2024 is an invalid date-time, $.Order date: 08-Jun-2024 is an invalid date-time, $.Order date: 07-Jun-2024 is an invalid date-time, $.Order date: 19-May-2024 is an invalid date-time, $.Order date: 21-Apr-2024 is an invalid date-time, $.Order date: 06-Jun-2024 is an invalid date-time, $.Order date: 04-Jun-2024 is an invalid date-time, $.Order date: 05-Jun-2024 is an invalid date-time, $.Order date: 02-Jun-2024 is an invalid date-time, $.Order date: 03-Jun-2024 is an invalid date-time, $.Order date: 24-Apr-2024 is an invalid date-time, $.Order date: 01-Jun-2024 is an invalid date-time, $.Order date: 27-Apr-2024 is an invalid date-time, $.Order date: 13-Jun-2024 is an invalid date-time, $.Order date: 10-Jun-2024 is an invalid date-time, $.Order date: 22-Mar-2024 is an invalid date-time, $.Order date: 24-May-2024 is an invalid date-time, $.Order date: 12-Jun-2024 is an invalid date-time, $.Order date: 11-Jun-2024 is an invalid date-time, $.Order date: 25-May-2024 is an invalid date-time, $.Order date: 26-May-2024 is an invalid date-time, $.SafeT claim creation time: is an invalid date-time, $.Order date: 29-May-2024 is an invalid date-time, $.Return delivery date: is an invalid date-time, $.Order date: 28-May-2024 is an invalid date-time]Contribute
- Yes, I want to contribute