Removing some custom properties columns from "Open" table extraction

[tomasleiva9]

Hi,

I was wondering if there's a way to not include a few custom properties in the Open table. Also, choose what custom property list will be replicated would be good as well.

Is there a way to do it in Stitch integration settings?

Thanks Tomás

[gmfennema]

Hey @tomasleiva9, you should be able to go into tap_klaviyo > schemas > open.json and edit which fields are being included or excluded. Here is an example of adding/removing the email subject from the event properties:

Including the subject

"event_properties": {
      "type": "object",
      "properties": {        
        "event_id": {
          "type": "string"
        },
        "Subject": {
          "type": "string"
        }
      }

Excluding the subject

"event_properties": {
      "type": "object",
      "properties": {        
        "event_id": {
          "type": "string"
        }
      }

Make sure when you alter the schema to then re-install the package with: python3 setup.py install