{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"61dc17b82a99d704d3e6c688","instance_id":"20793088-b390-4561-94d4-305ff4094844","instance_version":16,"link_map":{"link160":{"src_view_id":"output0","dst_view_id":"input101","src_id":"aeffb188-9583-453e-a7b4-be918dfd92b2","dst_id":"e86da2b2-f6ed-44aa-a0e9-503b0dbd4091","isGoto":false},"link161":{"src_view_id":"output0","dst_view_id":"input0","src_id":"cb58fd8a-f29d-4eab-98d4-11c906024336","dst_id":"aeffb188-9583-453e-a7b4-be918dfd92b2","isGoto":false},"link162":{"src_view_id":"output0","dst_view_id":"input101","src_id":"cebb1764-44cc-4975-b365-89782072d701","dst_id":"475b6b1d-f34f-44d7-a922-53045f3f30d1","isGoto":false},"link163":{"src_view_id":"output0","dst_view_id":"input0","src_id":"9f572e23-4749-430a-ad8e-0c9af4ebcb61","dst_id":"cebb1764-44cc-4975-b365-89782072d701","isGoto":false},"link139":{"src_view_id":"output0","dst_view_id":"input0","src_id":"475b6b1d-f34f-44d7-a922-53045f3f30d1","dst_id":"7d5e39ba-94ba-4969-870d-e01fea3a7f96","isGoto":false},"link142":{"src_view_id":"output0","dst_view_id":"input0","src_id":"e171c423-669d-4e04-b73b-826bb353a9dd","dst_id":"718b4ffa-285e-4bc1-abb3-9bf6b7ca1ace","isGoto":false},"link141":{"src_view_id":"output0","dst_view_id":"input102","src_id":"718b4ffa-285e-4bc1-abb3-9bf6b7ca1ace","dst_id":"580d13ea-a2b2-4158-8407-af9d99d0951b","isGoto":false},"link150":{"src_view_id":"output1","dst_view_id":"input0","src_id":"e171c423-669d-4e04-b73b-826bb353a9dd","dst_id":"cb58fd8a-f29d-4eab-98d4-11c906024336","isGoto":false},"link153":{"src_view_id":"output0","dst_view_id":"input1","src_id":"e86da2b2-f6ed-44aa-a0e9-503b0dbd4091","dst_id":"7d5e39ba-94ba-4969-870d-e01fea3a7f96","isGoto":true},"link145":{"src_view_id":"output0","dst_view_id":"input0","src_id":"7c71bb0e-cc3f-488b-b8a5-001562000d00","dst_id":"e171c423-669d-4e04-b73b-826bb353a9dd","isGoto":false},"link148":{"src_view_id":"output0","dst_view_id":"input0","src_id":"580d13ea-a2b2-4158-8407-af9d99d0951b","dst_id":"9f572e23-4749-430a-ad8e-0c9af4ebcb61","isGoto":false}},"link_serial":169,"property_map":{"info":{"notes":{"value":null},"author":{"value":"jianan.chen@rojoconsultancy.com"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"label":{"value":"Use Case - Booked Hours Notifications - Send Email"}},"input":{"7c71bb0e-cc3f-488b-b8a5-001562000d00_input102":{"label":{"value":"Get Employee - input0"},"view_type":{"value":"document"}}},"settings":{"imports":{"value":[]},"error_param_table":{"value":[]},"error_pipeline":{"expression":false,"value":null},"param_table":{"value":[{"capture":{"value":true},"description":{"value":null},"data_type":{"value":"string"},"required":{"value":false},"value":{"value":"3022249"},"key":{"value":"Division"}}]}},"error":{"error_behavior":{"value":"none"}},"output":{"7d5e39ba-94ba-4969-870d-e01fea3a7f96_output0":{"label":{"value":"Join - output0"},"view_type":{"value":"document"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"5dde47585cdcb06dd1623574","scale_ratio":1,"detail_map":{"aeffb188-9583-453e-a7b4-be918dfd92b2":{"grid_x_int":5,"input":{},"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":7,"rot_tail_int":0,"error":{},"output":{},"rot_int":0},"580d13ea-a2b2-4158-8407-af9d99d0951b":{"grid_x_int":5,"index":null,"recommendation_id":null,"source":"","grid_y_int":6,"rot_tail_int":0,"rot_int":0},"cebb1764-44cc-4975-b365-89782072d701":{"grid_x_int":7,"input":{},"index":null,"recommendation_id":null,"source":"","grid_y_int":6,"rot_tail_int":0,"error":{},"output":{},"rot_int":0},"7d5e39ba-94ba-4969-870d-e01fea3a7f96":{"grid_x_int":9,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":6,"rot_tail_int":0,"error":{},"input":{"input1":{"dx_int":0,"rot_int":0,"dy_int":1}},"rot_int":0},"718b4ffa-285e-4bc1-abb3-9bf6b7ca1ace":{"grid_x_int":4,"input":{},"index":null,"recommendation_id":null,"source":"","grid_y_int":6,"rot_tail_int":0,"error":{},"output":{},"rot_int":0},"e86da2b2-f6ed-44aa-a0e9-503b0dbd4091":{"grid_x_int":6,"index":null,"recommendation_id":null,"source":"","grid_y_int":7,"rot_tail_int":0,"rot_int":0},"cb58fd8a-f29d-4eab-98d4-11c906024336":{"grid_x_int":4,"input":{},"index":null,"recommendation_id":null,"source":"","grid_y_int":7,"rot_tail_int":0,"error":{},"output":{},"rot_int":0},"e171c423-669d-4e04-b73b-826bb353a9dd":{"grid_x_int":3,"input":{},"index":null,"recommendation_id":null,"source":"","grid_y_int":6,"rot_tail_int":0,"error":{},"output":{"output1":{"dx_int":0,"rot_int":0,"dy_int":1}},"rot_int":0},"9f572e23-4749-430a-ad8e-0c9af4ebcb61":{"grid_x_int":6,"input":{},"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":6,"rot_tail_int":0,"error":{},"output":{},"rot_int":0},"7c71bb0e-cc3f-488b-b8a5-001562000d00":{"grid_x_int":2,"index":null,"recommendation_id":null,"source":"","grid_y_int":6,"rot_tail_int":0,"rot_int":0},"475b6b1d-f34f-44d7-a922-53045f3f30d1":{"grid_x_int":8,"index":null,"recommendation_id":null,"source":"","grid_y_int":6,"rot_tail_int":0,"rot_int":0}},"pan_y_num":0},"snap_map":{"aeffb188-9583-453e-a7b4-be918dfd92b2":{"class_fqid":"com-snaplogic-snaps-flow-filter_2-main11181","class_id":"com-snaplogic-snaps-flow-filter","class_version":2,"instance_fqid":"aeffb188-9583-453e-a7b4-be918dfd92b2_1","instance_id":"aeffb188-9583-453e-a7b4-be918dfd92b2","instance_version":1,"property_map":{"info":{"notes":{},"label":{"value":"Filter"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"filterExpression":{"expression":true,"value":"$EmailEmployee != null"},"execution_mode":{"value":"Validate & Execute"}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"main11181"},"580d13ea-a2b2-4158-8407-af9d99d0951b":{"class_fqid":"com-rojoconsultancy-snaps-exactonline-exactread_1-25","class_id":"com-rojoconsultancy-snaps-exactonline-exactread","class_version":1,"instance_fqid":"580d13ea-a2b2-4158-8407-af9d99d0951b_4","instance_id":"580d13ea-a2b2-4158-8407-af9d99d0951b","instance_version":4,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Get Manager"}},"view_serial":102,"account":{"account_ref":{"value":{"label":{"expression":false,"value":"Exact Online Account 001","label":"Exact Online Account 001"},"ref_class_id":{"value":"com-rojoconsultancy-snaps-exactonline-exactoauth2account"},"ref_id":{"expression":false,"value":"00c90b4c-d1ed-46b4-981e-fcd58bf4962f"}}}},"settings":{"execution_mode":{"value":"Validate & Execute"},"Retry request interval":{"value":1},"Version":{"expression":false,"value":"v1"},"Connection details":{"value":{"Connection timeout":{"expression":false,"value":300},"Maximum retry attempts":{"expression":false,"value":3},"Retry Interval":{"expression":false,"value":1}}},"Filter Records":{"value":[{"Operation":{"value":"Equals"},"Field Value":{"expression":true,"value":"$Manager"},"Condition":{"value":"And"},"Field Name":{"expression":false,"value":"ID"}}]},"Function parameter":{"value":[]},"Division":{"expression":true,"value":"_Division"},"Pass through":{"value":true},"Inline count":{"value":false},"Connection timeout":{"value":300},"Output Field Selection":{"value":[]},"Output fields advanced options":{"value":{"Output entry limit":{"expression":false,"value":1},"Allow empty result":{"expression":false,"value":false},"Output entry offset":{"expression":false,"value":null},"Inline count":{"expression":false,"value":false},"Automatic pagination":{"expression":false,"value":false}}},"Maximum request attempts":{"value":3},"API Object":{"expression":false,"value":"Payroll"},"Connection Details":{"value":{"Connection Timeout":{"expression":false,"value":300},"Maximum Retry Attempts":{"expression":false,"value":3},"Retry Interval":{"expression":false,"value":1}}},"Order by":{"value":[]},"Endpoint":{"expression":false,"value":"Employees"},"Output Fields Advanced Options":{"value":{"Output Entry Limit":{"expression":false,"value":null},"Allow Empty Result":{"expression":false,"value":true},"Output Entry Offset":{"expression":false,"value":null},"Inline Count":{"expression":false,"value":false},"Automatic Pagination":{"expression":false,"value":true}}},"API object":{"expression":false,"value":"Payroll"},"Advanced options":{"value":{"Output field limit":{"expression":false,"value":null},"Output field offset":{"expression":false,"value":null}}},"Order By":{"value":[]},"Process the empty result":{"value":true},"Automatic pagination":{"value":false},"Output field selection":{"value":[{"Element":{"expression":false,"value":"ID"}},{"Element":{"expression":false,"value":"Email"}},{"Element":{"expression":false,"value":"FullName"}},{"Element":{"expression":false,"value":"BusinessEmail"}},{"Element":{"expression":false,"value":"EmployeeHID"}}]},"Filter records":{"value":[{"Value":{"expression":true,"value":"$Manager+\" \""},"Field name":{"expression":false,"value":"ID"},"Field":{"expression":false,"value":"ID"},"Field value":{"expression":true,"value":"$Manager"},"Operation":{"value":"Equals"},"Condition":{"value":"Or"}}]},"Function Parameter":{"value":[]}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}},"error":{"error_behavior":{"value":"fail"}},"input":{"input102":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"25"},"cebb1764-44cc-4975-b365-89782072d701":{"class_fqid":"com-snaplogic-snaps-flow-filter_2-main11181","class_id":"com-snaplogic-snaps-flow-filter","class_version":2,"instance_fqid":"cebb1764-44cc-4975-b365-89782072d701_1","instance_id":"cebb1764-44cc-4975-b365-89782072d701","instance_version":1,"property_map":{"info":{"notes":{},"label":{"value":"Filter"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"filterExpression":{"expression":true,"value":"$EmailEmployee != null"},"execution_mode":{"value":"Validate & Execute"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"main11181"},"7d5e39ba-94ba-4969-870d-e01fea3a7f96":{"class_fqid":"com-snaplogic-snaps-transform-multijoin_1-snapsmrc528","class_id":"com-snaplogic-snaps-transform-multijoin","class_version":1,"instance_fqid":"7d5e39ba-94ba-4969-870d-e01fea3a7f96_1","instance_id":"7d5e39ba-94ba-4969-870d-e01fea3a7f96","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Join"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}},"input1":{"view_type":{"value":"document"},"label":{"value":"input1"}}},"settings":{"nullGreater":{"value":false},"execution_mode":{"value":"Validate & Execute"},"nullSafeAccess":{"value":false},"noMatchData":{"value":false},"joinPaths":{"value":[{"rightPath":{"expression":true,"value":null},"rightInputView":{"value":"input1"},"leftPath":{"expression":true,"value":null}}]},"joinType":{"value":"Merge"},"sortedStreams":{"value":"Ascending"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"snapsmrc528"},"718b4ffa-285e-4bc1-abb3-9bf6b7ca1ace":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsmrc528","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"718b4ffa-285e-4bc1-abb3-9bf6b7ca1ace_1","instance_id":"718b4ffa-285e-4bc1-abb3-9bf6b7ca1ace","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":true,"value":"$BusinessEmail"},"targetPath":{"value":"$Email"}},{"expression":{"expression":true,"value":"$FirstName"},"targetPath":{"value":"$FirstName"}},{"expression":{"expression":true,"value":"$ID"},"targetPath":{"value":"$ID"}},{"expression":{"expression":true,"value":"$Manager"},"targetPath":{"value":"$Manager"}},{"expression":{"expression":true,"value":"$original.HoursBooked"},"targetPath":{"value":"$HoursBooked"}},{"expression":{"expression":true,"value":"$original.HoursDrafted"},"targetPath":{"value":"$HoursDrafted"}},{"expression":{"expression":true,"value":"$original.HoursRejected"},"targetPath":{"value":"$HoursRejected"}},{"expression":{"expression":true,"value":"$original.AverageHours"},"targetPath":{"value":"$AverageHours"}},{"expression":{"expression":true,"value":"$original.ContractHours"},"targetPath":{"value":"$ContractHours"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsmrc528"},"e86da2b2-f6ed-44aa-a0e9-503b0dbd4091":{"class_fqid":"com-snaplogic-snaps-email-emailsender_2-snapsmrc528","class_id":"com-snaplogic-snaps-email-emailsender","class_version":2,"instance_fqid":"e86da2b2-f6ed-44aa-a0e9-503b0dbd4091_2","instance_id":"e86da2b2-f6ed-44aa-a0e9-503b0dbd4091","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Email Sender"}},"view_serial":101,"account":{"account_ref":{"value":{"label":{"expression":false,"value":"Rojo-mail-support","label":"../../shared/Rojo-mail-support"},"ref_class_id":{"value":"com-snaplogic-snaps-email-smtpaccount"},"ref_id":{"expression":false,"value":"11c97256-411f-4d96-9772-1ba48e340b76"}}}},"settings":{"body":{"expression":true,"value":"\"Hi \"+$FirstName+\",\n\nWe noticed that you did not submit all your hours for this period (the last 5 weeks). According to your contract, you must submit \"+$ContractWeek+\" hours every week. This adds up to a total of \"+$ContractPeriod+\" hours.\nPlease check the below details for your current overview:\n\nHours submitted: \"+$HoursBooked+\" \nHours drafted: \"+$HoursDrafted+\"\nHours rejected: \"+$HoursRejected+\"\n\nIf you have drafted hours, please make sure to submit them in Exact Online.\nIf you have rejected hours, contact your manager for further details.\n\nWe kindly request you to complete your hours in Exact Online (https://start.exactonline.nl) as soon as possible.\n\n\n\nRojo Consultancy\""},"retries":{"value":3},"execution_mode":{"value":"Validate & Execute"},"from":{"expression":false,"value":"rojotestdemo1.rojo@gmail.com"},"attachments":{"value":[]},"cc":{"expression":false,"value":null},"passThrough":{"value":false},"batchSize":{"value":100},"executable_during_suggest":{"value":false},"bcc":{"expression":false,"value":null},"to":{"expression":true,"value":"$EmailEmployee"},"tableDataPath":{"value":null},"emailType":{"value":"Plain text"},"subject":{"expression":false,"value":"Exact Online: Missing Timesheet Hours"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsmrc528"},"cb58fd8a-f29d-4eab-98d4-11c906024336":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsmrc528","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"cb58fd8a-f29d-4eab-98d4-11c906024336_1","instance_id":"cb58fd8a-f29d-4eab-98d4-11c906024336","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Restructure"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingTable":{"value":[{"targetPath":{"value":"$EmailEmployee"},"expression":{"expression":true,"value":"$BusinessEmail"}},{"targetPath":{"value":"$FirstName"},"expression":{"expression":true,"value":"$FirstName"}},{"targetPath":{"value":"$HoursBooked"},"expression":{"expression":true,"value":"$original.HoursBooked"}},{"targetPath":{"value":"$HoursDrafted"},"expression":{"expression":true,"value":"$original.HoursDrafted"}},{"targetPath":{"value":"$HoursRejected"},"expression":{"expression":true,"value":"$original.HoursRejected"}},{"targetPath":{"value":"$ContractPeriod"},"expression":{"expression":true,"value":"$original.AverageHours"}},{"targetPath":{"value":"$ContractWeek"},"expression":{"expression":true,"value":"$original.ContractHours == null ? ($original.AverageHours/5) : ($original.ContractHours/5)"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsmrc528"},"e171c423-669d-4e04-b73b-826bb353a9dd":{"class_fqid":"com-snaplogic-snaps-flow-router_2-snapsmrc528","class_id":"com-snaplogic-snaps-flow-router","class_version":2,"instance_fqid":"e171c423-669d-4e04-b73b-826bb353a9dd_1","instance_id":"e171c423-669d-4e04-b73b-826bb353a9dd","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Router1"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"routes":{"value":[{"expression":{"expression":true,"value":"$Manager != null"},"outputViewName":{"value":"output0"}},{"expression":{"expression":true,"value":"$Manager == null"},"outputViewName":{"value":"output1"}}]},"execution_mode":{"value":"Validate & Execute"},"firstMatch":{"value":false}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}},"output1":{"label":{"value":"output1"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsmrc528"},"9f572e23-4749-430a-ad8e-0c9af4ebcb61":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsmrc528","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"9f572e23-4749-430a-ad8e-0c9af4ebcb61_1","instance_id":"9f572e23-4749-430a-ad8e-0c9af4ebcb61","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Restructure"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":true,"value":"$BusinessEmail"},"targetPath":{"value":"$EmailManager"}},{"expression":{"expression":true,"value":"$original.Email"},"targetPath":{"value":"$EmailEmployee"}},{"expression":{"expression":true,"value":"$original.FirstName"},"targetPath":{"value":"$FirstName"}},{"expression":{"expression":true,"value":"$original.HoursBooked"},"targetPath":{"value":"$HoursBooked"}},{"expression":{"expression":true,"value":"$original.HoursDrafted"},"targetPath":{"value":"$HoursDrafted"}},{"expression":{"expression":true,"value":"$original.HoursRejected"},"targetPath":{"value":"$HoursRejected"}},{"expression":{"expression":true,"value":"$original.AverageHours"},"targetPath":{"value":"$ContractPeriod"}},{"expression":{"expression":true,"value":"$original.ContractHours == null ? ($original.AverageHours/5) : ($original.ContractHours/5)"},"targetPath":{"value":"$ContractWeek"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"snapsmrc528"},"7c71bb0e-cc3f-488b-b8a5-001562000d00":{"class_fqid":"com-rojoconsultancy-snaps-exactonline-exactread_1-25","class_id":"com-rojoconsultancy-snaps-exactonline-exactread","class_version":1,"instance_fqid":"7c71bb0e-cc3f-488b-b8a5-001562000d00_9","instance_id":"7c71bb0e-cc3f-488b-b8a5-001562000d00","instance_version":9,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Get Employee"}},"view_serial":102,"account":{"account_ref":{"value":{"ref_id":{"expression":false,"value":"00c90b4c-d1ed-46b4-981e-fcd58bf4962f"},"ref_class_id":{"value":"com-rojoconsultancy-snaps-exactonline-exactoauth2account"},"label":{"expression":false,"value":"Exact Online Account 001","label":"Exact Online Account 001"}}}},"input":{"input102":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"execution_mode":{"value":"Validate & Execute"},"Retry request interval":{"value":1},"Version":{"expression":false,"value":"v1"},"Connection details":{"value":{"Connection timeout":{"expression":false,"value":300},"Maximum retry attempts":{"expression":false,"value":3},"Retry Interval":{"expression":false,"value":1}}},"Filter Records":{"value":[{"Operation":{"value":"Equals"},"Field Value":{"expression":true,"value":"$original.groupBy.EmployeeHID"},"Condition":{"value":"And"},"Field Name":{"expression":false,"value":"EmployeeHID"}}]},"Function parameter":{"value":[]},"Division":{"expression":true,"value":"_Division"},"Pass through":{"value":true},"Inline count":{"value":false},"Connection timeout":{"value":300},"Output Field Selection":{"value":[{"Element":{"expression":false,"value":"ID"}},{"Element":{"expression":false,"value":"BusinessEmail"}},{"Element":{"expression":false,"value":"FullName"}},{"Element":{"expression":false,"value":"Manager"}},{"Element":{"expression":false,"value":"FirstName"}}]},"Output fields advanced options":{"value":{"Output entry limit":{"expression":false,"value":1},"Allow empty result":{"expression":false,"value":false},"Output entry offset":{"expression":false,"value":null},"Inline count":{"expression":false,"value":false},"Automatic pagination":{"expression":false,"value":false}}},"Maximum request attempts":{"value":3},"API Object":{"expression":false,"value":"Payroll"},"Connection Details":{"value":{"Connection Timeout":{"expression":false,"value":300},"Maximum Retry Attempts":{"expression":false,"value":3},"Retry Interval":{"expression":false,"value":1}}},"Order by":{"value":[]},"Endpoint":{"expression":false,"value":"Employees"},"Output Fields Advanced Options":{"value":{"Output Entry Limit":{"expression":false,"value":null},"Allow Empty Result":{"expression":false,"value":true},"Output Entry Offset":{"expression":false,"value":null},"Inline Count":{"expression":false,"value":false},"Automatic Pagination":{"expression":false,"value":true}}},"API object":{"expression":false,"value":"Payroll"},"Advanced options":{"value":{"Output field limit":{"expression":false,"value":null},"Output field offset":{"expression":false,"value":null}}},"Order By":{"value":[]},"Process the empty result":{"value":true},"Automatic pagination":{"value":false},"Output field selection":{"value":[{"Element":{"expression":false,"value":"ID"}},{"Element":{"expression":false,"value":"BusinessEmail"}},{"Element":{"expression":false,"value":"FirstName"}},{"Element":{"expression":false,"value":"Manager"}},{"Element":{"expression":false,"value":"BusinessEmail"}}]},"Filter records":{"value":[{"Value":{"expression":true,"value":"$original.groupBy.Employee"},"Field name":{"expression":false,"value":"ID"},"Field":{"expression":false,"value":"ID"},"Field value":{"expression":true,"value":"$EmployeeId"},"Operation":{"value":"Equals"},"Condition":{"value":"Or"}}]},"Function Parameter":{"value":[]}},"error":{"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"25"},"475b6b1d-f34f-44d7-a922-53045f3f30d1":{"class_fqid":"com-snaplogic-snaps-email-emailsender_2-snapsmrc528","class_id":"com-snaplogic-snaps-email-emailsender","class_version":2,"instance_fqid":"475b6b1d-f34f-44d7-a922-53045f3f30d1_2","instance_id":"475b6b1d-f34f-44d7-a922-53045f3f30d1","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Email Sender"}},"view_serial":101,"account":{"account_ref":{"value":{"ref_id":{"expression":false,"value":"11c97256-411f-4d96-9772-1ba48e340b76"},"ref_class_id":{"value":"com-snaplogic-snaps-email-smtpaccount"},"label":{"expression":false,"value":"Rojo-mail-support","label":"../../shared/Rojo-mail-support"}}}},"settings":{"body":{"expression":true,"value":"\"Hi \"+$FirstName+\",\n\nWe noticed that you did not submit all your hours for this period (the last 5 weeks). According to your contract, you must submit \"+$ContractWeek+\" hours every week. This adds up to a total of \"+$ContractPeriod+\" hours.\nPlease check the below details for your current overview:\n\nHours submitted: \"+$HoursBooked+\" \nHours drafted: \"+$HoursDrafted+\"\nHours rejected: \"+$HoursRejected+\"\n\nIf you have drafted hours, please make sure to submit them in Exact Online.\nIf you have rejected hours, contact your manager for further details.\n\nWe kindly request you to complete your hours in Exact Online (https://start.exactonline.nl) as soon as possible.\n\n\n\nRojo Consultancy\""},"retries":{"value":3},"execution_mode":{"value":"Validate & Execute"},"from":{"expression":false,"value":"rojotestdemo1.rojo@gmail.com"},"attachments":{"value":[]},"cc":{"expression":true,"value":"$EmailEmployee"},"passThrough":{"value":false},"batchSize":{"value":100},"executable_during_suggest":{"value":false},"bcc":{"expression":false,"value":null},"to":{"expression":true,"value":"match $EmailEmployee {null => $EmailManager , _ => $EmailEmployee}"},"tableDataPath":{"value":null},"emailType":{"value":"Plain text"},"subject":{"expression":false,"value":"Exact Online: Missing Timesheet Hours"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsmrc528"}},"path_id":"/RojoConsultancy1_Dev/Software Development Docs/ExactOnline_1.0.0","path_snode":"602153b02280db50f3db24dd","target_runtime":"standard"}