{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"61dc17de866f08d5a18b31a5","instance_id":"770c04e6-d5cc-4f12-814f-dc3b2afdb55b","instance_version":28,"link_map":{"link203":{"src_view_id":"output0","dst_view_id":"input0","src_id":"54155607-9ac4-48a8-a44f-14c3f126d130","dst_id":"f36a32c7-453e-4858-ab54-36d4754077a8","isGoto":false},"link199":{"src_view_id":"output0","dst_view_id":"input101","src_id":"655198be-8563-4df5-86e6-cf8ccbdc7e17","dst_id":"8aa8139c-1c9a-4ffe-825c-0eeed8642d64","isGoto":false},"link198":{"src_view_id":"output0","dst_view_id":"input1","src_id":"0e708ffb-7424-47e0-930c-a6842c0b3db3","dst_id":"8aa8139c-1c9a-4ffe-825c-0eeed8642d64","isGoto":false},"link197":{"src_view_id":"output0","dst_view_id":"input0","src_id":"2c47bedd-1b57-4928-a50e-a9cb1c08cc05","dst_id":"8aa8139c-1c9a-4ffe-825c-0eeed8642d64","isGoto":false},"link274":{"src_view_id":"output0","dst_view_id":"input0","src_id":"415d4fec-a819-4e2e-8c9e-ba44497df31f","dst_id":"076e8b83-9de0-4e1a-a50c-21ec3e9bf295","isGoto":false},"link258":{"src_view_id":"output0","dst_view_id":"input102","src_id":"fe4c5bb0-adcd-4461-987a-4052059d9c11","dst_id":"bc13ccdd-f269-4ad2-bc3b-f8164d870926","isGoto":false},"link257":{"src_view_id":"output0","dst_view_id":"input0","src_id":"494e685a-26b6-426a-91be-f812cee349ec","dst_id":"fe4c5bb0-adcd-4461-987a-4052059d9c11","isGoto":false},"link255":{"src_view_id":"output0","dst_view_id":"input0","src_id":"c66172e1-0141-4f15-8ee6-2d6ca49c904d","dst_id":"494e685a-26b6-426a-91be-f812cee349ec","isGoto":false},"link234":{"src_view_id":"output0","dst_view_id":"input0","src_id":"f36a32c7-453e-4858-ab54-36d4754077a8","dst_id":"415d4fec-a819-4e2e-8c9e-ba44497df31f","isGoto":false},"link253":{"src_view_id":"output0","dst_view_id":"input0","src_id":"bc13ccdd-f269-4ad2-bc3b-f8164d870926","dst_id":"f2b4220f-28e4-42bd-9b87-e1cb01a585cd","isGoto":false},"link204":{"src_view_id":"output0","dst_view_id":"input0","src_id":"aaa67040-cef7-4d80-a7ed-340978056434","dst_id":"54155607-9ac4-48a8-a44f-14c3f126d130","isGoto":false},"link201":{"src_view_id":"output0","dst_view_id":"input0","src_id":"b6e4bc85-2f64-4a77-b0cf-2ad9616e7427","dst_id":"aaa67040-cef7-4d80-a7ed-340978056434","isGoto":false},"link200":{"src_view_id":"output0","dst_view_id":"input0","src_id":"8aa8139c-1c9a-4ffe-825c-0eeed8642d64","dst_id":"b6e4bc85-2f64-4a77-b0cf-2ad9616e7427","isGoto":false},"link144":{"src_view_id":"output0","dst_view_id":"input0","src_id":"e5a11d7e-ae47-4200-81b6-49a259c332ec","dst_id":"e6a20e27-aef7-4f7a-a0de-c1dfc51a90e8","isGoto":false},"link145":{"src_view_id":"output102","dst_view_id":"input0","src_id":"e6a20e27-aef7-4f7a-a0de-c1dfc51a90e8","dst_id":"05dcd3c3-5394-4ed6-bcbe-f80d4f2d26f4","isGoto":false},"link244":{"src_view_id":"output101","dst_view_id":"input1","src_id":"e5fc2fd9-c863-49ee-92ad-bb83c7a2ab0c","dst_id":"7bb98a58-5a09-47a5-a1b5-807e34123c82","isGoto":true},"link241":{"src_view_id":"output0","dst_view_id":"input0","src_id":"05dcd3c3-5394-4ed6-bcbe-f80d4f2d26f4","dst_id":"e5fc2fd9-c863-49ee-92ad-bb83c7a2ab0c","isGoto":false},"link243":{"src_view_id":"output0","dst_view_id":"input0","src_id":"076e8b83-9de0-4e1a-a50c-21ec3e9bf295","dst_id":"7bb98a58-5a09-47a5-a1b5-807e34123c82","isGoto":false},"link120":{"src_view_id":"output0","dst_view_id":"input0","src_id":"e6a20e27-aef7-4f7a-a0de-c1dfc51a90e8","dst_id":"2c47bedd-1b57-4928-a50e-a9cb1c08cc05","isGoto":false},"link121":{"src_view_id":"output1","dst_view_id":"input0","src_id":"e6a20e27-aef7-4f7a-a0de-c1dfc51a90e8","dst_id":"0e708ffb-7424-47e0-930c-a6842c0b3db3","isGoto":false},"link122":{"src_view_id":"output101","dst_view_id":"input0","src_id":"e6a20e27-aef7-4f7a-a0de-c1dfc51a90e8","dst_id":"655198be-8563-4df5-86e6-cf8ccbdc7e17","isGoto":false},"link103":{"src_view_id":"output0","dst_view_id":"input101","src_id":"f2b4220f-28e4-42bd-9b87-e1cb01a585cd","dst_id":"e5a11d7e-ae47-4200-81b6-49a259c332ec","isGoto":false}},"link_serial":286,"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 Parent"}},"input":{},"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"}},{"capture":{"value":true},"description":{"value":null},"data_type":{"value":"string"},"required":{"value":false},"value":{"value":null},"key":{"value":"EmployeesExcluded"}}]}},"error":{"error_behavior":{"value":"none"}},"output":{"7bb98a58-5a09-47a5-a1b5-807e34123c82_output0":{"view_type":{"value":"document"},"label":{"value":"Join - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"5dde47585cdcb06dd1623574","scale_ratio":1,"detail_map":{"494e685a-26b6-426a-91be-f812cee349ec":{"grid_x_int":6,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"415d4fec-a819-4e2e-8c9e-ba44497df31f":{"grid_x_int":18,"input":{},"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"error":{},"output":{},"rot_int":0},"bc13ccdd-f269-4ad2-bc3b-f8164d870926":{"grid_x_int":8,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"rot_int":0},"aaa67040-cef7-4d80-a7ed-340978056434":{"grid_x_int":15,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"54155607-9ac4-48a8-a44f-14c3f126d130":{"grid_x_int":16,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"e5fc2fd9-c863-49ee-92ad-bb83c7a2ab0c":{"grid_x_int":13,"input":{},"index":null,"recommendation_id":null,"source":"","grid_y_int":4,"rot_tail_int":0,"error":{},"output":{},"rot_int":0},"e5a11d7e-ae47-4200-81b6-49a259c332ec":{"grid_x_int":10,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"error":{},"rot_int":0},"655198be-8563-4df5-86e6-cf8ccbdc7e17":{"grid_x_int":12,"index":null,"recommendation_id":null,"output":{},"source":"","grid_y_int":3,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"7bb98a58-5a09-47a5-a1b5-807e34123c82":{"grid_x_int":20,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{"input1":{"dx_int":0,"rot_int":0,"dy_int":1}},"rot_int":0},"c66172e1-0141-4f15-8ee6-2d6ca49c904d":{"grid_x_int":5,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"input":{},"rot_int":0},"f2b4220f-28e4-42bd-9b87-e1cb01a585cd":{"grid_x_int":9,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"e6a20e27-aef7-4f7a-a0de-c1dfc51a90e8":{"grid_x_int":11,"index":null,"recommendation_id":null,"output":{"output1":{"dx_int":0,"rot_int":0,"dy_int":1},"output101":{"dx_int":0,"rot_int":0,"dy_int":2},"output102":{"dx_int":0,"rot_int":0,"dy_int":3}},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"b6e4bc85-2f64-4a77-b0cf-2ad9616e7427":{"grid_x_int":14,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"0e708ffb-7424-47e0-930c-a6842c0b3db3":{"grid_x_int":12,"index":null,"recommendation_id":null,"output":{},"source":"","grid_y_int":2,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"076e8b83-9de0-4e1a-a50c-21ec3e9bf295":{"grid_x_int":19,"input":{},"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"output":{},"rot_int":0},"fe4c5bb0-adcd-4461-987a-4052059d9c11":{"grid_x_int":7,"index":null,"recommendation_id":null,"output":{},"source":"","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"f36a32c7-453e-4858-ab54-36d4754077a8":{"grid_x_int":17,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"8aa8139c-1c9a-4ffe-825c-0eeed8642d64":{"grid_x_int":13,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{"input1":{"dx_int":0,"rot_int":0,"dy_int":1},"input101":{"dx_int":0,"rot_int":0,"dy_int":2}},"rot_int":0},"05dcd3c3-5394-4ed6-bcbe-f80d4f2d26f4":{"grid_x_int":12,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":4,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"2c47bedd-1b57-4928-a50e-a9cb1c08cc05":{"grid_x_int":12,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0}},"pan_y_num":0},"snap_map":{"494e685a-26b6-426a-91be-f812cee349ec":{"class_fqid":"com-snaplogic-snaps-flow-filter_2-snapsmrc528","class_id":"com-snaplogic-snaps-flow-filter","class_version":2,"instance_fqid":"494e685a-26b6-426a-91be-f812cee349ec_1","instance_id":"494e685a-26b6-426a-91be-f812cee349ec","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Remove Non-Acvtive"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"filterExpression":{"expression":true,"value":"$EndDate == null || (($EndDate.replace(\"/Date(\",\"\").replace(\")/\",\"\")) > Date.now().getTime())"},"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":"snapsmrc528"},"f36a32c7-453e-4858-ab54-36d4754077a8":{"class_fqid":"com-snaplogic-snaps-transform-groupbyfields_1-snapsmrc528","class_id":"com-snaplogic-snaps-transform-groupbyfields","class_version":1,"instance_fqid":"f36a32c7-453e-4858-ab54-36d4754077a8_1","instance_id":"f36a32c7-453e-4858-ab54-36d4754077a8","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Group By Fields"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"fields":{"value":[{"field":{"value":"$Employee"}},{"field":{"value":"$EmployeeHID"}}]},"execution_mode":{"value":"Validate & Execute"},"targetField":{"value":"group"}},"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"},"fe4c5bb0-adcd-4461-987a-4052059d9c11":{"class_fqid":"com-snaplogic-snaps-flow-filter_2-snapsmrc528","class_id":"com-snaplogic-snaps-flow-filter","class_version":2,"instance_fqid":"fe4c5bb0-adcd-4461-987a-4052059d9c11_1","instance_id":"fe4c5bb0-adcd-4461-987a-4052059d9c11","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Excluded Employees"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"filterExpression":{"expression":true,"value":"_EmployeesExcluded.indexOf($EmployeeHID) == -1"},"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":"snapsmrc528"},"aaa67040-cef7-4d80-a7ed-340978056434":{"class_fqid":"com-snaplogic-snaps-transform-jsonsplitter_1-snapsmrc528","class_id":"com-snaplogic-snaps-transform-jsonsplitter","class_version":1,"instance_fqid":"aaa67040-cef7-4d80-a7ed-340978056434_1","instance_id":"aaa67040-cef7-4d80-a7ed-340978056434","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"JSON Splitter"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"includeParents":{"value":false},"execution_mode":{"value":"Validate & Execute"},"includePaths":{"value":[]},"path":{"value":"$group"}},"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"},"54155607-9ac4-48a8-a44f-14c3f126d130":{"class_fqid":"com-snaplogic-snaps-transform-sort_2-snapsmrc528","class_id":"com-snaplogic-snaps-transform-sort","class_version":2,"instance_fqid":"54155607-9ac4-48a8-a44f-14c3f126d130_1","instance_id":"54155607-9ac4-48a8-a44f-14c3f126d130","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Sort"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"sortPaths":{"value":[{"sortPath":{"value":"$Employee"},"sortOrderInd":{"value":"global"}}]},"execution_mode":{"value":"Validate & Execute"},"nullGreater":{"value":false},"nullSafeAccess":{"value":true},"maxMemoryPercentage":{"value":10},"sortOrder":{"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"},"e5fc2fd9-c863-49ee-92ad-bb83c7a2ab0c":{"class_fqid":"com-snaplogic-snaps-flow-pipeexec_1-snapsmrc528","class_id":"com-snaplogic-snaps-flow-pipeexec","class_version":1,"instance_fqid":"e5fc2fd9-c863-49ee-92ad-bb83c7a2ab0c_1","instance_id":"e5fc2fd9-c863-49ee-92ad-bb83c7a2ab0c","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"No Hours"}},"view_serial":101,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"retryInterval":{"expression":false,"value":1},"retryLimit":{"expression":false,"value":3},"pipeline":{"expression":false,"value":"Use Case - Booked Hours Notifications - No Hours"},"reuse":{"value":false},"batchSize":{"value":1},"execution_mode":{"value":"Validate & Execute"},"executable_during_suggest":{"value":true},"poolSize":{"expression":false,"value":1},"loopDocument":{"expression":true},"execLabel":{"expression":true,"value":null},"params":{"value":[]},"timeout":{"expression":false,"value":300},"snaplex":{"expression":false,"value":null},"snaplexGovernor":{"value":"SNAPLEX_WITH_PATH"}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output101":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"snapsmrc528"},"e5a11d7e-ae47-4200-81b6-49a259c332ec":{"class_fqid":"com-rojoconsultancy-snaps-exactonline-exactread_1-25","class_id":"com-rojoconsultancy-snaps-exactonline-exactread","class_version":1,"instance_fqid":"e5a11d7e-ae47-4200-81b6-49a259c332ec_21","instance_id":"e5a11d7e-ae47-4200-81b6-49a259c332ec","instance_version":21,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Get Hours"}},"view_serial":101,"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"}}}},"input":{"input101":{"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":"$Employee"},"Condition":{"value":"And"},"Field Name":{"expression":false,"value":"Employee"}},{"Operation":{"value":"Greater than or equal"},"Field Value":{"expression":true,"value":"Date.now().minusDays(35)"},"Condition":{"value":"And"},"Field Name":{"expression":false,"value":"Date"}}]},"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":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":false}}},"Maximum request attempts":{"value":3},"API Object":{"expression":false,"value":"Project"},"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":"TimeTransactions"},"Output Fields Advanced Options":{"value":{"Output Entry Limit":{"expression":false,"value":null},"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":true}}},"API object":{"expression":false,"value":"Project"},"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":"Employee"}},{"Element":{"expression":false,"value":"Quantity"}},{"Element":{"expression":false,"value":"HourStatus"}},{"Element":{"expression":false,"value":"Date"}},{"Element":{"expression":false,"value":"Created"}},{"Element":{"expression":false,"value":"Project"}}]},"Filter records":{"value":[{"Operation":{"value":"Equals"},"Field value":{"expression":true,"value":"$Employee"},"Condition":{"value":"And"},"Field name":{"expression":false,"value":"Employee"}}]},"Function Parameter":{"value":[]}},"error":{"error_behavior":{"value":"continue"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"25"},"655198be-8563-4df5-86e6-cf8ccbdc7e17":{"class_fqid":"com-snaplogic-snaps-transform-aggregate_3-snapsmrc528","class_id":"com-snaplogic-snaps-transform-aggregate","class_version":3,"instance_fqid":"655198be-8563-4df5-86e6-cf8ccbdc7e17_1","instance_id":"655198be-8563-4df5-86e6-cf8ccbdc7e17","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"DraftedHours"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"integerMode":{"value":false},"aggregateFields":{"value":[{"function":{"value":"SUM"},"field":{"expression":true,"value":"$Quantity"},"resultField":{"value":"HoursDrafted"}}]},"execution_mode":{"value":"Validate & Execute"},"sortedStreams":{"value":"Unsorted"},"groupByFields":{"value":[{"fieldPath":{"expression":true,"value":"$Employee"},"fieldName":{"value":"Employee"}},{"fieldPath":{"expression":true,"value":"$original.EmployeeHID"},"fieldName":{"value":"EmployeeHID"}}]}},"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"},"7bb98a58-5a09-47a5-a1b5-807e34123c82":{"class_fqid":"com-snaplogic-snaps-transform-multijoin_1-snapsmrc528","class_id":"com-snaplogic-snaps-transform-multijoin","class_version":1,"instance_fqid":"7bb98a58-5a09-47a5-a1b5-807e34123c82_1","instance_id":"7bb98a58-5a09-47a5-a1b5-807e34123c82","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Join"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}},"input1":{"label":{"value":"input1"},"view_type":{"value":"document"}}},"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":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsmrc528"},"c66172e1-0141-4f15-8ee6-2d6ca49c904d":{"class_fqid":"com-rojoconsultancy-snaps-exactonline-exactread_1-25","class_id":"com-rojoconsultancy-snaps-exactonline-exactread","class_version":1,"instance_fqid":"c66172e1-0141-4f15-8ee6-2d6ca49c904d_3","instance_id":"c66172e1-0141-4f15-8ee6-2d6ca49c904d","instance_version":3,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Get EmploymentId"}},"view_serial":101,"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"}}}},"input":{},"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":0}}},"Filter Records":{"value":[]},"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":"EndDate"}},{"Element":{"expression":false,"value":"Employee"}},{"Element":{"expression":false,"value":"EmployeeHID"}},{"Element":{"expression":false,"value":"ID"}}]},"Output fields advanced options":{"value":{"Output entry limit":{"expression":false,"value":null},"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":"Employments"},"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":"EndDate"}},{"Element":{"expression":false,"value":"Employee"}},{"Element":{"expression":false,"value":"EmployeeHID"}},{"Element":{"expression":false,"value":"ID"}}]},"Filter records":{"value":[]},"Function Parameter":{"value":[]}},"error":{"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"25"},"f2b4220f-28e4-42bd-9b87-e1cb01a585cd":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsmrc528","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"f2b4220f-28e4-42bd-9b87-e1cb01a585cd_1","instance_id":"f2b4220f-28e4-42bd-9b87-e1cb01a585cd","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":true},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":true,"value":"$ID"},"targetPath":{"value":"$Employee"}}]},"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"},"e6a20e27-aef7-4f7a-a0de-c1dfc51a90e8":{"class_fqid":"com-snaplogic-snaps-flow-router_2-snapsmrc528","class_id":"com-snaplogic-snaps-flow-router","class_version":2,"instance_fqid":"e6a20e27-aef7-4f7a-a0de-c1dfc51a90e8_1","instance_id":"e6a20e27-aef7-4f7a-a0de-c1dfc51a90e8","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Router"}},"view_serial":102,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"routes":{"value":[{"expression":{"expression":true,"value":"('HourStatus' in $) && ($HourStatus == \"10\" || $HourStatus == \"20\")"},"outputViewName":{"value":"output0"}},{"expression":{"expression":true,"value":"('HourStatus' in $) && ($HourStatus == \"2\")"},"outputViewName":{"value":"output1"}},{"expression":{"expression":true,"value":"('HourStatus' in $) && ($HourStatus == \"1\")"},"outputViewName":{"value":"output2"}},{"expression":{"expression":true,"value":"!('HourStatus' in $)"},"outputViewName":{"value":"output3"}}]},"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"}},"output101":{"view_type":{"value":"document"},"label":{"value":"output2"}},"output102":{"view_type":{"value":"document"},"label":{"value":"output3"}}}},"class_build_tag":"snapsmrc528"},"b6e4bc85-2f64-4a77-b0cf-2ad9616e7427":{"class_fqid":"com-snaplogic-snaps-transform-groupbyn_1-snapsmrc528","class_id":"com-snaplogic-snaps-transform-groupbyn","class_version":1,"instance_fqid":"b6e4bc85-2f64-4a77-b0cf-2ad9616e7427_1","instance_id":"b6e4bc85-2f64-4a77-b0cf-2ad9616e7427","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Group By N"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"execution_mode":{"value":"Validate & Execute"},"targetField":{"value":"group"},"groupSize":{"expression":false,"value":0}},"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"},"0e708ffb-7424-47e0-930c-a6842c0b3db3":{"class_fqid":"com-snaplogic-snaps-transform-aggregate_3-snapsmrc528","class_id":"com-snaplogic-snaps-transform-aggregate","class_version":3,"instance_fqid":"0e708ffb-7424-47e0-930c-a6842c0b3db3_1","instance_id":"0e708ffb-7424-47e0-930c-a6842c0b3db3","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"RejectedHours"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"integerMode":{"value":false},"aggregateFields":{"value":[{"function":{"value":"SUM"},"field":{"expression":true,"value":"$Quantity"},"resultField":{"value":"HoursRejected"}}]},"execution_mode":{"value":"Validate & Execute"},"sortedStreams":{"value":"Unsorted"},"groupByFields":{"value":[{"fieldPath":{"expression":true,"value":"$Employee"},"fieldName":{"value":"Employee"}},{"fieldPath":{"expression":true,"value":"$original.EmployeeHID"},"fieldName":{"value":"EmployeeHID"}}]}},"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"},"076e8b83-9de0-4e1a-a50c-21ec3e9bf295":{"class_fqid":"com-snaplogic-snaps-flow-pipeexec_1-snapsmrc528","class_id":"com-snaplogic-snaps-flow-pipeexec","class_version":1,"instance_fqid":"076e8b83-9de0-4e1a-a50c-21ec3e9bf295_1","instance_id":"076e8b83-9de0-4e1a-a50c-21ec3e9bf295","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Send Email"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"retryInterval":{"expression":false,"value":null},"retryLimit":{"expression":false,"value":null},"pipeline":{"expression":false,"value":"Use Case - Booked Hours Notifications - Send Email"},"reuse":{"value":false},"batchSize":{"value":1},"execution_mode":{"value":"Validate & Execute"},"executable_during_suggest":{"value":true},"poolSize":{"expression":false,"value":1},"loopDocument":{"expression":true},"execLabel":{"expression":true,"value":null},"params":{"value":[]},"timeout":{"expression":false,"value":null},"snaplex":{"expression":false,"value":null},"snaplexGovernor":{"value":"SNAPLEX_WITH_PATH"}},"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"},"bc13ccdd-f269-4ad2-bc3b-f8164d870926":{"class_fqid":"com-rojoconsultancy-snaps-exactonline-exactread_1-25","class_id":"com-rojoconsultancy-snaps-exactonline-exactread","class_version":1,"instance_fqid":"bc13ccdd-f269-4ad2-bc3b-f8164d870926_6","instance_id":"bc13ccdd-f269-4ad2-bc3b-f8164d870926","instance_version":6,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Get All Employees"}},"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"}}}},"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":"$EmployeeHID"},"Condition":{"value":"And"},"Field Name":{"expression":false,"value":"EmployeeHID"}}]},"Function parameter":{"value":[]},"Division":{"expression":true,"value":"_Division"},"Pass through":{"value":false},"Inline count":{"value":false},"Connection timeout":{"value":300},"Output Field Selection":{"value":[{"Element":{"expression":false,"value":"EmployeeHID"}},{"Element":{"expression":false,"value":"ID"}}]},"Output fields advanced options":{"value":{"Output entry limit":{"expression":false,"value":null},"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":"EmployeeHID"}}]},"Filter records":{"value":[{"Operation":{"value":"Equals"},"Field value":{"expression":true,"value":"$EmployeeHID"},"Condition":{"value":"And"},"Field name":{"expression":false,"value":"EmployeeHID"}}]},"Function Parameter":{"value":[]}},"error":{"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"25"},"05dcd3c3-5394-4ed6-bcbe-f80d4f2d26f4":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsmrc528","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"05dcd3c3-5394-4ed6-bcbe-f80d4f2d26f4_1","instance_id":"05dcd3c3-5394-4ed6-bcbe-f80d4f2d26f4","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"No Hours Booked"}},"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":[{"targetPath":{"value":"$Employee"},"expression":{"expression":true,"value":"$original.Employee"}},{"targetPath":{"value":"$Hours"},"expression":{"expression":false,"value":"0"}}]},"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"},"8aa8139c-1c9a-4ffe-825c-0eeed8642d64":{"class_fqid":"com-snaplogic-snaps-flow-union_2-snapsmrc528","class_id":"com-snaplogic-snaps-flow-union","class_version":2,"instance_fqid":"8aa8139c-1c9a-4ffe-825c-0eeed8642d64_1","instance_id":"8aa8139c-1c9a-4ffe-825c-0eeed8642d64","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Union"}},"view_serial":101,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}},"input1":{"view_type":{"value":"document"},"label":{"value":"input1"}},"input101":{"label":{"value":"input2"},"view_type":{"value":"document"}}},"settings":{"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":"snapsmrc528"},"415d4fec-a819-4e2e-8c9e-ba44497df31f":{"class_fqid":"com-snaplogic-snaps-flow-pipeexec_1-snapsmrc528","class_id":"com-snaplogic-snaps-flow-pipeexec","class_version":1,"instance_fqid":"415d4fec-a819-4e2e-8c9e-ba44497df31f_1","instance_id":"415d4fec-a819-4e2e-8c9e-ba44497df31f","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Check Hours"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"retryInterval":{"expression":false,"value":null},"retryLimit":{"expression":false,"value":null},"pipeline":{"expression":false,"value":"Use Case - Booked Hours Notifications - Check Hours"},"reuse":{"value":false},"batchSize":{"value":1},"execution_mode":{"value":"Validate & Execute"},"executable_during_suggest":{"value":true},"poolSize":{"expression":false,"value":1},"loopDocument":{"expression":true},"execLabel":{"expression":true,"value":null},"params":{"value":[{"paramValue":{"expression":true,"value":null},"paramName":{"value":null}}]},"timeout":{"expression":false,"value":null},"snaplex":{"expression":false,"value":null},"snaplexGovernor":{"value":"SNAPLEX_WITH_PATH"}},"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"},"2c47bedd-1b57-4928-a50e-a9cb1c08cc05":{"class_fqid":"com-snaplogic-snaps-transform-aggregate_3-snapsmrc528","class_id":"com-snaplogic-snaps-transform-aggregate","class_version":3,"instance_fqid":"2c47bedd-1b57-4928-a50e-a9cb1c08cc05_1","instance_id":"2c47bedd-1b57-4928-a50e-a9cb1c08cc05","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"BookedHours"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"integerMode":{"value":false},"aggregateFields":{"value":[{"function":{"value":"SUM"},"field":{"expression":true,"value":"$Quantity"},"resultField":{"value":"HoursBooked"}}]},"execution_mode":{"value":"Validate & Execute"},"sortedStreams":{"value":"Unsorted"},"groupByFields":{"value":[{"fieldPath":{"expression":true,"value":"$Employee"},"fieldName":{"value":"Employee"}},{"fieldPath":{"expression":true,"value":"$original.EmployeeHID"},"fieldName":{"value":"EmployeeHID"}}]}},"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"}},"path_id":"/RojoConsultancy1_Dev/Software Development Docs/ExactOnline_1.0.0","path_snode":"602153b02280db50f3db24dd","target_runtime":"standard"}