Thank you for choosing MC Snippets, the learning and sharing environment for Marketing Cloud Developers.

If you are new and want to get started we recommend you watch this short video.

This help section will get updated periodically so make sure you visit it to learn more about new features that will come up in the future!

JSON Mode allows you to define your snippet's Data Extension structure and data utilizing json syntax.

For those familiar with the JSON syntax, here's an example of how the Data Extension definition looks in JSON format:

                    {
                        "fieldsDefinition": [
                          {
                            "Name": "EmailAddress",
                            "CustomerKey": "Email",
                            "FieldType": "EmailAddress",
                            "IsRequired": true,
                            "IsPrimaryKey": false
                          },
                          {
                            "Name": "IsCustomer",
                            "CustomerKey": "customer",
                            "FieldType": "Boolean",
                            "IsRequired": false,
                            "IsPrimaryKey": false
                          }
                        ],
                        "values": [
                          {
                            "contactkey": "12",
                            "EmailAddress": "test@bh.exacttarget.com",
                            "IsCustomer": true
                          }
                        ]
                    }
                

Add a field definition to the fieldDefinition's array specifying the following properties:

• Name: This is the name of your column.
• CustomerKey: This is the unique customer key for your column.
• FieldType: Allowed values are EmailAddress, Text, Number, Boolean and Date
• MaxLength: Only valid for Text type columns
• IsRequired: True if your column will be required.
• IsPrimaryKey: True if this column is part of your Primary Key