Last active
September 16, 2019 13:11
-
-
Save lempiy/b7537457879dcaaff1a2276197e59da3 to your computer and use it in GitHub Desktop.
preset
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"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 | |
} | |
] | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"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" | |
] | |
} | |
} | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[ | |
{ | |
"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" | |
] | |
} | |
] | |
} | |
] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment