Khushbu Adav
02/10/2025, 10:02 AMemail_marketing_consent
mapped to which field in raw stream customer?kapa.ai
02/10/2025, 10:03 AMemail_marketing_consent
field in the customer stream. According to the [Extract insights from Shopify using PyAirbyte](https://airbyte.com/tutorials/extract-insights-from-shopify-using-pyairbyte) tutorial, the email_marketing_consent
field in the customer stream is directly mapped to the email_marketing_consent
field in the raw customer stream. The tutorial shows an example of parsing this field: python customers['email_marketing_consent'] = customers['email_marketing_consent'].apply(parse_json)
This indicates that the email_marketing_consent
field is present in the raw customer data and is being parsed from its JSON format. It's important to note that the email_marketing_consent
field contains nested information. The tutorial further extracts specific data from this field: python customers['consent_opt_in_level'] = customers['email_marketing_consent'].apply(lambda x: x.get('opt_in_level', None)) customers['consent_state'] = customers['email_marketing_consent'].apply(lambda x: x.get('state', None))
This shows that the email_marketing_consent
field in the raw customer stream contains at least two sub-fields: opt_in_level
and state
. For the most up-to-date and detailed information about the exact field mappings in your specific version (2.4.4) of the Shopify source connector, you may want to check the [Shopify Source Connector documentation](https://docs.airbyte.com/integrations/sources/shopify) or consult the connector's schema definitions directly.