Meltano

Screenshot 2023-09-30 at 8.27.19 PM.png

I am loading data from `tap-shopify`  and dumping it into output.json for now. It turns out the SKU property comes as null which throws an exception at runtime that the type is not string. This is a consistent problem and I'm not sure how to resolve it. `sku` is a property of the object in `products.variants` , which is an array of objects.

For more info here's what's happening. As seen in the error when piping the data from the tap to target throws an error as such. There needs to be a transform in place that can enforce the string type. How can I do that?

Hi <@U06C58SQYBG>. It's Saturday but I'm sitting in front of my computer anyway so...  Here's a couple of things you can try:
• Create an issue in the tap repo (and maybe submit a PR) to update <https://github.com/Matatika/tap-shopify/blob/8c523679b0d52241e9ef5685b6d0c02c513db973/tap_shopify/schemas/product.json#L67-L69|https://github.com/Matatika/tap-shopify/blob/8c523679b0d52241e9ef5685b6d0c02c513db973/tap_shopify/schemas/product.json#L67-L69>
• Override the schema for that field to make it nullable: <https://docs.meltano.com/concepts/plugins/#schema-extra|https://docs.meltano.com/concepts/plugins/#schema-extra>

Hi, we are planning to address a couple of issues with `tap-shopify` this coming week, including updating schemas to fix issues like this. I've made a note of this in particular for us to go over as well.