search

singer-io / tap-bigcommerce

A Singer.io tap for extracting data from the BigCommerce API
GNU Affero General Public License v3.0
6 stars 17 forks source link

Change products.external_id in orders.json to string #14

Open ericdigr opened 3 years ago

ericdigr commented 3 years ago

In orders.json, products.external_id (line 444) is defined as an integer. Our source data includes hash strings in this field, causing inserts to fail.

Example row:

products.0.external_id: 0ce0319c-6157-41b3-85a6-47799368664c does not match {'inclusion': 'available', 'type': ['integer', 'null']}

Pull request issued: #13

Maynkmohta commented 3 years ago

https://share.getcloudapp.com/v1ujPmGe documentation --- https://developer.bigcommerce.com/api-reference/store-management/orders/orders/createanorder looks like it is not defined correctly in our tap code as per documentation

Maynkmohta commented 3 years ago

we are using stitch and we have tons of similar errors — error logs

https://share.getcloudapp.com/bLudleG7