{"DataTypes":[{"Data":"[{\"Gid\": \"30834e13-c1f8-47a7-875e-3cda62cb1022\", \"Name\": \"Track email\", \"Type\": 2, \"DisplayName\": \"Track email\", \"IsDataModel\": true, \"IsPrimaryType\": false, \"DataPropertyList\": [{\"Gid\": \"7a262d1d-8ca5-44b6-a1fc-934529e94a04\", \"Name\": \"id\", \"IsList\": false, \"DataTypeGid\": \"0317bfee-b2f5-4bde-bfe8-121212121222\", \"DisplayName\": \"id\", \"JsonPropertyName\": \"id\", \"ParentDataTypeGid\": \"30834e13-c1f8-47a7-875e-3cda62cb1022\"}], \"CsharpCorrespondent\": 0}]","Attributes":[{"Id":"7a262d1d-8ca5-44b6-a1fc-934529e94a04","DataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121222","ParentDataTypeId":"30834e13-c1f8-47a7-875e-3cda62cb1022","Name":"id","DisplayName":"id","DataTypeName":null,"IsDataModel":false,"IsPrimaryType":false,"IsProcesio":false,"IsPublic":false,"CsharpCorrespondent":0,"Type":1,"IsList":false,"jsonProperty":"id","updatedOn":"0001-01-01T00:00:00","Attributes":[]}],"ParentIds":[],"Id":"30834e13-c1f8-47a7-875e-3cda62cb1022","Name":"Track email","DisplayName":"Track email","IsDataModel":true,"IsPrimaryType":false,"IsProcesio":false,"IsPublic":true,"CsharpCorrespondent":0,"Type":2,"updatedOn":"2023-05-03T10:40:31","createdOn":"2023-05-03T10:40:30","firstName":null,"lastName":null,"workspaceName":null},{"Data":"[{\"Gid\": \"eac29377-29eb-4dfd-a7d4-f65546a1a74c\", \"Name\": \"Track email\", \"Type\": 2, \"DisplayName\": \"Track email\", \"IsDataModel\": true, \"IsPrimaryType\": false, \"DataPropertyList\": [{\"Gid\": \"b718aa7b-2a42-49bc-8928-27134ba108f9\", \"Name\": \"id\", \"IsList\": false, \"DataTypeGid\": \"0317bfee-b2f5-4bde-bfe8-121212121222\", \"DisplayName\": \"id\", \"JsonPropertyName\": \"id\", \"ParentDataTypeGid\": \"eac29377-29eb-4dfd-a7d4-f65546a1a74c\"}], \"CsharpCorrespondent\": 0}]","Attributes":[{"Id":"b718aa7b-2a42-49bc-8928-27134ba108f9","DataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121222","ParentDataTypeId":"eac29377-29eb-4dfd-a7d4-f65546a1a74c","Name":"id","DisplayName":"id","DataTypeName":null,"IsDataModel":false,"IsPrimaryType":false,"IsProcesio":false,"IsPublic":false,"CsharpCorrespondent":0,"Type":1,"IsList":false,"jsonProperty":"id","updatedOn":"0001-01-01T00:00:00","Attributes":[]}],"ParentIds":[],"Id":"eac29377-29eb-4dfd-a7d4-f65546a1a74c","Name":"Track email","DisplayName":"Track email","IsDataModel":true,"IsPrimaryType":false,"IsProcesio":false,"IsPublic":true,"CsharpCorrespondent":0,"Type":2,"updatedOn":"2023-05-03T10:25:52","createdOn":"2023-05-03T10:25:51","firstName":null,"lastName":null,"workspaceName":null}],"Credentials":[{"properties":[{"id":"40404040-0001-0001-0000-bbbbbbbbbbbb","value":"40404040-0001-0001-0001-cccccccccccc"},{"id":"40404040-0001-0002-0000-bbbbbbbbbbbb","value":"40404040-0001-0002-0001-cccccccccccc"},{"id":"40404040-0001-0003-0000-bbbbbbbbbbbb","value":"SQL Server path"},{"id":"40404040-0001-0004-0000-bbbbbbbbbbbb","value":"1433"},{"id":"40404040-0001-0005-0000-bbbbbbbbbbbb","value":"DB name"},{"id":"40404040-0001-0006-0000-bbbbbbbbbbbb","value":"40404040-0001-0006-0001-cccccccccccc"},{"id":"40404040-0001-0007-0000-bbbbbbbbbbbb","value":"40404040-0001-0007-0001-cccccccccccc"},{"id":"40404040-0001-0008-0000-bbbbbbbbbbbb","value":"40404040-0001-0008-0001-cccccccccccc"},{"id":"40404040-0001-0009-0000-bbbbbbbbbbbb","value":"40404040-0001-0009-0001-cccccccccccc"},{"id":"40404040-0001-0010-0000-bbbbbbbbbbbb","value":"SQL DB user"},{"id":"40404040-0001-0011-0000-bbbbbbbbbbbb","value":"password"}],"gid":"245a8e77-6043-4704-9bc3-b3a63ed890fc","gtid":"40404040-0001-0000-0000-aaaaaaaaaaaa","name":"SQL DB credential","tname":null,"type":null,"status":true,"description":null,"createdOn":"2023-05-03T10:25:51","updatedOn":"2023-05-03T10:25:52","firstName":null,"lastName":null,"workspaceName":null},{"properties":[{"id":"20202020-0001-0002-0000-bbbbbbbbbbbb","value":"SMTP server"},{"id":"20202020-0001-0004-0000-bbbbbbbbbbbb","value":"587"},{"id":"20202020-0001-0005-0000-bbbbbbbbbbbb","value":"20202020-0001-0005-0003-cccccccccccc"},{"id":"20202020-0001-0006-0000-bbbbbbbbbbbb","value":"username"},{"id":"20202020-0001-0007-0000-bbbbbbbbbbbb","value":"password"},{"id":"20202020-0001-0008-0000-bbbbbbbbbbbb","value":""}],"gid":"93e7c6fb-202c-4cfa-93b8-cfbbad0e7f62","gtid":"20202020-0001-0000-0000-aaaaaaaaaaaa","name":"SMTP credential 2","tname":null,"type":null,"status":true,"description":null,"createdOn":"2023-05-03T10:25:51","updatedOn":"2023-05-03T10:25:52","firstName":null,"lastName":null,"workspaceName":null}],"Webhooks":[{"DataModelId":"30834e13-c1f8-47a7-875e-3cda62cb1022","Type":1,"Definition":"{\"id\": \"7822f7b2-0333-4c89-aebc-2c128869cdbf\"}","IsEdited":null,"DataModel":null,"CreatedOn":"2023-05-03T10:40:31","UpdatedOn":"2023-05-03T10:40:31","Id":"7822f7b2-0333-4c89-aebc-2c128869cdbf","Name":"Track email"}],"DocumentTemplates":[],"Flows":[{"UsedInFlows":"[]","Variables":[{"Id":"a2f9078c-8ae5-4206-a1b7-bf1c8335a875","ContextId":null,"DataType":"0317bfee-b2f5-4bde-bfe8-121212121221","Type":20,"Name":"QueryOUT","DefaultValue":null,"IsList":false},{"Id":"b8f06a74-d858-474b-a665-b221fef30f48","ContextId":null,"DataType":"30834e13-c1f8-47a7-875e-3cda62cb1022","Type":10,"Name":"TrackEmail","DefaultValue":"","IsList":false}],"Actions":[{"Id":"8c7f7fa6-2903-4ddc-b2a0-7e0b88dde085","FlowId":"fd51850b-6a55-46ea-83ef-85ec04c97b43","TemplateId":"c0e32108-6e3e-4ab8-96bd-cd61be6edb33","ParentId":null,"Status":1,"Category":"cat1","Ports":[{"Id":"d1a6b0e5-728f-4908-a830-c49792adda71","FlowId":"fd51850b-6a55-46ea-83ef-85ec04c97b43","SourceId":"8c7f7fa6-2903-4ddc-b2a0-7e0b88dde085","DestinationId":"826a0821-0527-4780-960a-442da452a20d","Type":0,"State":1,"Data":{},"Errors":{},"Config":{}},{"Id":"e43a418a-5c4a-479c-9a65-0dff2dc43b0d","FlowId":"fd51850b-6a55-46ea-83ef-85ec04c97b43","SourceId":"00000000-0000-0000-0000-000000000000","DestinationId":"8c7f7fa6-2903-4ddc-b2a0-7e0b88dde085","Type":0,"State":1,"Data":null,"Errors":null,"Config":{}}],"Parameters":[],"CustomData":{"type":"square","name":"Start","description":"Process starts","icon":"icon-start","position":{"x":575.91,"y":516},"configuration":[{"id":"c0e32108-6e3e-4ab8-96bd-cd61be6edb35","label":"Details","settings":[]}],"inputPorts":0,"outputPorts":1,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""},{"Id":"ed7e9611-2a21-4eca-88d0-b6c6b543df0c","FlowId":"fd51850b-6a55-46ea-83ef-85ec04c97b43","TemplateId":"c0e32108-6e3e-4ab8-96bd-cd61be6edb34","ParentId":null,"Status":1,"Category":"cat1","Ports":[],"Parameters":[],"CustomData":{"type":"square","name":"Stop","description":"Process stops","icon":"icon-stop","position":{"x":1557.0900000000001,"y":516},"configuration":[{"id":"c0e32108-6e3e-4ab8-96bd-cd61be6edb37","label":"Details","settings":[]}],"inputPorts":1,"outputPorts":0,"wasDropped":true,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""},{"Id":"826a0821-0527-4780-960a-442da452a20d","FlowId":"fd51850b-6a55-46ea-83ef-85ec04c97b43","TemplateId":"c2760ff2-cd9e-49b4-b751-c05c88e06dac","ParentId":null,"Status":1,"Category":"cat1","Ports":[{"Id":"a3180289-fced-42dc-b213-075243ef2813","FlowId":"fd51850b-6a55-46ea-83ef-85ec04c97b43","SourceId":"826a0821-0527-4780-960a-442da452a20d","DestinationId":"ed7e9611-2a21-4eca-88d0-b6c6b543df0c","Type":0,"State":1,"Data":{},"Errors":{},"Config":{}}],"Parameters":[{"TabPropertyId":"6701cb8b-3bde-4c7e-a45d-c37eaeff5e3d","Variable":[],"Value":"245a8e77-6043-4704-9bc3-b3a63ed890fc"},{"TabPropertyId":"53896b0d-73a6-412f-9e67-224ca1daae7c","Variable":[],"Value":"EXEC dbo.EmailOpened_Register @EmailGUID = N'<%TrackEmail.id%>'"},{"TabPropertyId":"f3452b3a-2c10-40df-9d34-2d2779dc6ed7","Variable":[{"id":0,"variableId":"a2f9078c-8ae5-4206-a1b7-bf1c8335a875","attribute":null}],"Value":"<%0%>"}],"CustomData":{"type":"square","name":"Track email in DB","description":"Execute a custom SQL Command on the target database.","icon":"format_indent_increase","position":{"x":991.8025104671019,"y":516.1468766185443},"configuration":[{"id":"5f578038-3d43-4f3f-871c-cae998520d92","label":"Details","orderId":0,"settings":[{"id":"6701cb8b-3bde-4c7e-a45d-c37eaeff5e3d","dataTypeId":null,"label":"Select Database Server","type":"credentials","language":null,"credentialsTemplateId":"40404040-0001-0000-0000-aaaaaaaaaaaa","value":"245a8e77-6043-4704-9bc3-b3a63ed890fc","options":null,"isRequired":true,"expects":null,"isList":false,"direction":1,"rowId":0,"columnId":0,"tooltip":"Database Server Configuration","limits":null,"internalId":"365ca8ba-9766-4931-9f7e-1b150f523286","status":{"type":"danger","message":[]}},{"id":"fea72099-4718-473d-a091-7749aa38305b","dataTypeId":null,"label":"Execute Command","type":"side-pannel","language":null,"credentialsTemplateId":null,"value":[{"id":"53896b0d-73a6-412f-9e67-224ca1daae7c","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121221","label":"Command","type":"code-editor","language":"sql","credentialsTemplateId":null,"value":"EXEC dbo.EmailOpened_Register @EmailGUID = N'<%TrackEmail.id%>'","options":null,"isRequired":true,"expects":null,"isList":false,"direction":1,"rowId":0,"columnId":0,"tooltip":"SQL Command","limits":null,"internalId":"7f4cd6d1-a640-4881-8cda-92f87ca2711f","status":{"type":"danger","message":[]}},{"id":"f3452b3a-2c10-40df-9d34-2d2779dc6ed7","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121221","label":"Output","type":"number","language":null,"credentialsTemplateId":null,"value":"a2f9078c-8ae5-4206-a1b7-bf1c8335a875","options":null,"isRequired":true,"expects":null,"isList":false,"direction":3,"rowId":1,"columnId":0,"tooltip":"Integer value representing the result based on what SQL commands were executed.","limits":null,"internalId":"ae460ba7-f2d1-48a8-be34-fcbf50af77e7","status":{"type":"danger","message":[]}}],"options":null,"isRequired":null,"expects":null,"isList":false,"direction":null,"rowId":1,"columnId":0,"tooltip":null,"limits":null,"internalId":"02cbcc97-aa47-43b4-9282-21da185b0829"}]}],"inputPorts":1,"outputPorts":1,"wasDropped":true,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""}],"Webhooks":[{"Id":"56445a46-1886-4971-856a-a93ba467f985","WebhookId":"7822f7b2-0333-4c89-aebc-2c128869cdbf","VariableId":"b8f06a74-d858-474b-a665-b221fef30f48","IsObsoleted":false,"FilterRules":{"Value":[],"Parameters":[]}}],"Id":"fd51850b-6a55-46ea-83ef-85ec04c97b43","ParentId":null,"Status":1,"Title":"Email track/2. Get &amp;amp; Save to DB tracking data","Description":"","IsValid":true,"Active":true,"IsNotification":false,"createdOn":"2023-05-03T10:25:52","updatedOn":"2023-05-03T10:40:47","firstName":null,"lastName":null,"workspaceName":null},{"UsedInFlows":"[]","Variables":[{"Id":"82e9b8bb-86e8-41a5-a7ad-f1ebefc82016","ContextId":null,"DataType":"0317bfee-b2f5-4bde-bfe8-121212121214","Type":10,"Name":"EmailBody","DefaultValue":null,"IsList":false},{"Id":"4fb6c0c5-a13c-4955-aeef-c00c8d167c78","ContextId":null,"DataType":"0317bfee-b2f5-4bde-bfe8-121212121214","Type":10,"Name":"ToEmail","DefaultValue":null,"IsList":false},{"Id":"b32b2e6f-d43f-4d7b-9afe-b7cc9e9c70d0","ContextId":null,"DataType":"0317bfee-b2f5-4bde-bfe8-121212121214","Type":10,"Name":"EmailSubject","DefaultValue":null,"IsList":false}],"Actions":[{"Id":"352f78b7-bf96-4dc4-9023-1d33eb407d57","FlowId":"04f73dc6-5889-4d7e-af27-6d15d61a80b6","TemplateId":"c0e32108-6e3e-4ab8-96bd-cd61be6edb33","ParentId":null,"Status":1,"Category":"cat1","Ports":[{"Id":"ed3eca19-bd87-4105-9b19-06060d072bee","FlowId":"04f73dc6-5889-4d7e-af27-6d15d61a80b6","SourceId":"352f78b7-bf96-4dc4-9023-1d33eb407d57","DestinationId":"7abbfd68-851f-49d5-a454-a91e71cddf09","Type":0,"State":1,"Data":{},"Errors":{},"Config":{}},{"Id":"15bd70b1-4539-49f1-8ae4-19865ecf415c","FlowId":"04f73dc6-5889-4d7e-af27-6d15d61a80b6","SourceId":"00000000-0000-0000-0000-000000000000","DestinationId":"352f78b7-bf96-4dc4-9023-1d33eb407d57","Type":0,"State":1,"Data":null,"Errors":null,"Config":{}}],"Parameters":[],"CustomData":{"type":"square","name":"Start (1)","description":"Process starts","icon":"icon-start","position":{"x":575.91,"y":516},"configuration":[{"id":"c0e32108-6e3e-4ab8-96bd-cd61be6edb35","label":"Details","settings":[]}],"inputPorts":0,"outputPorts":1,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""},{"Id":"7abbfd68-851f-49d5-a454-a91e71cddf09","FlowId":"04f73dc6-5889-4d7e-af27-6d15d61a80b6","TemplateId":"c37e56fe-d924-4604-a86f-7c93f863fcdf","ParentId":null,"Status":1,"Category":"cat1","Ports":[{"Id":"aa469ca6-738b-42a6-b7aa-55afe47cb137","FlowId":"04f73dc6-5889-4d7e-af27-6d15d61a80b6","SourceId":"7abbfd68-851f-49d5-a454-a91e71cddf09","DestinationId":"79426bf9-b5aa-40df-a579-5705602942d5","Type":0,"State":1,"Data":{},"Errors":{},"Config":{}}],"Parameters":[{"TabPropertyId":"d2831844-54a5-42e7-a101-119e21a03fe2","Variable":[],"Value":"00000000-0000-0000-0000-000000000000"},{"TabPropertyId":"bc93d0be-98f6-42d6-b2ac-a782eadd79bf","Variable":[],"Value":"0f329bca-4123-4f62-a094-6e78ae1031e9"},{"TabPropertyId":"62cdd318-b8d7-4d64-8a9c-577ec459045a","Variable":[],"Value":[{"id":0,"source":{"value":"<%1%>","variable":[{"id":1,"variableId":"4fb6c0c5-a13c-4955-aeef-c00c8d167c78","attribute":null}]},"destination":{"id":0,"variableId":"33d78462-c1c2-4104-ad71-b6f462c9cbbd","attribute":null}},{"id":3,"source":{"value":"<%3%>","variable":[{"id":3,"variableId":"82e9b8bb-86e8-41a5-a7ad-f1ebefc82016","attribute":null}]},"destination":{"id":2,"variableId":"c8cba51a-fef7-4169-8414-b9e55846a342","attribute":null}},{"id":4,"source":{"value":"<%5%>","variable":[{"id":5,"variableId":"b32b2e6f-d43f-4d7b-9afe-b7cc9e9c70d0","attribute":null}]},"destination":{"id":4,"variableId":"5e987b8b-c21d-4733-a2ac-b31457a3b124","attribute":null}}]},{"TabPropertyId":"d2831844-54a5-42e7-a101-119e21a03fe1","Variable":[],"Value":[]}],"CustomData":{"type":"square","name":"Send tracked email","description":"Enable users to use the published processes within another (parent) process. When a parent process calls a child process (subprocess), the child process executes in a sequential manner and once complete, the execution control then transfers to the main parent process. If you want to map input / output variables between process and subprocess go to Input & Output tab.","icon":"settings_applications","position":{"x":821.9276427011633,"y":516.2233917315716},"configuration":[{"id":"9a1321d7-5526-4a2a-a400-46b7157beb6d","label":"Details","orderId":0,"settings":[{"id":"d2831844-54a5-42e7-a101-119e21a03fe2","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121222","label":"Id of the started flow","type":"ignore","language":null,"credentialsTemplateId":null,"value":"00000000-0000-0000-0000-000000000000","options":null,"isRequired":false,"expects":null,"isList":false,"direction":2,"rowId":0,"columnId":0,"tooltip":"Id of the started flow","limits":null,"internalId":"4651146b-4269-415e-93e6-615eae135b7b"},{"id":"bc93d0be-98f6-42d6-b2ac-a782eadd79bf","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121222","label":"Select Subprocess","type":"flow-list","language":null,"credentialsTemplateId":null,"value":"0f329bca-4123-4f62-a094-6e78ae1031e9","options":null,"isRequired":true,"expects":null,"isList":false,"direction":2,"rowId":0,"columnId":0,"tooltip":null,"limits":null,"internalId":"5331b1af-fb72-4916-b9ee-9307bd2d4405","status":{"type":"danger","message":[]}},{"id":"5456caf0-be8e-4a04-86cb-dbae203af978","dataTypeId":null,"label":"Subprocess Configuration","type":"side-pannel","language":null,"credentialsTemplateId":null,"value":[{"id":"62cdd318-b8d7-4d64-8a9c-577ec459045a","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121221","label":"Input Variables","type":"process-inputs","language":null,"credentialsTemplateId":null,"value":[{"id":0,"subprocess":"33d78462-c1c2-4104-ad71-b6f462c9cbbd","process":"4fb6c0c5-a13c-4955-aeef-c00c8d167c78"},{"id":3,"subprocess":"c8cba51a-fef7-4169-8414-b9e55846a342","process":"82e9b8bb-86e8-41a5-a7ad-f1ebefc82016"},{"id":4,"subprocess":"5e987b8b-c21d-4733-a2ac-b31457a3b124","process":"b32b2e6f-d43f-4d7b-9afe-b7cc9e9c70d0"}],"options":null,"isRequired":false,"expects":null,"isList":false,"direction":1,"rowId":0,"columnId":0,"tooltip":"Map variables to pass data from parent process to subprocess. On the left side, you have subprocess input variables that will receive data from the parent process.","limits":null,"internalId":"bb67813d-0310-4881-8f91-3120514ce224","status":{"type":"danger","message":[]}},{"id":"d2831844-54a5-42e7-a101-119e21a03fe1","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121221","label":"Output Variables","type":"process-outputs","language":null,"credentialsTemplateId":null,"value":[],"options":null,"isRequired":false,"expects":null,"isList":false,"direction":2,"rowId":1,"columnId":0,"tooltip":"Map variables to pass data from subprocess to parent process. On the left side, you have subprocess output variables that will pass data to parent process.","limits":null,"internalId":"b9dd1115-8d04-41c4-97e0-772fe649529c","status":{"type":"danger","message":[]}}],"options":null,"isRequired":null,"expects":null,"isList":false,"direction":null,"rowId":1,"columnId":0,"tooltip":null,"limits":null,"internalId":"221973a2-0963-4072-804a-365bb3fbc283"}]}],"inputPorts":1,"outputPorts":1,"wasDropped":true,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""},{"Id":"79426bf9-b5aa-40df-a579-5705602942d5","FlowId":"04f73dc6-5889-4d7e-af27-6d15d61a80b6","TemplateId":"c0e32108-6e3e-4ab8-96bd-cd61be6edb34","ParentId":null,"Status":1,"Category":"cat1","Ports":[],"Parameters":[],"CustomData":{"type":"square","name":"Stop","description":"Process stops","icon":"icon-stop","position":{"x":1056.1582952015465,"y":515.9986326254955},"configuration":[{"id":"c0e32108-6e3e-4ab8-96bd-cd61be6edb37","label":"Details","settings":[]}],"inputPorts":1,"outputPorts":0,"wasDropped":true,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""}],"Webhooks":[],"Id":"04f73dc6-5889-4d7e-af27-6d15d61a80b6","ParentId":null,"Status":1,"Title":"Send emails","Description":"","IsValid":true,"Active":true,"IsNotification":false,"createdOn":"2023-05-03T10:25:52","updatedOn":"2023-05-03T10:31:17","firstName":null,"lastName":null,"workspaceName":null},{"UsedInFlows":"[\"04f73dc6-5889-4d7e-af27-6d15d61a80b6\"]","Variables":[{"Id":"5233e38f-0e72-4322-89dc-1bc56efe830f","ContextId":null,"DataType":"0317bfee-b2f5-4bde-bfe8-121212121222","Type":20,"Name":"EmailGUID","DefaultValue":null,"IsList":false},{"Id":"68d1bf95-b8b1-4c76-b866-634fbaea5683","ContextId":null,"DataType":"0317bfee-b2f5-4bde-bfe8-121212121214","Type":10,"Name":"EmailBCC","DefaultValue":null,"IsList":false},{"Id":"5ae50d17-e0f8-4b18-b1d4-6d7c1b62eda0","ContextId":null,"DataType":"0317bfee-b2f5-4bde-bfe8-121212121214","Type":10,"Name":"EmailCC","DefaultValue":null,"IsList":false},{"Id":"33d78462-c1c2-4104-ad71-b6f462c9cbbd","ContextId":null,"DataType":"0317bfee-b2f5-4bde-bfe8-121212121214","Type":10,"Name":"EmailTo","DefaultValue":null,"IsList":false},{"Id":"5e987b8b-c21d-4733-a2ac-b31457a3b124","ContextId":null,"DataType":"0317bfee-b2f5-4bde-bfe8-121212121214","Type":10,"Name":"EmailSubject","DefaultValue":null,"IsList":false},{"Id":"c8cba51a-fef7-4169-8414-b9e55846a342","ContextId":null,"DataType":"0317bfee-b2f5-4bde-bfe8-121212121214","Type":10,"Name":"EmailBody","DefaultValue":null,"IsList":false},{"Id":"81f5c12a-200f-4665-9811-4ec68030e154","ContextId":null,"DataType":"0317bfee-b2f5-4bde-bfe8-121212121214","Type":20,"Name":"EncodedTrackingURL","DefaultValue":null,"IsList":false},{"Id":"40400b10-a15d-46a0-998d-d21a6d2c0dc9","ContextId":null,"DataType":"0317bfee-b2f5-4bde-bfe8-121212121221","Type":20,"Name":"QueryOUT","DefaultValue":null,"IsList":false},{"Id":"12292b98-3e62-4a9e-9d62-db4942d79cca","ContextId":null,"DataType":"10c6ac59-3929-49e6-99dc-121212121219","Type":10,"Name":"AttachmentList","DefaultValue":null,"IsList":true},{"Id":"7291a17d-8341-4e0d-927d-c0d75e80fc27","ContextId":null,"DataType":"0317bfee-b2f5-4bde-bfe8-121212121214","Type":20,"Name":"EmailBodySQL","DefaultValue":null,"IsList":false},{"Id":"bff0ace2-acdc-4f46-9ecf-3f45e4a23824","ContextId":null,"DataType":"0317bfee-b2f5-4bde-bfe8-121212121214","Type":20,"Name":"EmailSubjectSQL","DefaultValue":null,"IsList":false}],"Actions":[{"Id":"60d8378f-8ebc-4959-946c-0e705f51f6ae","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","TemplateId":"c0e32108-6e3e-4ab8-96bd-cd61be6edb33","ParentId":null,"Status":1,"Category":"cat1","Ports":[{"Id":"b47c42ac-7815-4601-af1e-ba80a9fa25e9","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","SourceId":"60d8378f-8ebc-4959-946c-0e705f51f6ae","DestinationId":"d5907a69-7fca-4cf9-b13b-415ace010ffa","Type":0,"State":1,"Data":{},"Errors":{},"Config":{}},{"Id":"e198adf9-e2fd-4e4f-9ab2-360f90cda904","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","SourceId":"00000000-0000-0000-0000-000000000000","DestinationId":"60d8378f-8ebc-4959-946c-0e705f51f6ae","Type":0,"State":1,"Data":null,"Errors":null,"Config":{}}],"Parameters":[],"CustomData":{"type":"square","name":"Start","description":"Process starts","icon":"icon-start","position":{"x":575.91,"y":516},"configuration":[{"id":"c0e32108-6e3e-4ab8-96bd-cd61be6edb35","label":"Details","settings":[]}],"inputPorts":0,"outputPorts":1,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""},{"Id":"d5c42d66-4477-48c2-a12b-38c6e09e75a0","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","TemplateId":"3fdae170-02ac-4a13-9a81-0cb402010107","ParentId":null,"Status":1,"Category":"cat1","Ports":[{"Id":"043670ef-4458-4e99-9c23-5e6108f596cd","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","SourceId":"d5c42d66-4477-48c2-a12b-38c6e09e75a0","DestinationId":"b3b6d1ae-a029-4783-8677-129c378ed1f0","Type":0,"State":1,"Data":{},"Errors":{},"Config":{}}],"Parameters":[{"TabPropertyId":"eed5fd3f-73b5-4b71-8b5f-0dc1db6e1001","Variable":[{"id":0,"variableId":"5233e38f-0e72-4322-89dc-1bc56efe830f","attribute":null}],"Value":"{\"id\":\"<%0%>\"}"},{"TabPropertyId":"af0033db-2b41-46cd-804e-75a6f7b42001","Variable":[{"id":1,"variableId":"81f5c12a-200f-4665-9811-4ec68030e154","attribute":null}],"Value":"<%1%>"}],"CustomData":{"type":"square","name":"Encode tracking URL","description":"Returns an URL encoded value of a string.","icon":"enhanced_encryption","position":{"x":1097.320241785409,"y":516.1468766185443},"configuration":[{"id":"3fdae170-02ac-4a13-9a81-0cb402011107","label":"Details","orderId":0,"settings":[{"id":"eed5fd3f-73b5-4b71-8b5f-0dc1db6e1001","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"Input String","type":"text","language":null,"credentialsTemplateId":null,"value":"{\"id\":\"5233e38f-0e72-4322-89dc-1bc56efe830f\"}","options":null,"isRequired":true,"expects":null,"isList":false,"direction":1,"rowId":1,"columnId":0,"tooltip":"Input String","limits":null,"internalId":"9d08a639-69e9-4c09-8d58-94a57af79caa","status":{"type":"danger","message":[]}},{"id":"af0033db-2b41-46cd-804e-75a6f7b42001","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"URL Encoded string","type":"text","language":null,"credentialsTemplateId":null,"value":"81f5c12a-200f-4665-9811-4ec68030e154","options":null,"isRequired":true,"expects":null,"isList":false,"direction":3,"rowId":2,"columnId":0,"tooltip":"URL Encoded string","limits":null,"internalId":"1311eac8-a285-42a4-800b-0dd0044376c4","status":{"type":"danger","message":[]}}]}],"inputPorts":1,"outputPorts":1,"wasDropped":true,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""},{"Id":"d5907a69-7fca-4cf9-b13b-415ace010ffa","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","TemplateId":"77f61c6d-53d4-d940-b350-84621850b35f","ParentId":null,"Status":1,"Category":"cat1","Ports":[{"Id":"2be21f58-1b70-4ec5-9e1f-cbe89a45bcda","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","SourceId":"d5907a69-7fca-4cf9-b13b-415ace010ffa","DestinationId":"b258ebc6-16db-41a8-9718-5862b72df267","Type":0,"State":1,"Data":{},"Errors":{},"Config":{}}],"Parameters":[{"TabPropertyId":"2a181416-8a7e-d244-85ed-ffa07c571da1","Variable":[{"id":0,"variableId":"5233e38f-0e72-4322-89dc-1bc56efe830f","attribute":null}],"Value":"<%0%>"}],"CustomData":{"type":"square","name":"EmailGuid","description":"Generates a GUID value.","icon":"vpn_key","position":{"x":727.4528391778612,"y":516.1468766185443},"configuration":[{"id":"1dd2baa8-22cb-344f-9456-a0ba093dfcee","label":"Configuration Tab","orderId":0,"settings":[{"id":"2a181416-8a7e-d244-85ed-ffa07c571da1","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121222","label":"Guid","type":"datatype","language":null,"credentialsTemplateId":null,"value":"5233e38f-0e72-4322-89dc-1bc56efe830f","options":null,"isRequired":true,"expects":null,"isList":false,"direction":3,"rowId":1,"columnId":0,"tooltip":"Generated guid.","limits":null,"internalId":"10cb9ee1-fe52-43f0-99be-ae999db0f331","status":{"type":"danger","message":[]}}]}],"inputPorts":1,"outputPorts":1,"wasDropped":true,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""},{"Id":"62d580cb-d4a1-4fe7-9613-147b0147cddd","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","TemplateId":"c2760ff2-cd9e-49b4-b751-c05c88e06dac","ParentId":null,"Status":1,"Category":"cat1","Ports":[{"Id":"f6bf5514-d09b-4425-956d-28d9cbb00a83","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","SourceId":"62d580cb-d4a1-4fe7-9613-147b0147cddd","DestinationId":"d5c42d66-4477-48c2-a12b-38c6e09e75a0","Type":0,"State":1,"Data":{},"Errors":{},"Config":{}}],"Parameters":[{"TabPropertyId":"6701cb8b-3bde-4c7e-a45d-c37eaeff5e3d","Variable":[],"Value":"245a8e77-6043-4704-9bc3-b3a63ed890fc"},{"TabPropertyId":"53896b0d-73a6-412f-9e67-224ca1daae7c","Variable":[{"id":0,"variableId":"5233e38f-0e72-4322-89dc-1bc56efe830f","attribute":null},{"id":1,"variableId":"33d78462-c1c2-4104-ad71-b6f462c9cbbd","attribute":null},{"id":2,"variableId":"5ae50d17-e0f8-4b18-b1d4-6d7c1b62eda0","attribute":null},{"id":3,"variableId":"68d1bf95-b8b1-4c76-b866-634fbaea5683","attribute":null},{"id":4,"variableId":"bff0ace2-acdc-4f46-9ecf-3f45e4a23824","attribute":null},{"id":5,"variableId":"7291a17d-8341-4e0d-927d-c0d75e80fc27","attribute":null}],"Value":"EXEC dbo.Email_Register @EmailGUID = N'<%0%>',\r\n                        @SentTo = N'<%1%>',\r\n                        @SentCC = N'<%2%>',\r\n                        @SentBCC = N'<%3%>',\r\n                        @Subject = N'<%4%>',\r\n                        @Body = N'<%5%>'"},{"TabPropertyId":"f3452b3a-2c10-40df-9d34-2d2779dc6ed7","Variable":[{"id":6,"variableId":"40400b10-a15d-46a0-998d-d21a6d2c0dc9","attribute":null}],"Value":"<%6%>"}],"CustomData":{"type":"square","name":"Register Email","description":"Execute a custom SQL Command on the target database.","icon":"format_indent_increase","position":{"x":922.9383319174536,"y":516.1468156357556},"configuration":[{"id":"5f578038-3d43-4f3f-871c-cae998520d92","label":"Details","orderId":0,"settings":[{"id":"6701cb8b-3bde-4c7e-a45d-c37eaeff5e3d","dataTypeId":null,"label":"Select Database Server","type":"credentials","language":null,"credentialsTemplateId":"40404040-0001-0000-0000-aaaaaaaaaaaa","value":"245a8e77-6043-4704-9bc3-b3a63ed890fc","options":null,"isRequired":true,"expects":null,"isList":false,"direction":1,"rowId":0,"columnId":0,"tooltip":"Database Server Configuration","limits":null,"internalId":"eea5727d-757d-4afa-8a65-2491dcbf4011","status":{"type":"danger","message":[]}},{"id":"fea72099-4718-473d-a091-7749aa38305b","dataTypeId":null,"label":"Execute Command","type":"side-pannel","language":null,"credentialsTemplateId":null,"value":[{"id":"53896b0d-73a6-412f-9e67-224ca1daae7c","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121221","label":"Command","type":"code-editor","language":"sql","credentialsTemplateId":null,"value":"EXEC dbo.Email_Register @EmailGUID = N'5233e38f-0e72-4322-89dc-1bc56efe830f',\r\n                        @SentTo = N'33d78462-c1c2-4104-ad71-b6f462c9cbbd',\r\n                        @SentCC = N'5ae50d17-e0f8-4b18-b1d4-6d7c1b62eda0',\r\n                        @SentBCC = N'68d1bf95-b8b1-4c76-b866-634fbaea5683',\r\n                        @Subject = N'bff0ace2-acdc-4f46-9ecf-3f45e4a23824',\r\n                        @Body = N'7291a17d-8341-4e0d-927d-c0d75e80fc27'","options":null,"isRequired":true,"expects":null,"isList":false,"direction":1,"rowId":0,"columnId":0,"tooltip":"SQL Command","limits":null,"internalId":"0c19c672-fc98-4351-900c-fbd8c9e217b4","status":{"type":"danger","message":[]}},{"id":"f3452b3a-2c10-40df-9d34-2d2779dc6ed7","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121221","label":"Output","type":"number","language":null,"credentialsTemplateId":null,"value":"40400b10-a15d-46a0-998d-d21a6d2c0dc9","options":null,"isRequired":true,"expects":null,"isList":false,"direction":3,"rowId":1,"columnId":0,"tooltip":"Integer value representing the result based on what SQL commands were executed.","limits":null,"internalId":"0fd34a17-1ccc-425d-8e80-c352087c3ceb","status":{"type":"danger","message":[]}}],"options":null,"isRequired":null,"expects":null,"isList":false,"direction":null,"rowId":1,"columnId":0,"tooltip":null,"limits":null,"internalId":"d6667ec7-6762-4ced-b013-77661bbc71e3"}]}],"inputPorts":1,"outputPorts":1,"wasDropped":true,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""},{"Id":"b258ebc6-16db-41a8-9718-5862b72df267","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","TemplateId":"6ddf806a-612e-4bf1-aa20-cc1dab576b02","ParentId":null,"Status":1,"Category":"cat1","Ports":[{"Id":"f492ee48-4b6f-46e8-9227-19067e7496ec","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","SourceId":"b258ebc6-16db-41a8-9718-5862b72df267","DestinationId":"8a2d3fad-e326-4a05-871f-d75d92ec4432","Type":0,"State":1,"Data":{},"Errors":{},"Config":{}}],"Parameters":[{"TabPropertyId":"13b56034-3fea-47b9-b060-63a70e0744ca","Variable":[{"id":0,"variableId":"5e987b8b-c21d-4733-a2ac-b31457a3b124","attribute":null}],"Value":"<%0%>"},{"TabPropertyId":"05ccbb02-9ac0-431b-aa87-f8eb2de4389a","Variable":[],"Value":"'"},{"TabPropertyId":"ff90350d-d905-4f35-8f69-293ec2001880","Variable":[],"Value":"''"},{"TabPropertyId":"e4f0fc87-01fc-4194-a65d-33eea4bb041e","Variable":[],"Value":true},{"TabPropertyId":"03952913-f4b2-404a-a3a9-781bec674532","Variable":[{"id":1,"variableId":"bff0ace2-acdc-4f46-9ecf-3f45e4a23824","attribute":null}],"Value":"<%1%>"}],"CustomData":{"type":"square","name":"Replace ' - Subject","description":"Searches a string for a specified value and returns a new string where the specified value(s) are replaced","icon":"find_replace","position":{"x":727.452839177861,"y":637.5796975819763},"configuration":[{"id":"6231c8e3-6b32-4edc-a956-7595a3b72d6c","label":"Configuration Tab","orderId":0,"settings":[{"id":"13b56034-3fea-47b9-b060-63a70e0744ca","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"Source String","type":"text","language":null,"credentialsTemplateId":null,"value":"5e987b8b-c21d-4733-a2ac-b31457a3b124","options":null,"isRequired":true,"expects":"string","isList":false,"direction":1,"rowId":1,"columnId":0,"tooltip":"Text to be searched and modified","limits":null,"internalId":"cbcc408d-fb33-43f6-94d0-2038219c65db","status":{"type":"danger","message":[]}},{"id":"05ccbb02-9ac0-431b-aa87-f8eb2de4389a","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"Search String","type":"text","language":null,"credentialsTemplateId":null,"value":"'","options":null,"isRequired":true,"expects":"string","isList":false,"direction":1,"rowId":2,"columnId":0,"tooltip":"The string to be searched and replaced in the source string","limits":null,"internalId":"3ab26978-05cc-4e38-a2db-c8a938679afa","status":{"type":"danger","message":[]}},{"id":"ff90350d-d905-4f35-8f69-293ec2001880","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"Replacement String","type":"text","language":null,"credentialsTemplateId":null,"value":"''","options":null,"isRequired":false,"expects":"string","isList":false,"direction":1,"rowId":3,"columnId":0,"tooltip":"The string with which the matched values will be replaced","limits":null,"internalId":"154ab2e1-3537-434a-94c4-c197716b4d9d","status":{"type":"danger","message":[]}},{"id":"e4f0fc87-01fc-4194-a65d-33eea4bb041e","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121210","label":"Ignore Case","type":"check-box","language":null,"credentialsTemplateId":null,"value":true,"options":null,"isRequired":false,"expects":null,"isList":false,"direction":1,"rowId":4,"columnId":0,"tooltip":"Ignore the case of the strings being compared","limits":null,"internalId":"63eda9a2-2df5-4e4b-8df6-73918694bf51"},{"id":"03952913-f4b2-404a-a3a9-781bec674532","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"Result","type":"datatype","language":null,"credentialsTemplateId":null,"value":"bff0ace2-acdc-4f46-9ecf-3f45e4a23824","options":null,"isRequired":true,"expects":"string","isList":false,"direction":3,"rowId":5,"columnId":0,"tooltip":"The new string containing replacements","limits":null,"internalId":"d01a9381-dd95-4cdc-990e-44ea04055572","status":{"type":"danger","message":[]}}]}],"inputPorts":1,"outputPorts":1,"wasDropped":true,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""},{"Id":"8a2d3fad-e326-4a05-871f-d75d92ec4432","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","TemplateId":"6ddf806a-612e-4bf1-aa20-cc1dab576b02","ParentId":null,"Status":1,"Category":"cat1","Ports":[{"Id":"727d6ce7-9267-41ee-afed-5bfe82d419ad","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","SourceId":"8a2d3fad-e326-4a05-871f-d75d92ec4432","DestinationId":"62d580cb-d4a1-4fe7-9613-147b0147cddd","Type":0,"State":1,"Data":{},"Errors":{},"Config":{}}],"Parameters":[{"TabPropertyId":"13b56034-3fea-47b9-b060-63a70e0744ca","Variable":[{"id":0,"variableId":"c8cba51a-fef7-4169-8414-b9e55846a342","attribute":null}],"Value":"<%0%>"},{"TabPropertyId":"05ccbb02-9ac0-431b-aa87-f8eb2de4389a","Variable":[],"Value":"'"},{"TabPropertyId":"ff90350d-d905-4f35-8f69-293ec2001880","Variable":[],"Value":"''"},{"TabPropertyId":"e4f0fc87-01fc-4194-a65d-33eea4bb041e","Variable":[],"Value":true},{"TabPropertyId":"03952913-f4b2-404a-a3a9-781bec674532","Variable":[{"id":1,"variableId":"7291a17d-8341-4e0d-927d-c0d75e80fc27","attribute":null}],"Value":"<%1%>"}],"CustomData":{"type":"square","name":"Replace ' - Body","description":"Searches a string for a specified value and returns a new string where the specified value(s) are replaced","icon":"find_replace","position":{"x":923.0026300716812,"y":637.6405923370426},"configuration":[{"id":"6231c8e3-6b32-4edc-a956-7595a3b72d6c","label":"Configuration Tab","orderId":0,"settings":[{"id":"13b56034-3fea-47b9-b060-63a70e0744ca","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"Source String","type":"text","language":null,"credentialsTemplateId":null,"value":"c8cba51a-fef7-4169-8414-b9e55846a342","options":null,"isRequired":true,"expects":"string","isList":false,"direction":1,"rowId":1,"columnId":0,"tooltip":"Text to be searched and modified","limits":null,"internalId":"ad7a0b36-4d7c-4cca-9576-eb3aa1147fd7","status":{"type":"danger","message":[]}},{"id":"05ccbb02-9ac0-431b-aa87-f8eb2de4389a","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"Search String","type":"text","language":null,"credentialsTemplateId":null,"value":"'","options":null,"isRequired":true,"expects":"string","isList":false,"direction":1,"rowId":2,"columnId":0,"tooltip":"The string to be searched and replaced in the source string","limits":null,"internalId":"48623070-08a4-4e23-b0d8-acad33333f97","status":{"type":"danger","message":[]}},{"id":"ff90350d-d905-4f35-8f69-293ec2001880","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"Replacement String","type":"text","language":null,"credentialsTemplateId":null,"value":"''","options":null,"isRequired":false,"expects":"string","isList":false,"direction":1,"rowId":3,"columnId":0,"tooltip":"The string with which the matched values will be replaced","limits":null,"internalId":"761e7144-c017-40cf-b35f-ae0f52e62186","status":{"type":"danger","message":[]}},{"id":"e4f0fc87-01fc-4194-a65d-33eea4bb041e","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121210","label":"Ignore Case","type":"check-box","language":null,"credentialsTemplateId":null,"value":true,"options":null,"isRequired":false,"expects":null,"isList":false,"direction":1,"rowId":4,"columnId":0,"tooltip":"Ignore the case of the strings being compared","limits":null,"internalId":"72ce5941-e78f-4d22-81bf-cf9ca5933e78"},{"id":"03952913-f4b2-404a-a3a9-781bec674532","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"Result","type":"datatype","language":null,"credentialsTemplateId":null,"value":"7291a17d-8341-4e0d-927d-c0d75e80fc27","options":null,"isRequired":true,"expects":"string","isList":false,"direction":3,"rowId":5,"columnId":0,"tooltip":"The new string containing replacements","limits":null,"internalId":"639f66a0-ea97-49d3-aba4-8ceea490600d","status":{"type":"danger","message":[]}}]}],"inputPorts":1,"outputPorts":1,"wasDropped":true,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""},{"Id":"0dced841-7c03-4a5b-82e9-4c1ef91245cd","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","TemplateId":"c0e32108-6e3e-4ab8-96bd-cd61be6edb34","ParentId":null,"Status":1,"Category":"cat1","Ports":[],"Parameters":[],"CustomData":{"type":"square","name":"Stop","description":"Process stops","icon":"icon-stop","position":{"x":1557.0900000000001,"y":516},"configuration":[{"id":"c0e32108-6e3e-4ab8-96bd-cd61be6edb37","label":"Details","settings":[]}],"inputPorts":1,"outputPorts":0,"wasDropped":true,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""},{"Id":"b3b6d1ae-a029-4783-8677-129c378ed1f0","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","TemplateId":"894e02d1-303d-4e52-9ef7-1b3198ee4b53","ParentId":null,"Status":1,"Category":"cat1","Ports":[{"Id":"c267f0b4-424c-4516-912b-ce24d3641d75","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","SourceId":"b3b6d1ae-a029-4783-8677-129c378ed1f0","DestinationId":"efe3759b-df68-422b-9431-e5838a9f3c7a","Type":0,"State":1,"Data":{},"Errors":{},"Config":{}}],"Parameters":[{"TabPropertyId":"797e45d8-da43-4412-bac4-a3cbdf961b37","Variable":[],"Value":"https://webapi.procesio.app/api/webhooks/launch/1239dedb-a56f-43dc-b31e-9cc886ebf7ab?payload="},{"TabPropertyId":"117061e7-e531-4340-9cc1-da8f6e13633a","Variable":[{"id":0,"variableId":"81f5c12a-200f-4665-9811-4ec68030e154","attribute":null}],"Value":"<%0%>"},{"TabPropertyId":"9cdb4f28-e2e3-4933-ada8-1285f7f635f4","Variable":[{"id":1,"variableId":"81f5c12a-200f-4665-9811-4ec68030e154","attribute":null}],"Value":"<%1%>"}],"CustomData":{"type":"square","name":"String Concat","description":"Concatenates two strings","icon":"icon-custom-action","position":{"x":1246.1558858472306,"y":516.1468766185442},"configuration":[{"id":"5d932fcf-f1b8-41d6-ad8d-bdd9a1ab7504","label":"Configuration Tab","orderId":0,"settings":[{"id":"797e45d8-da43-4412-bac4-a3cbdf961b37","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"Input String 1","type":"text","language":null,"credentialsTemplateId":null,"value":"https://webapi.procesio.app/api/webhooks/launch/1239dedb-a56f-43dc-b31e-9cc886ebf7ab?payload=","options":null,"isRequired":true,"expects":"string","isList":false,"direction":1,"rowId":1,"columnId":0,"tooltip":null,"limits":null,"internalId":"2d35e760-74ba-41fa-b381-36f9110b684d","status":{"type":"danger","message":[]}},{"id":"117061e7-e531-4340-9cc1-da8f6e13633a","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"Input String 2","type":"text","language":null,"credentialsTemplateId":null,"value":"81f5c12a-200f-4665-9811-4ec68030e154","options":null,"isRequired":true,"expects":"string","isList":false,"direction":1,"rowId":2,"columnId":0,"tooltip":null,"limits":null,"internalId":"418dc63c-52cc-40b0-9eac-63d29844acf6","status":{"type":"danger","message":[]}},{"id":"9cdb4f28-e2e3-4933-ada8-1285f7f635f4","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"Result","type":"datatype","language":null,"credentialsTemplateId":null,"value":"81f5c12a-200f-4665-9811-4ec68030e154","options":null,"isRequired":true,"expects":"string","isList":false,"direction":3,"rowId":3,"columnId":0,"tooltip":null,"limits":null,"internalId":"ad33d618-22ff-4411-97c8-1e6eebecae8f","status":{"type":"danger","message":[]}}]}],"inputPorts":1,"outputPorts":1,"wasDropped":true,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""},{"Id":"efe3759b-df68-422b-9431-e5838a9f3c7a","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","TemplateId":"c7673492-2912-4975-8cab-747fb9f4085d","ParentId":null,"Status":1,"Category":"cat1","Ports":[{"Id":"a41a339c-ad1b-4b2e-ad51-d2439fb19126","FlowId":"0f329bca-4123-4f62-a094-6e78ae1031e9","SourceId":"efe3759b-df68-422b-9431-e5838a9f3c7a","DestinationId":"0dced841-7c03-4a5b-82e9-4c1ef91245cd","Type":0,"State":1,"Data":{},"Errors":{},"Config":{}}],"Parameters":[{"TabPropertyId":"f9d5da64-bbc0-4d53-a0ad-6f948cc3ff05","Variable":[],"Value":"93e7c6fb-202c-4cfa-93b8-cfbbad0e7f62"},{"TabPropertyId":"90d1ec9f-803c-42bc-bd8b-ca11e4ef116c","Variable":[],"Value":"Mihai DARZAN [PROCESIO]"},{"TabPropertyId":"1def19eb-ec69-4a21-a756-4abec8ae3171","Variable":[{"id":0,"variableId":"33d78462-c1c2-4104-ad71-b6f462c9cbbd","attribute":null}],"Value":"<%0%>"},{"TabPropertyId":"30ba958f-0d83-4259-97b9-d64ce7282d83","Variable":[{"id":1,"variableId":"5ae50d17-e0f8-4b18-b1d4-6d7c1b62eda0","attribute":null}],"Value":"<%1%>"},{"TabPropertyId":"1b6fbfac-183a-481b-9e0d-d4e7cf5543fe","Variable":[{"id":2,"variableId":"68d1bf95-b8b1-4c76-b866-634fbaea5683","attribute":null}],"Value":"<%2%>"},{"TabPropertyId":"9eeaf788-c023-4848-afe7-2454840bd321","Variable":[{"id":3,"variableId":"5e987b8b-c21d-4733-a2ac-b31457a3b124","attribute":null}],"Value":"<%3%>"},{"TabPropertyId":"235aa4cf-d20f-4dbb-ad1d-d03e5ff5f13e","Variable":[{"id":4,"variableId":"c8cba51a-fef7-4169-8414-b9e55846a342","attribute":null},{"id":5,"variableId":"81f5c12a-200f-4665-9811-4ec68030e154","attribute":null}],"Value":"<%4%>\r\n<img src=\"<%5%>\" width=\"1\" height=\"1\">"},{"TabPropertyId":"5330da65-bd38-4419-88c7-93136bdb6dd9","Variable":[{"id":6,"variableId":"12292b98-3e62-4a9e-9d62-db4942d79cca","attribute":null}],"Value":"<%6%>"},{"TabPropertyId":"3fdba8f7-75b5-4350-9d85-b542f8e5a73d","Variable":[],"Value":true}],"CustomData":{"type":"square","name":"Send Email","description":"Use this action to send emails to as many recipients needed, with/without attachments. You can also use process variables while configuring the Email to easily access your data coming from processing.","icon":"send","position":{"x":1388.3271089209027,"y":516.1468766185443},"configuration":[{"id":"60aba036-67c2-4ca8-8a89-86e7c9dd3c2d","label":"Details","orderId":0,"settings":[{"id":"f9d5da64-bbc0-4d53-a0ad-6f948cc3ff05","dataTypeId":null,"label":"Select SMTP Server","type":"credentials","language":null,"credentialsTemplateId":"20202020-0001-0000-0000-aaaaaaaaaaaa","value":"93e7c6fb-202c-4cfa-93b8-cfbbad0e7f62","options":null,"isRequired":true,"expects":null,"isList":false,"direction":1,"rowId":0,"columnId":0,"tooltip":null,"limits":null,"internalId":"cd7c6ffa-69e2-43dc-ab83-b9e61200f349","status":{"type":"danger","message":[]}},{"id":"1458de7a-0c35-4fe4-8e3c-2b9446fc132d","dataTypeId":null,"label":"Send Email","type":"side-pannel","language":null,"credentialsTemplateId":null,"value":[{"id":"90d1ec9f-803c-42bc-bd8b-ca11e4ef116c","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"From(display name)","type":"text","language":null,"credentialsTemplateId":null,"value":"Mihai DARZAN [PROCESIO]","options":null,"isRequired":false,"expects":null,"isList":false,"direction":1,"rowId":0,"columnId":0,"tooltip":null,"limits":null,"internalId":"9d84ddef-2a2a-4614-a3ee-642ceac3c532","status":{"type":"danger","message":[]}},{"id":"1def19eb-ec69-4a21-a756-4abec8ae3171","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"To","type":"text","language":null,"credentialsTemplateId":null,"value":"33d78462-c1c2-4104-ad71-b6f462c9cbbd","options":null,"isRequired":true,"expects":"email","isList":false,"direction":1,"rowId":1,"columnId":0,"tooltip":null,"limits":null,"internalId":"4d60af46-6d59-424b-9f81-f07b0159c9ed","status":{"type":"danger","message":[]}},{"id":"30ba958f-0d83-4259-97b9-d64ce7282d83","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"Cc","type":"text","language":null,"credentialsTemplateId":null,"value":"5ae50d17-e0f8-4b18-b1d4-6d7c1b62eda0","options":null,"isRequired":false,"expects":"email","isList":false,"direction":1,"rowId":2,"columnId":0,"tooltip":null,"limits":null,"internalId":"3a60e0e4-3cc9-4687-bf95-321436cd3498","status":{"type":"danger","message":[]}},{"id":"1b6fbfac-183a-481b-9e0d-d4e7cf5543fe","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121214","label":"Bcc","type":"text","language":null,"credentialsTemplateId":null,"value":"68d1bf95-b8b1-4c76-b866-634fbaea5683","options":null,"isRequired":false,"expects":"email","isList":false,"direction":1,"rowId":3,"columnId":0,"tooltip":null,"limits":null,"internalId":"e83dabf5-808f-496a-b82d-5a854d7fb402","status":{"type":"danger","message":[]}},{"id":"9eeaf788-c023-4848-afe7-2454840bd321","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121221","label":"Subject","type":"text","language":null,"credentialsTemplateId":null,"value":"5e987b8b-c21d-4733-a2ac-b31457a3b124","options":null,"isRequired":true,"expects":null,"isList":false,"direction":1,"rowId":4,"columnId":0,"tooltip":null,"limits":null,"internalId":"3e42892d-747e-439f-aeb6-078cb785ac4a","status":{"type":"danger","message":[]}},{"id":"235aa4cf-d20f-4dbb-ad1d-d03e5ff5f13e","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121221","label":"Body","type":"code-editor","language":null,"credentialsTemplateId":null,"value":"c8cba51a-fef7-4169-8414-b9e55846a342\r\n<img src=\"81f5c12a-200f-4665-9811-4ec68030e154\" width=\"1\" height=\"1\">","options":null,"isRequired":true,"expects":null,"isList":false,"direction":1,"rowId":5,"columnId":0,"tooltip":null,"limits":null,"internalId":"855cd9cf-3864-41b5-885d-b1a8e9f67970","status":{"type":"danger","message":[]}},{"id":"5330da65-bd38-4419-88c7-93136bdb6dd9","dataTypeId":"10c6ac59-3929-49e6-99dc-121212121219","label":"Map attachment","type":"file","language":null,"credentialsTemplateId":null,"value":"12292b98-3e62-4a9e-9d62-db4942d79cca","options":null,"isRequired":false,"expects":null,"isList":true,"direction":1,"rowId":6,"columnId":0,"tooltip":null,"limits":null,"internalId":"72591795-7a12-475d-9051-47cfd3a1cb3a","status":{"type":"danger","message":[]}},{"id":"3fdba8f7-75b5-4350-9d85-b542f8e5a73d","dataTypeId":"0317bfee-b2f5-4bde-bfe8-121212121210","label":"Body is Html","type":"check-box","language":null,"credentialsTemplateId":null,"value":true,"options":null,"isRequired":false,"expects":null,"isList":false,"direction":1,"rowId":7,"columnId":0,"tooltip":null,"limits":null,"internalId":"58e7902a-c759-4432-90e3-d74251d6ba69"}],"options":null,"isRequired":null,"expects":null,"isList":false,"direction":null,"rowId":1,"columnId":0,"tooltip":null,"limits":null,"internalId":"dfd859c1-06ae-4019-8191-ed28d3d17aea"}]}],"inputPorts":1,"outputPorts":1,"wasDropped":true,"areaSize":{"width":48,"height":48,"x":0,"y":0}},"IsTestable":false,"TestValues":null,"ErrorMessage":""}],"Webhooks":[],"Id":"0f329bca-4123-4f62-a094-6e78ae1031e9","ParentId":null,"Status":1,"Title":"Email track/1. Send email containing Tracking Pixel","Description":"","IsValid":true,"Active":true,"IsNotification":false,"createdOn":"2023-05-03T10:25:52","updatedOn":"2023-05-03T10:25:52","firstName":null,"lastName":null,"workspaceName":null}]}