JSON schema validation failed Amazon Seller Partner

Connector Questions & Issues
,
1

  • Is this your first time deploying Airbyte?: No

  • OS Version / Instance: Ubuntu

  • Memory / Disk: Memory: / Disk

  • Deployment: Docker

  • Airbyte Version: 0.36.8-alpha

  • Source name/version: Amazon Seller Partner (0.2.16)

  • Destination name/version: BigQuery (1.1.4)

  • Step: During sync

  • Description: Hey guys, I am receiving a JSON schema validation error when trying to ingest data from Amazon Seller Partner to BigQuery. I am currently using Raw data normalization because Airbyte can’t normalize data from all endpoints

  • Logs:

2022-05-05 19:37:33 destination > 2022-05-05 19:37:33 INFO i.a.i.d.b.u.AbstractBigQueryUploader(uploadData):97 - Data is successfully loaded to the source table _airbyte_raw_GET_MERCHANT_LISTINGS_ALL_DATA!
2022-05-05 19:37:33 INFO i.a.v.j.JsonSchemaValidator(test):56 - JSON schema validation failed. 
errors: $: null found, object expected
2022-05-05 19:37:33 ERROR i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$1):70 - Validation failed: null
2022-05-05 19:37:33 destination > 2022-05-05 19:37:33 INFO i.a.i.d.b.u.AbstractBigQueryUploader(uploadData):99 - Final state message is accepted.
2022-05-05 19:37:33 destination > 2022-05-05 19:37:33 INFO i.a.i.d.b.u.AbstractBigQueryUploader(dropTmpTable):111 - Removing tmp tables...
2022-05-05 19:37:33 destination > 2022-05-05 19:37:33 INFO i.a.i.d.b.u.AbstractBigQueryUploader(dropTmpTable):113 - Finishing destination process...completed
2

Hey @bruno-azevedo-merama can you share the complete logs for the sync

6

Even though the logs were showing errors when validating JSON, all data was ingested correctly on BigQuery. I think a good solution would be to change this message to a warning

7

It’s the proposal of this issue Bruno: https://github.com/airbytehq/airbyte/issues/12616

8

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.