preset

entity.json

{
 "data": {
  "customer_details": [
   {
    "name": "email",
    "type": "email",
    "length": 254,
    "default_value": "",
    "use_in_payload": true,
    "is_required": false,
    "is_disabled": false
   },
   {
    "name": "timezone",
    "type": "timezone",
    "length": 255,
    "default_value": "",
    "use_in_payload": true,
    "is_required": true,
    "is_disabled": false
   },
   {
    "name": "country",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": true,
    "is_required": true,
    "is_disabled": false
   },
   {
    "name": "language",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": true,
    "is_required": true,
    "is_disabled": false
   },
   {
    "name": "sf_account_id",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": false,
    "is_required": false,
    "is_disabled": false
   },
   {
    "name": "sf_contact_id",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": false,
    "is_required": false,
    "is_disabled": false
   },
   {
    "name": "mk_account_id",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": false,
    "is_required": false,
    "is_disabled": false
   },
   {
    "name": "mk_account_hash",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": false,
    "is_required": false,
    "is_disabled": false
   },
   {
    "name": "sf_checked_at",
    "type": "datetime",
    "length": 0,
    "default_value": "",
    "use_in_payload": false,
    "is_required": false,
    "is_disabled": false
   }
  ],
  "device_details": [
   {
    "name": "sf_device_id",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": false,
    "is_required": false,
    "is_disabled": false
   },
   {
    "name": "computer_login",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": true,
    "is_required": true,
    "is_disabled": false
   },
   {
    "name": "computer_type",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": true,
    "is_required": true,
    "is_disabled": false
   },
   {
    "name": "computer_serial_number",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": true,
    "is_required": true,
    "is_disabled": false
   },
   {
    "name": "computer_mac_address",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": true,
    "is_required": true,
    "is_disabled": false
   },
   {
    "name": "os_version",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": true,
    "is_required": true,
    "is_disabled": false
   },
   {
    "name": "os_name",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": true,
    "is_required": true,
    "is_disabled": false
   },
   {
    "name": "storage_total_free",
    "type": "unsigned_number",
    "length": 20,
    "default_value": "",
    "use_in_payload": true,
    "is_required": false,
    "is_disabled": false
   }
  ],
  "product_details": [
   {
    "name": "name",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": true,
    "is_required": true,
    "is_disabled": false
   },
   {
    "name": "version",
    "type": "version",
    "length": 50,
    "default_value": "",
    "use_in_payload": true,
    "is_required": true,
    "is_disabled": false
   },
   {
    "name": "trt",
    "type": "unsigned_number",
    "length": 20,
    "default_value": "",
    "use_in_payload": true,
    "is_required": false,
    "is_disabled": false
   },
   {
    "name": "affid",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": true,
    "is_required": false,
    "is_disabled": false
   },
   {
    "name": "guid",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": false,
    "is_required": false,
    "is_disabled": false
   },
   {
    "name": "marketing_product_id",
    "type": "unsigned_number",
    "length": 20,
    "default_value": "",
    "use_in_payload": true,
    "is_required": true,
    "is_disabled": false
   },
   {
    "name": "license_type",
    "type": "text",
    "length": 255,
    "default_value": "",
    "use_in_payload": true,
    "is_required": true,
    "is_disabled": false
   }
  ]
 }
}

prset.json

{
 "data": {
  "allowed_join_operators": [
   "AND",
   "OR"
  ],
  "operations": {
   "has-happened-exactly-X-time-ago": {
    "allowed_data_types": [
     "datetime"
    ],
    "operator_category": "binary",
    "preview_template": "${target_value} HAS HAPPENED EXACTLY ${duration} AGO",
    "target_operand": {
     "name": "target_value",
     "title": "Target Date",
     "kind": "reference",
     "is_spread": false,
     "is_fixed_kind": true
    },
    "additional_operands": [
     {
      "name": "duration",
      "title": "Duration",
      "kind": "value",
      "is_spread": false,
      "is_fixed_kind": true,
      "custom_value_type": "duration"
     }
    ]
   },
   "will-happen-exactly-in-X-time": {
    "allowed_data_types": [
     "datetime"
    ],
    "operator_category": "binary",
    "preview_template": "${target_value} WILL HAPPEN EXACTLY IN ${duration}",
    "target_operand": {
     "name": "target_value",
     "title": "Target Date",
     "kind": "reference",
     "is_spread": false,
     "is_fixed_kind": true
    },
    "additional_operands": [
     {
      "name": "duration",
      "title": "Duration",
      "kind": "value",
      "is_spread": false,
      "is_fixed_kind": true,
      "custom_value_type": "duration"
     }
    ]
   },
   "has-happened-at-least-X-time-ago": {
    "allowed_data_types": [
     "datetime"
    ],
    "operator_category": "binary",
    "preview_template": "${target_value} HAS HAPPENED AT LEAST ${duration} AGO",
    "target_operand": {
     "name": "target_value",
     "title": "Target Date",
     "kind": "reference",
     "is_spread": false,
     "is_fixed_kind": true
    },
    "additional_operands": [
     {
      "name": "duration",
      "title": "Duration",
      "kind": "value",
      "is_spread": false,
      "is_fixed_kind": true,
      "custom_value_type": "duration"
     }
    ]
   },
   "will-happen-at-least-X-time-later": {
    "allowed_data_types": [
     "datetime"
    ],
    "operator_category": "binary",
    "preview_template": "${target_value} WILL HAPPEN AT LEAST ${duration} LATER",
    "target_operand": {
     "name": "target_value",
     "title": "Target Date",
     "kind": "reference",
     "is_spread": false,
     "is_fixed_kind": true
    },
    "additional_operands": [
     {
      "name": "duration",
      "title": "Duration",
      "kind": "value",
      "is_spread": false,
      "is_fixed_kind": true,
      "custom_value_type": "duration"
     }
    ]
   },
   "has-happened-within-last-X-time": {
    "allowed_data_types": [
     "datetime"
    ],
    "operator_category": "binary",
    "preview_template": "${target_value} HAS HAPPENED WITHIN LAST ${duration}",
    "target_operand": {
     "name": "target_value",
     "title": "Target Date",
     "kind": "reference",
     "is_spread": false,
     "is_fixed_kind": true
    },
    "additional_operands": [
     {
      "name": "duration",
      "title": "Duration",
      "kind": "value",
      "is_spread": false,
      "is_fixed_kind": true,
      "custom_value_type": "duration"
     }
    ]
   },
   "will-happen-within-next-X-time": {
    "allowed_data_types": [
     "datetime"
    ],
    "operator_category": "binary",
    "preview_template": "${target_value} WILL HAPPEN WITHIN NEXT ${duration}",
    "target_operand": {
     "name": "target_value",
     "title": "Target Date",
     "kind": "reference",
     "is_spread": false,
     "is_fixed_kind": true
    },
    "additional_operands": [
     {
      "name": "duration",
      "title": "Duration",
      "kind": "value",
      "is_spread": false,
      "is_fixed_kind": true,
      "custom_value_type": "duration"
     }
    ]
   },
   "bigger-or-equal": {
    "allowed_data_types": [
     "datetime",
     "number",
     "decimal",
     "unsigned_number"
    ],
    "operator_category": "binary",
    "preview_template": "${target_value} ≥ ${compared_value}",
    "target_operand": {
     "name": "target_value",
     "title": "Target Value",
     "kind": "reference",
     "is_spread": false,
     "is_fixed_kind": true
    },
    "additional_operands": [
     {
      "name": "compared_value",
      "title": "Compared Value",
      "kind": "any",
      "is_spread": false,
      "is_fixed_kind": false
     }
    ]
   },
   "less-or-equal": {
    "allowed_data_types": [
     "datetime",
     "number",
     "decimal",
     "unsigned_number"
    ],
    "operator_category": "binary",
    "preview_template": "${target_value} ≤ ${compared_value}",
    "target_operand": {
     "name": "target_value",
     "title": "Target Value",
     "kind": "reference",
     "is_spread": false,
     "is_fixed_kind": true
    },
    "additional_operands": [
     {
      "name": "compared_value",
      "title": "Compared Value",
      "kind": "any",
      "is_spread": false,
      "is_fixed_kind": false
     }
    ]
   },
   "equal": {
    "allowed_data_types": [
     "uuid",
     "text",
     "version",
     "email",
     "timezone",
     "number",
     "unsigned_number",
     "decimal",
     "boolean",
     "datetime"
    ],
    "operator_category": "binary",
    "preview_template": "${target_value} = ${compared_value}",
    "target_operand": {
     "name": "target_value",
     "title": "Target Value",
     "kind": "reference",
     "is_spread": false,
     "is_fixed_kind": true
    },
    "additional_operands": [
     {
      "name": "compared_value",
      "title": "Compared Value",
      "kind": "any",
      "is_spread": false,
      "is_fixed_kind": false
     }
    ]
   },
   "not-equal": {
    "allowed_data_types": [
     "uuid",
     "text",
     "version",
     "email",
     "timezone",
     "number",
     "unsigned_number",
     "decimal",
     "boolean",
     "datetime"
    ],
    "operator_category": "binary",
    "preview_template": "${target_value} ≠ ${compared_value}",
    "target_operand": {
     "name": "target_value",
     "title": "Target Value",
     "kind": "reference",
     "is_spread": false,
     "is_fixed_kind": true
    },
    "additional_operands": [
     {
      "name": "compared_value",
      "title": "Compared Value",
      "kind": "any",
      "is_spread": false,
      "is_fixed_kind": false
     }
    ]
   },
   "in": {
    "allowed_data_types": [
     "uuid",
     "text",
     "version",
     "email",
     "timezone",
     "number",
     "unsigned_number",
     "decimal",
     "datetime"
    ],
    "operator_category": "polynary",
    "preview_template": "${target_value} IS EQUAL TO ANY OF ${spread}",
    "target_operand": {
     "name": "target_value",
     "title": "Target Value",
     "kind": "reference",
     "is_spread": false,
     "is_fixed_kind": true
    },
    "additional_operands": [
     {
      "name": "spread",
      "title": "Argument",
      "kind": "any",
      "is_spread": true,
      "is_fixed_kind": false
     }
    ]
   },
   "not-in": {
    "allowed_data_types": [
     "uuid",
     "text",
     "version",
     "email",
     "timezone",
     "number",
     "unsigned_number",
     "decimal",
     "datetime"
    ],
    "operator_category": "polynary",
    "preview_template": "${target_value} IS NOT EQUAL TO ANY OF ${spread}",
    "target_operand": {
     "name": "target_value",
     "title": "Target Value",
     "kind": "reference",
     "is_spread": false,
     "is_fixed_kind": true
    },
    "additional_operands": [
     {
      "name": "spread",
      "title": "Argument",
      "kind": "any",
      "is_spread": true,
      "is_fixed_kind": false
     }
    ]
   },
   "empty": {
    "allowed_data_types": [
     "uuid",
     "text",
     "version",
     "email",
     "timezone",
     "number",
     "unsigned_number",
     "decimal",
     "datetime",
     "boolean"
    ],
    "operator_category": "unary",
    "preview_template": "${target_value} IS EMPTY",
    "target_operand": {
     "name": "target_value",
     "title": "Target Value",
     "kind": "reference",
     "is_spread": false,
     "is_fixed_kind": true
    },
    "additional_operands": null
   },
   "not-empty": {
    "allowed_data_types": [
     "uuid",
     "text",
     "version",
     "email",
     "timezone",
     "number",
     "unsigned_number",
     "decimal",
     "datetime",
     "boolean"
    ],
    "operator_category": "unary",
    "preview_template": "${target_value} IS NOT EMPTY",
    "target_operand": {
     "name": "target_value",
     "title": "Target Value",
     "kind": "reference",
     "is_spread": false,
     "is_fixed_kind": true
    },
    "additional_operands": null
   }
  },
  "functions": {
   "contains": {
    "returned_data_type": "boolean",
    "category": "binary",
    "preview_template": "CONTAINS('${target_value}', '${substring_value}')",
    "arguments": [
     {
      "name": "target_value",
      "title": "Target Value",
      "kind": "any",
      "is_spread": false,
      "is_fixed_kind": false
     },
     {
      "name": "substring",
      "title": "Substring",
      "kind": "value",
      "is_spread": false,
      "is_fixed_kind": true
     }
    ],
    "argument_data_types": [
     "text",
     "email",
     "timezone",
     "version",
     "uuid"
    ]
   },
   "now": {
    "returned_data_type": "datetime",
    "category": "zero",
    "preview_template": "NOW()",
    "arguments": [],
    "argument_data_types": []
   },
   "date": {
    "returned_data_type": "datetime",
    "category": "unary",
    "preview_template": "DATE(${target_value})",
    "arguments": [
     {
      "name": "target_value",
      "title": "Target Value",
      "kind": "any",
      "is_spread": false,
      "is_fixed_kind": false
     }
    ],
    "argument_data_types": [
     "datetime"
    ]
   },
   "date_diff": {
    "returned_data_type": "number",
    "category": "binary",
    "preview_template": "DATEDIFF(${target_value}, ${compared_value})",
    "arguments": [
     {
      "name": "target_value",
      "title": "Target Value",
      "kind": "any",
      "is_spread": false,
      "is_fixed_kind": false
     },
     {
      "name": "compared_value",
      "title": "Compared Value",
      "kind": "any",
      "is_spread": false,
      "is_fixed_kind": false
     }
    ],
    "argument_data_types": [
     "datetime"
    ]
   },
   "date_add": {
    "returned_data_type": "datetime",
    "category": "binary",
    "preview_template": "${target_value} + ${duration}",
    "arguments": [
     {
      "name": "target_value",
      "title": "Target Value",
      "kind": "any",
      "is_spread": false,
      "is_fixed_kind": false
     },
     {
      "name": "duration",
      "title": "Duration",
      "kind": "value",
      "is_spread": false,
      "is_fixed_kind": true,
      "custom_value_type": "duration"
     }
    ],
    "argument_data_types": [
     "datetime"
    ]
   },
   "date_subtract": {
    "returned_data_type": "datetime",
    "category": "binary",
    "preview_template": "${target_value} - ${duration}",
    "arguments": [
     {
      "name": "target_value",
      "title": "Target Value",
      "kind": "any",
      "is_spread": false,
      "is_fixed_kind": false
     },
     {
      "name": "duration",
      "title": "Duration",
      "kind": "value",
      "is_spread": false,
      "is_fixed_kind": true,
      "custom_value_type": "duration"
     }
    ],
    "argument_data_types": [
     "datetime"
    ]
   }
  }
 }
}

values.json

[
 {
  "name": "customer_details",
  "label": "Customer Details",
  "data": [
   {
    "name": "email",
    "label": "Email",
    "operator": [
     "IN",
     "NOT_IN"
    ],
    "data": []
   },
   {
    "name": "timezone",
    "label": "Timezone",
    "operator": [
     "IN",
     "NOT_IN"
    ],
    "data": [
     "America/Chicago",
     "America/Denver",
     "America/Los_Angeles",
     "America/New_York"
    ]
   },
   {
    "name": "country",
    "label": "Country",
    "operator": [
     "IN",
     "NOT_IN"
    ],
    "data": [
     "US"
    ]
   },
   {
    "name": "language",
    "label": "Language",
    "operator": [
     "IN",
     "NOT_IN"
    ],
    "data": [
     "cs",
     "da",
     "de",
     "en",
     "es",
     "fi",
     "fr",
     "it",
     "ja",
     "ko",
     "nl",
     "no",
     "pl",
     "pt",
     "ru",
     "sv",
     "tr",
     "zh"
    ]
   }
  ]
 }
]