Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
client_automations.sql
INSERT INTO `client_automations` (`client`, `source`, `status`, `credentials`, `rules`, `exclusions`, `created_timestamp`, `updated_timestamp`, `user`)
VALUES
(452,'servicetitan','active','{\"apiKey\":\"\",\"apiSecret\":\"\"}','[{\"settings\":{\"products\":[{\"code\":\"1\",\"qty\":1}],\"location\":\"7\",\"department\":null,\"cardType\":\"TY\"},\"conditions\":[{\"id\":\"0voXy6RCReZjFoa8HOQSi\",\"field\":\"invoice.total\",\"operator\":\"isMoreThan\",\"operand\":\"1.00\",\"operandType\":\"number\"}],\"isActive\":true,\"id\":\"v4sQi7iJJLl~FpKYAlaah\"}]',NULL,'2018-10-29 17:28:36','2018-10-29 17:34:14',2304),
(4799,'servicetitan','active','{\"apiKey\":\"\",\"apiSecret\":\"\"}','[{\"settings\":{\"products\":[{\"code\":\"1\",\"qty\":1}],\"location\":\"4579\",\"department\":\"4580\",\"cardType\":\"TY\"},\"conditions\":[{\"id\":\"0voXy6RCReZjFoa8HOQSi\",\"field\":\"invoice.total\",\"operator\":\"isMoreThan\",\"operand\":\"1.00\",\"operandType\":\"number\"}],\"isActive\":true,\"id\":\"v4sQi7iJJLl~FpKYAlaah\"}]',NULL,'2018-10-29 17:28:36','2018-10-29 17:57:18',1976),
(4883,'servicetitan','active','{\"apiKey\":\"\",\"apiSecret\":\"\"}','[{\"settings\":{\"products\":[{\"code\":\"1\",\"qty\":1}],\"location\":\"5021\",\"department\":\"5227\",\"cardType\":\"TY\"},\"conditions\":[{\"id\":\"0voXy6RCReZjFoa8HOQSi\",\"field\":\"invoice.total\",\"operator\":\"isMoreThan\",\"operand\":\"1.00\",\"operandType\":\"number\"}],\"isActive\":true,\"id\":\"v4sQi7iJJLl~FpKYAlaah\"}]',NULL,'2018-10-29 17:28:36','2018-10-29 18:04:05',2885),
(5200,'servicetitan','active','{\"apiKey\":\"\",\"apiSecret\":\"\"}','[{\"settings\":{\"products\":[{\"code\":\"1\",\"qty\":1}],\"location\":\"6898\",\"department\":null,\"cardType\":\"TY\"},\"conditions\":[{\"id\":\"0voXy6RCReZjFoa8HOQSi\",\"field\":\"invoice.total\",\"operator\":\"isMoreThan\",\"operand\":\"1.00\",\"operandType\":\"number\"}],\"isActive\":true,\"id\":\"v4sQi7iJJLl~FpKYAlaah\"}]',NULL,'2018-10-29 17:28:36','2018-10-29 18:12:57',2828),
(5439,'servicetitan','active','{\"apiKey\":\"\",\"apiSecret\":\"\"}','[{\"settings\":{\"products\":[{\"code\":\"7\",\"qty\":1}],\"location\":\"7914\",\"department\":\"7915\",\"cardType\":\"AP\"},\"conditions\":[{\"id\":\"0voXy6RCReZjFoa8HOQSi\",\"field\":\"invoice.total\",\"operator\":\"isMoreThan\",\"operand\":\"1000.00\",\"operandType\":\"number\"},{\"id\":\"kLQtLECw93b3KSHTU~qPw\",\"field\":\"businessUnit.name\",\"operator\":\"equals\",\"operand\":\"East\",\"operandType\":\"string\"}],\"isActive\":true,\"id\":\"v4sQi7iJJLl~FpKYAlaah\"},{\"isActive\":true,\"settings\":{\"products\":[{\"code\":\"1\",\"qty\":1}],\"location\":7914,\"department\":7915,\"cardType\":\"TY\"},\"conditions\":[{\"id\":\"5c2dXMovdS36QF69pWtPK\",\"field\":\"invoice.total\",\"operator\":\"doesNotEqual\",\"operand\":\"50.00\"},{\"id\":\"OC9xVaiAv~wnEmMM8hq0G\",\"field\":\"businessUnit.name\",\"operator\":\"isOneOf\",\"operand\":\"East,Main\"},{\"id\":\"XjemFF7X9f_yJK_vS2SHL\",\"field\":\"location.address.city\",\"operator\":\"equals\",\"operand\":\"Kennesaw\"}],\"id\":\"VWlzt2yP9KNHZzKxvXFkw\"},{\"isActive\":false,\"settings\":{\"products\":[{\"code\":\"2\",\"qty\":1}],\"location\":7914,\"department\":7915,\"cardType\":\"TY\"},\"conditions\":[{\"id\":\"5c2dXMovdS36QF69pWtPK\",\"field\":\"invoice.total\",\"operator\":\"doesNotEqual\",\"operand\":\"50.00\"},{\"id\":\"OC9xVaiAv~wnEmMM8hq0G\",\"field\":\"businessUnit.name\",\"operator\":\"isOneOf\",\"operand\":\"East,Main\"},{\"id\":\"XjemFF7X9f_yJK_vS2SHL\",\"field\":\"location.address.city\",\"operator\":\"equals\",\"operand\":\"Kennesaw\"}],\"id\":\"VWlzt2yP9KNHZzKxvXFkw\"}]','[{\"field\":\"customer.doNotMail\",\"operator\":\"equals\",\"operand\":true,\"id\":\"1f5xxvxMnBf~FLnlK5cco\"},{\"id\":\"UF~tNRfLFZkwKQQEVHtRr\",\"field\":\"customer.email\",\"operator\":\"equals\",\"operand\":\"donotmail@toyoursuccess.com\"}]','2018-09-17 20:56:41','2018-10-29 15:54:56',3284);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.