{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"543857897adce21042e6a6c2","instance_id":"902b80d7-16e0-4a41-aba6-8f4dc35ebe56","instance_version":32,"link_map":{"link137":{"src_view_id":"output0","dst_view_id":"input0","src_id":"aec96260-c822-4b10-9f01-557a1e5e3aa7","dst_id":"1a96bcaa-bcd7-4f20-8b19-dfeaca27c752","isGoto":false},"link134":{"src_view_id":"output0","dst_view_id":"input0","src_id":"7284cf1f-891e-4c0a-8452-b5840474ecbc","dst_id":"f3295bee-1420-401f-936a-556d37ac4f8f","isGoto":false},"link133":{"src_view_id":"output0","dst_view_id":"input0","src_id":"00f37683-bd15-4bb9-965e-b35f7ecfe0f4","dst_id":"d6b8c632-1187-4efd-af94-0889cf37af2f","isGoto":false},"link132":{"src_view_id":"output0","dst_view_id":"input0","src_id":"a1213546-3982-46fb-a2e2-c71a6d04984d","dst_id":"2e3a7f60-ead9-4b8c-8473-65c9e7f74b31","isGoto":false},"link130":{"src_view_id":"output101","dst_view_id":"input0","src_id":"6ca94082-0c6d-44bb-993c-6aa296d2a2db","dst_id":"97ce86bc-b97d-45c9-b365-b27dfa0177cf","isGoto":false},"link139":{"src_view_id":"output0","dst_view_id":"input101","src_id":"d5950fd6-d3df-4b8c-b8c7-4bf74855940d","dst_id":"7284cf1f-891e-4c0a-8452-b5840474ecbc","isGoto":false},"link155":{"src_view_id":"output102","dst_view_id":"input0","src_id":"6f5143ec-0b5c-47cb-b741-f8a755580df2","dst_id":"00f37683-bd15-4bb9-965e-b35f7ecfe0f4","isGoto":false},"link154":{"src_view_id":"output101","dst_view_id":"input101","src_id":"e3aad150-8917-4f5a-ba53-6b8e5a9d2d3a","dst_id":"6f5143ec-0b5c-47cb-b741-f8a755580df2","isGoto":false},"link141":{"src_view_id":"output0","dst_view_id":"input0","src_id":"7506904a-8abb-46dd-a607-a4716fe0e0b4","dst_id":"e3aad150-8917-4f5a-ba53-6b8e5a9d2d3a","isGoto":false},"link146":{"src_view_id":"output101","dst_view_id":"input0","src_id":"6fa87795-3d5e-4527-85ae-2cce837ade36","dst_id":"6ca94082-0c6d-44bb-993c-6aa296d2a2db","isGoto":false},"link147":{"src_view_id":"output102","dst_view_id":"input101","src_id":"f1948ba3-1d2e-439e-b654-22a0e532c602","dst_id":"e27981c2-cdaa-4f5b-a365-aa6311c44739","isGoto":false},"link144":{"src_view_id":"output0","dst_view_id":"input0","src_id":"1a96bcaa-bcd7-4f20-8b19-dfeaca27c752","dst_id":"6fa87795-3d5e-4527-85ae-2cce837ade36","isGoto":false},"link152":{"src_view_id":"output102","dst_view_id":"input0","src_id":"7d912c34-f529-47a5-8ca9-8df7257b35f9","dst_id":"7506904a-8abb-46dd-a607-a4716fe0e0b4","isGoto":false},"link151":{"src_view_id":"output0","dst_view_id":"input101","src_id":"97ce86bc-b97d-45c9-b365-b27dfa0177cf","dst_id":"f1948ba3-1d2e-439e-b654-22a0e532c602","isGoto":false},"link148":{"src_view_id":"output0","dst_view_id":"input0","src_id":"f3295bee-1420-401f-936a-556d37ac4f8f","dst_id":"cc5ea335-e6e6-442e-8397-e54fa297377f","isGoto":false},"link149":{"src_view_id":"error0","dst_view_id":"input0","src_id":"cc5ea335-e6e6-442e-8397-e54fa297377f","dst_id":"a1213546-3982-46fb-a2e2-c71a6d04984d","isGoto":false},"link153":{"src_view_id":"output101","dst_view_id":"input101","src_id":"2e3a7f60-ead9-4b8c-8473-65c9e7f74b31","dst_id":"7d912c34-f529-47a5-8ca9-8df7257b35f9","isGoto":true},"link150":{"src_view_id":"output102","dst_view_id":"input0","src_id":"e27981c2-cdaa-4f5b-a365-aa6311c44739","dst_id":"d5950fd6-d3df-4b8c-b8c7-4bf74855940d","isGoto":false}},"link_serial":156,"property_map":{"info":{"notes":{"value":null},"label":{"value":"MultiExec - Vertica"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"admin@snaplogic.com"}},"input":{},"settings":{"param_table":{"value":[]}},"error":{"error_behavior":{"value":"none"}},"output":{"cc5ea335-e6e6-442e-8397-e54fa297377f_output101":{"header_uris":null,"data_uris":null,"label":{"value":"Vertica - Multi Execute (Beta) - output0"},"view_type":{"value":"document"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"53bf23247adce27d402e76e2","scale_ratio":1,"detail_map":{"6ca94082-0c6d-44bb-993c-6aa296d2a2db":{"grid_x_int":5,"rot_int":0,"grid_y_int":3,"rot_tail_int":0},"6f5143ec-0b5c-47cb-b741-f8a755580df2":{"grid_x_int":9,"rot_int":0,"grid_y_int":5,"rot_tail_int":0},"7284cf1f-891e-4c0a-8452-b5840474ecbc":{"grid_x_int":10,"rot_int":0,"grid_y_int":3,"rot_tail_int":0},"00f37683-bd15-4bb9-965e-b35f7ecfe0f4":{"grid_x_int":10,"rot_int":0,"grid_y_int":5,"rot_tail_int":0},"e27981c2-cdaa-4f5b-a365-aa6311c44739":{"grid_x_int":8,"rot_int":0,"grid_y_int":3,"rot_tail_int":0},"1a96bcaa-bcd7-4f20-8b19-dfeaca27c752":{"grid_x_int":3,"rot_int":0,"grid_y_int":3,"rot_tail_int":0},"f1948ba3-1d2e-439e-b654-22a0e532c602":{"grid_x_int":7,"rot_int":0,"grid_y_int":3,"rot_tail_int":0},"d6b8c632-1187-4efd-af94-0889cf37af2f":{"grid_x_int":11,"rot_int":0,"grid_y_int":5,"rot_tail_int":0},"2e3a7f60-ead9-4b8c-8473-65c9e7f74b31":{"grid_x_int":14,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"aec96260-c822-4b10-9f01-557a1e5e3aa7":{"grid_x_int":2,"rot_int":0,"grid_y_int":3,"rot_tail_int":0},"7506904a-8abb-46dd-a607-a4716fe0e0b4":{"grid_x_int":7,"rot_int":0,"grid_y_int":5,"rot_tail_int":0},"7d912c34-f529-47a5-8ca9-8df7257b35f9":{"grid_x_int":6,"rot_int":0,"grid_y_int":5,"rot_tail_int":0},"e3aad150-8917-4f5a-ba53-6b8e5a9d2d3a":{"grid_x_int":8,"rot_int":0,"grid_y_int":5,"rot_tail_int":0},"cc5ea335-e6e6-442e-8397-e54fa297377f":{"grid_x_int":12,"rot_int":0,"grid_y_int":3,"rot_tail_int":0,"error":{"error0":{"dx_int":0,"rot_int":0,"dy_int":-1}}},"6fa87795-3d5e-4527-85ae-2cce837ade36":{"grid_x_int":4,"rot_int":0,"grid_y_int":3,"rot_tail_int":0},"97ce86bc-b97d-45c9-b365-b27dfa0177cf":{"grid_x_int":6,"grid_y_int":3,"rot_tail_int":0,"output":{},"input":{},"rot_int":0},"f3295bee-1420-401f-936a-556d37ac4f8f":{"grid_x_int":11,"rot_int":0,"grid_y_int":3,"rot_tail_int":0},"d5950fd6-d3df-4b8c-b8c7-4bf74855940d":{"grid_x_int":9,"grid_y_int":3,"rot_tail_int":0,"output":{},"input":{},"rot_int":0},"a1213546-3982-46fb-a2e2-c71a6d04984d":{"grid_x_int":13,"rot_int":0,"grid_y_int":2,"rot_tail_int":0}},"pan_y_num":0},"snap_map":{"6ca94082-0c6d-44bb-993c-6aa296d2a2db":{"class_fqid":"com-snaplogic-snaps-test-assertequals_1-SNAPSHOT","class_id":"com-snaplogic-snaps-test-assertequals","class_version":1,"instance_fqid":"6ca94082-0c6d-44bb-993c-6aa296d2a2db_2","instance_id":"6ca94082-0c6d-44bb-993c-6aa296d2a2db","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Assert Equals"}},"view_serial":101,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"editable_content":{"value":"[{\"execution_0\":{\"sqlStatement\":\"Insert into ADJUSTMENTS VALUES (?, ?, ?, ?, ?, ?, ?, ?)\",\"status\":\"success\",\"successfulDocuments\":[{\"message\":\"success\",\"status\":1,\"original\":{\"SO_ADJ_CD\":\"ZNAJ\",\"SO_ADJ_AM\":\"0.00\",\"LGCL_DEL_FG\":\"N\",\"CR_FG\":\"N\",\"MAIN_MCC_FG\":\"\",\"BUS_AREA_CD\":\"9600\",\"FUNC_AREA_CD\":\"A051\",\"PR_EFF_DT\":\"\"}},{\"message\":\"success\",\"status\":1,\"original\":{\"SO_ADJ_CD\":\"ZNAK\",\"SO_ADJ_AM\":\"0.00\",\"LGCL_DEL_FG\":\"N\",\"CR_FG\":\"N\",\"MAIN_MCC_FG\":\"\",\"BUS_AREA_CD\":\"9600\",\"FUNC_AREA_CD\":\"A051\",\"PR_EFF_DT\":\"\"}}]},\"execution_1\":{\"sqlStatement\":\"Insert into ORDER_DETAIL VALUES (?, ?, ?, ?, ?)\",\"status\":\"success\",\"successfulDocuments\":[{\"message\":\"success\",\"status\":1,\"original\":{\"SO_LN_ITM_NR\":\"000010\",\"SO_DTL_CRT_DT\":\"2014-02-12\",\"SO_DTL_CLOSE_DT\":\"2014-02-12\",\"FXD_VALU_DT\":\"2014-02-12\",\"ORD_LN_CNCL_DT\":\"\"}}]}}]"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null,"header_uris":null,"snap_schema_fqid":{"instance_id":"6fa87795-3d5e-4527-85ae-2cce837ade36","output_view_id":"output101"}},"error_behavior":{"value":"fail"}},"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"},"data_uris":["__suggest__/902b80d7-16e0-4a41-aba6-8f4dc35ebe56/543864617adce21042e6a8af_ad5ab5a7-0200-4ffe-8e7a-26a499bd504e_6ca94082-0c6d-44bb-993c-6aa296d2a2db_output_output101-data-page0.json"],"header_uris":null,"snap_schema_fqid":{"instance_id":"6fa87795-3d5e-4527-85ae-2cce837ade36","output_view_id":"output101"}}}},"class_build_tag":"SNAPSHOT"},"6f5143ec-0b5c-47cb-b741-f8a755580df2":{"class_fqid":"com-snaplogic-snaps-vertica-execute_1-0001","class_id":"com-snaplogic-snaps-vertica-execute","class_version":1,"instance_fqid":"6f5143ec-0b5c-47cb-b741-f8a755580df2_1","instance_id":"6f5143ec-0b5c-47cb-b741-f8a755580df2","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Vertica - Execute"}},"view_serial":102,"account":{"account_ref":{"value":{"label":{"value":"Vertica connection"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-verticadatabaseaccount"},"ref_id":{"value":"bbf22cd1-279d-4f49-9bf6-b7d91adf952c"}}}},"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"executable_during_suggest":{"value":true},"sqlStatement":{"value":"Select count(*) as count from ORDER_DETAIL"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null,"header_uris":null},"error_behavior":{"value":"fail"}},"output":{"output102":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"0001"},"7284cf1f-891e-4c0a-8452-b5840474ecbc":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"7284cf1f-891e-4c0a-8452-b5840474ecbc_1","instance_id":"7284cf1f-891e-4c0a-8452-b5840474ecbc","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"JSON Generator"}},"view_serial":101,"input":{"input101":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"editable_content":{"value":"[{\"ORDER\":{\"HEADER\":{\"SO_ID\":\"6750004375\",\"ORD_CRT_DT\":\"2014-02-12\",\"SRC_SYS_KY\":\"32\",\"SRC_SYS_UPD_TS\":\"2014-04-18 21:50:59.000\",\"CR_HOLD_REL_DT\":\"\",\"SO_CLOSE_DT\":\"2014-08-01\",\"ADMIN_REL_DT\":\"\",\"ORD_CNCL_DT\":\"\",\"SLS_OFF_RCV_DT\":\"\",\"WEB_ORD_CRT_DT\":\"\"},\"ITEMS\":[{\"ORDER_DETAIL\":{\"SO_LN_ITM_NR\":\"000010\",\"SO_DTL_CRT_DT\":\"2014-02-12\",\"SO_DTL_CLOSE_DT\":\"2014-02-12\",\"FXD_VALU_DT\":\"2014-02-12\",\"ORD_LN_CNCL_DT\":\"\"},\"SCHEDULES\":[{\"SCH_LN_NR\":\"0001\",\"LOAD_DT\":\"2014-02-12\",\"SCH_SHIP_DT\":\"2014-02-12\",\"SCH_DLVR_DT\":\"2014-02-12\",\"REQD_DLVR_DT\":\"2014-02-12\",\"MATL_AVL_DT\":\"2014-02-12\"}],\"PARTNERS\":[],\"ADJUSTMENTS\":[{\"SO_ADJ_CD\":\"ZNAJ\",\"SO_ADJ_AM\":\"0.00\",\"LGCL_DEL_FG\":\"N\",\"CR_FG\":\"N\",\"MAIN_MCC_FG\":\"\",\"BUS_AREA_CD\":\"9600\",\"FUNC_AREA_CD\":\"A051\",\"PR_EFF_DT\":\"\"},{\"SO_ADJ_CD\":\"ZNAK\",\"SO_ADJ_AM\":\"0.00\",\"LGCL_DEL_FG\":\"N\",\"CR_FG\":\"N\",\"MAIN_MCC_FG\":\"\",\"BUS_AREA_CD\":\"9600\",\"FUNC_AREA_CD\":\"A051\",\"PR_EFF_DT\":\"\"}],\"DTL_USER_STAT\":[],\"FETR_CHAR\":[]},{\"ORDER_DETAIL\":{\"SO_LN_ITM_NR\":\"000010\",\"SO_DTL_CRT_DT\":\"2014-02-12\",\"SO_DTL_CLOSE_DT\":\"2014-02-12\",\"FXD_VALU_DT\":\"2014-02-12\",\"ORD_LN_CNCL_DT\":\"\"},\"SCHEDULES\":[{\"SCH_LN_NR\":\"0001\",\"LOAD_DT\":\"2014-02-12\",\"SCH_SHIP_DT\":\"2014-02-12\",\"SCH_DLVR_DT\":\"2014-02-12\",\"REQD_DLVR_DT\":\"2014-02-12\",\"MATL_AVL_DT\":\"2014-02-12\"}],\"PARTNERS\":[],\"ADJUSTMENTS\":[{\"SO_ADJ_CD\":\"ZNAJ\",\"SO_ADJ_AM\":\"0.00\",\"LGCL_DEL_FG\":\"N\",\"CR_FG\":\"N\",\"MAIN_MCC_FG\":\"\",\"BUS_AREA_CD\":\"9600\",\"FUNC_AREA_CD\":\"A051\",\"PR_EFF_DT\":\"\"},{\"SO_ADJ_CD\":\"ZNAK\",\"SO_ADJ_AM\":\"0.00\",\"LGCL_DEL_FG\":\"N\",\"CR_FG\":\"N\",\"MAIN_MCC_FG\":\"\",\"BUS_AREA_CD\":\"9600\",\"FUNC_AREA_CD\":\"A051\",\"PR_EFF_DT\":\"\"}],\"DTL_USER_STAT\":[],\"FETR_CHAR\":[]}],\"PARTNERS\":[{\"PTNR_FUNC_CD\":\"AC\",\"EVNT_SPEC_SPLR_ID\":\"\",\"EVNT_SPEC_UNLD_PT_TX\":\"\",\"EVNT_SPEC_PTNR_CNTCT_ID\":\"0000000000\"},{\"PTNR_FUNC_CD\":\"AG\",\"EVNT_SPEC_SPLR_ID\":\"\",\"EVNT_SPEC_UNLD_PT_TX\":\"\",\"EVNT_SPEC_PTNR_CNTCT_ID\":\"0000000000\"}],\"USER_STATUS\":[],\"SPCL_REQD\":[],\"FERT_CHAR\":[]}}]"},"arrayElementsAsDocuments":{"value":true}},"error":{"error0":{"header_uris":null,"snap_schema_fqid":{"instance_id":"e27981c2-cdaa-4f5b-a365-aa6311c44739","output_view_id":"output102"},"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"SNAPSHOT"},"00f37683-bd15-4bb9-965e-b35f7ecfe0f4":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"00f37683-bd15-4bb9-965e-b35f7ecfe0f4_1","instance_id":"00f37683-bd15-4bb9-965e-b35f7ecfe0f4","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper (Data)"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"targetPath":{"value":"$count"},"expression":{"expression":true,"value":"$count"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"header_uris":null,"snap_schema_fqid":{"instance_id":"6f5143ec-0b5c-47cb-b741-f8a755580df2","output_view_id":"output102"},"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"SNAPSHOT"},"7d912c34-f529-47a5-8ca9-8df7257b35f9":{"class_fqid":"com-snaplogic-snaps-vertica-execute_1-0001","class_id":"com-snaplogic-snaps-vertica-execute","class_version":1,"instance_fqid":"7d912c34-f529-47a5-8ca9-8df7257b35f9_1","instance_id":"7d912c34-f529-47a5-8ca9-8df7257b35f9","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Vertica - Execute"}},"view_serial":102,"account":{"account_ref":{"value":{"ref_id":{"value":"bbf22cd1-279d-4f49-9bf6-b7d91adf952c"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-verticadatabaseaccount"},"label":{"value":"Vertica connection"}}}},"settings":{"executable_during_suggest":{"value":true},"sqlStatement":{"value":"Select count(*) as count from ADJUSTMENTS"}},"output":{"output102":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"},"data_uris":null,"header_uris":null},"error_behavior":{"value":"fail"}},"input":{"input101":{"view_type":{"value":"document"},"label":{"value":"input0"}}}},"class_build_tag":"0001"},"1a96bcaa-bcd7-4f20-8b19-dfeaca27c752":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"1a96bcaa-bcd7-4f20-8b19-dfeaca27c752_1","instance_id":"1a96bcaa-bcd7-4f20-8b19-dfeaca27c752","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper (Data)"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"targetPath":{"value":"$ADJUSTMENTS"},"expression":{"expression":true,"value":"jsonPath($, \"$ORDER.ITEMS[0].ADJUSTMENTS\")"}},{"targetPath":{"value":"$ORDER_DETAIL"},"expression":{"expression":true,"value":"jsonPath($, \"$ORDER.ITEMS[0].ORDER_DETAIL\")"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"header_uris":null,"snap_schema_fqid":{"instance_id":"aec96260-c822-4b10-9f01-557a1e5e3aa7","output_view_id":"output0"},"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"SNAPSHOT"},"f1948ba3-1d2e-439e-b654-22a0e532c602":{"class_fqid":"com-snaplogic-snaps-vertica-execute_1-0001","class_id":"com-snaplogic-snaps-vertica-execute","class_version":1,"instance_fqid":"f1948ba3-1d2e-439e-b654-22a0e532c602_1","instance_id":"f1948ba3-1d2e-439e-b654-22a0e532c602","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Vertica - Execute"}},"view_serial":102,"account":{"account_ref":{"value":{"label":{"value":"Vertica connection"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-verticadatabaseaccount"},"ref_id":{"value":"bbf22cd1-279d-4f49-9bf6-b7d91adf952c"}}}},"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"executable_during_suggest":{"value":true},"sqlStatement":{"value":"Delete from ADJUSTMENTS"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null,"header_uris":null},"error_behavior":{"value":"fail"}},"output":{"output102":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"0001"},"d6b8c632-1187-4efd-af94-0889cf37af2f":{"class_fqid":"com-snaplogic-snaps-test-assertequals_1-SNAPSHOT","class_id":"com-snaplogic-snaps-test-assertequals","class_version":1,"instance_fqid":"d6b8c632-1187-4efd-af94-0889cf37af2f_1","instance_id":"d6b8c632-1187-4efd-af94-0889cf37af2f","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Assert Equals"}},"view_serial":100,"error":{"error0":{"header_uris":null,"snap_schema_fqid":{"instance_id":"00f37683-bd15-4bb9-965e-b35f7ecfe0f4","output_view_id":"output0"},"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null},"error_behavior":{"value":"fail"}},"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"editable_content":{"value":"[{\"count\":0}]"}}},"class_build_tag":"SNAPSHOT"},"2e3a7f60-ead9-4b8c-8473-65c9e7f74b31":{"class_fqid":"com-snaplogic-snaps-test-assertequals_1-SNAPSHOT","class_id":"com-snaplogic-snaps-test-assertequals","class_version":1,"instance_fqid":"2e3a7f60-ead9-4b8c-8473-65c9e7f74b31_4","instance_id":"2e3a7f60-ead9-4b8c-8473-65c9e7f74b31","instance_version":4,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Assert Equals"}},"view_serial":101,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"editable_content":{"value":"[{\"execution_1\":{\"status\":\"failed\",\"sqlStatement\":\"Insert into wrongname VALUES (?, ?, ?, ?, ?)\",\"errorDocuments\":[{\"error\":\"Failed to flush batch.\",\"reason\":\"[Vertica][VJDBC](4876) ERROR: Table \\\"wrongname\\\" does not exist\",\"original\":{\"SO_LN_ITM_NR\":\"000010\",\"SO_DTL_CRT_DT\":\"2014-02-12\",\"SO_DTL_CLOSE_DT\":\"2014-02-12\",\"FXD_VALU_DT\":\"2014-02-12\",\"ORD_LN_CNCL_DT\":\"\"},\"resolution\":\"Please address the issue reported by the database.\"}]},\"execution_0\":{\"status\":\"success\",\"sqlStatement\":\"Insert into ADJUSTMENTS VALUES (?, ?, ?, ?, ?, ?, ?, ?)\",\"successfulDocuments\":[{\"message\":\"success\",\"status\":1,\"original\":{\"SO_ADJ_CD\":\"ZNAJ\",\"SO_ADJ_AM\":\"0.00\",\"LGCL_DEL_FG\":\"N\",\"CR_FG\":\"N\",\"MAIN_MCC_FG\":\"\",\"BUS_AREA_CD\":\"9600\",\"FUNC_AREA_CD\":\"A051\",\"PR_EFF_DT\":\"\"}},{\"message\":\"success\",\"status\":1,\"original\":{\"SO_ADJ_CD\":\"ZNAK\",\"SO_ADJ_AM\":\"0.00\",\"LGCL_DEL_FG\":\"N\",\"CR_FG\":\"N\",\"MAIN_MCC_FG\":\"\",\"BUS_AREA_CD\":\"9600\",\"FUNC_AREA_CD\":\"A051\",\"PR_EFF_DT\":\"\"}}]}}]"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null,"header_uris":null,"snap_schema_fqid":{"instance_id":"a1213546-3982-46fb-a2e2-c71a6d04984d","output_view_id":"output0"}},"error_behavior":{"value":"fail"}},"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"},"data_uris":["__suggest__/902b80d7-16e0-4a41-aba6-8f4dc35ebe56/543864617adce21042e6a8af_d4a27b6d-3212-4bd7-a31e-98f4f1161f57_2e3a7f60-ead9-4b8c-8473-65c9e7f74b31_output_output101-data-page0.json"],"header_uris":null,"snap_schema_fqid":{"instance_id":"a1213546-3982-46fb-a2e2-c71a6d04984d","output_view_id":"output0"}}}},"class_build_tag":"SNAPSHOT"},"aec96260-c822-4b10-9f01-557a1e5e3aa7":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"aec96260-c822-4b10-9f01-557a1e5e3aa7_1","instance_id":"aec96260-c822-4b10-9f01-557a1e5e3aa7","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"JSON Generator"}},"view_serial":100,"error":{"error0":{"header_uris":null,"snap_schema_fqid":{"instance_id":"aec96260-c822-4b10-9f01-557a1e5e3aa7","output_view_id":"error0"},"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}},"settings":{"editable_content":{"value":"[{\"ORDER\":{\"HEADER\":{\"SO_ID\":\"6750004375\",\"ORD_CRT_DT\":\"2014-02-12\",\"SRC_SYS_KY\":\"32\",\"SRC_SYS_UPD_TS\":\"2014-04-18 21:50:59.000\",\"CR_HOLD_REL_DT\":\"\",\"SO_CLOSE_DT\":\"2014-08-01\",\"ADMIN_REL_DT\":\"\",\"ORD_CNCL_DT\":\"\",\"SLS_OFF_RCV_DT\":\"\",\"WEB_ORD_CRT_DT\":\"\"},\"ITEMS\":[{\"ORDER_DETAIL\":{\"SO_LN_ITM_NR\":\"000010\",\"SO_DTL_CRT_DT\":\"2014-02-12\",\"SO_DTL_CLOSE_DT\":\"2014-02-12\",\"FXD_VALU_DT\":\"2014-02-12\",\"ORD_LN_CNCL_DT\":\"\"},\"SCHEDULES\":[{\"SCH_LN_NR\":\"0001\",\"LOAD_DT\":\"2014-02-12\",\"SCH_SHIP_DT\":\"2014-02-12\",\"SCH_DLVR_DT\":\"2014-02-12\",\"REQD_DLVR_DT\":\"2014-02-12\",\"MATL_AVL_DT\":\"2014-02-12\"}],\"PARTNERS\":[],\"ADJUSTMENTS\":[{\"SO_ADJ_CD\":\"ZNAJ\",\"SO_ADJ_AM\":\"0.00\",\"LGCL_DEL_FG\":\"N\",\"CR_FG\":\"N\",\"MAIN_MCC_FG\":\"\",\"BUS_AREA_CD\":\"9600\",\"FUNC_AREA_CD\":\"A051\",\"PR_EFF_DT\":\"\"},{\"SO_ADJ_CD\":\"ZNAK\",\"SO_ADJ_AM\":\"0.00\",\"LGCL_DEL_FG\":\"N\",\"CR_FG\":\"N\",\"MAIN_MCC_FG\":\"\",\"BUS_AREA_CD\":\"9600\",\"FUNC_AREA_CD\":\"A051\",\"PR_EFF_DT\":\"\"}],\"DTL_USER_STAT\":[],\"FETR_CHAR\":[]},{\"ORDER_DETAIL\":{\"SO_LN_ITM_NR\":\"000010\",\"SO_DTL_CRT_DT\":\"2014-02-12\",\"SO_DTL_CLOSE_DT\":\"2014-02-12\",\"FXD_VALU_DT\":\"2014-02-12\",\"ORD_LN_CNCL_DT\":\"\"},\"SCHEDULES\":[{\"SCH_LN_NR\":\"0001\",\"LOAD_DT\":\"2014-02-12\",\"SCH_SHIP_DT\":\"2014-02-12\",\"SCH_DLVR_DT\":\"2014-02-12\",\"REQD_DLVR_DT\":\"2014-02-12\",\"MATL_AVL_DT\":\"2014-02-12\"}],\"PARTNERS\":[],\"ADJUSTMENTS\":[{\"SO_ADJ_CD\":\"ZNAJ\",\"SO_ADJ_AM\":\"0.00\",\"LGCL_DEL_FG\":\"N\",\"CR_FG\":\"N\",\"MAIN_MCC_FG\":\"\",\"BUS_AREA_CD\":\"9600\",\"FUNC_AREA_CD\":\"A051\",\"PR_EFF_DT\":\"\"},{\"SO_ADJ_CD\":\"ZNAK\",\"SO_ADJ_AM\":\"0.00\",\"LGCL_DEL_FG\":\"N\",\"CR_FG\":\"N\",\"MAIN_MCC_FG\":\"\",\"BUS_AREA_CD\":\"9600\",\"FUNC_AREA_CD\":\"A051\",\"PR_EFF_DT\":\"\"}],\"DTL_USER_STAT\":[],\"FETR_CHAR\":[]}],\"PARTNERS\":[{\"PTNR_FUNC_CD\":\"AC\",\"EVNT_SPEC_SPLR_ID\":\"\",\"EVNT_SPEC_UNLD_PT_TX\":\"\",\"EVNT_SPEC_PTNR_CNTCT_ID\":\"0000000000\"},{\"PTNR_FUNC_CD\":\"AG\",\"EVNT_SPEC_SPLR_ID\":\"\",\"EVNT_SPEC_UNLD_PT_TX\":\"\",\"EVNT_SPEC_PTNR_CNTCT_ID\":\"0000000000\"}],\"USER_STATUS\":[],\"SPCL_REQD\":[],\"FERT_CHAR\":[]}}]"},"arrayElementsAsDocuments":{"value":true}}},"class_build_tag":"SNAPSHOT"},"7506904a-8abb-46dd-a607-a4716fe0e0b4":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"7506904a-8abb-46dd-a607-a4716fe0e0b4_1","instance_id":"7506904a-8abb-46dd-a607-a4716fe0e0b4","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper (Data)"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"targetPath":{"value":"count"},"expression":{"expression":true,"value":"$count"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"header_uris":null,"snap_schema_fqid":{"instance_id":"7d912c34-f529-47a5-8ca9-8df7257b35f9","output_view_id":"output102"},"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"SNAPSHOT"},"e27981c2-cdaa-4f5b-a365-aa6311c44739":{"class_fqid":"com-snaplogic-snaps-vertica-execute_1-0001","class_id":"com-snaplogic-snaps-vertica-execute","class_version":1,"instance_fqid":"e27981c2-cdaa-4f5b-a365-aa6311c44739_1","instance_id":"e27981c2-cdaa-4f5b-a365-aa6311c44739","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Vertica - Execute"}},"view_serial":102,"account":{"account_ref":{"value":{"ref_id":{"value":"bbf22cd1-279d-4f49-9bf6-b7d91adf952c"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-verticadatabaseaccount"},"label":{"value":"Vertica connection"}}}},"settings":{"executable_during_suggest":{"value":true},"sqlStatement":{"value":"Delete from ORDER_DETAIL"}},"output":{"output102":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"},"data_uris":null,"header_uris":null},"error_behavior":{"value":"fail"}},"input":{"input101":{"view_type":{"value":"document"},"label":{"value":"input0"}}}},"class_build_tag":"0001"},"e3aad150-8917-4f5a-ba53-6b8e5a9d2d3a":{"class_fqid":"com-snaplogic-snaps-test-assertequals_1-SNAPSHOT","class_id":"com-snaplogic-snaps-test-assertequals","class_version":1,"instance_fqid":"e3aad150-8917-4f5a-ba53-6b8e5a9d2d3a_1","instance_id":"e3aad150-8917-4f5a-ba53-6b8e5a9d2d3a","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Assert Equals"}},"view_serial":101,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"editable_content":{"value":"[{\"count\":0}]"}},"error":{"error0":{"header_uris":null,"snap_schema_fqid":{"instance_id":"7506904a-8abb-46dd-a607-a4716fe0e0b4","output_view_id":"output0"},"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null},"error_behavior":{"value":"fail"}},"output":{"output101":{"header_uris":null,"snap_schema_fqid":{"instance_id":"7506904a-8abb-46dd-a607-a4716fe0e0b4","output_view_id":"output0"},"label":{"value":"output0"},"view_type":{"value":"document"},"data_uris":["__suggest__/902b80d7-16e0-4a41-aba6-8f4dc35ebe56/543864617adce21042e6a8af_d4a27b6d-3212-4bd7-a31e-98f4f1161f57_e3aad150-8917-4f5a-ba53-6b8e5a9d2d3a_output_output101-data-page0.json"]}}},"class_build_tag":"SNAPSHOT"},"cc5ea335-e6e6-442e-8397-e54fa297377f":{"class_fqid":"com-snaplogic-snaps-vertica-multiexecute_1-0001","class_id":"com-snaplogic-snaps-vertica-multiexecute","class_version":1,"instance_fqid":"cc5ea335-e6e6-442e-8397-e54fa297377f_4","instance_id":"cc5ea335-e6e6-442e-8397-e54fa297377f","instance_version":4,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Vertica - Multi Execute (Beta)"}},"view_serial":101,"account":{"account_ref":{"value":{"ref_id":{"value":"bbf22cd1-279d-4f49-9bf6-b7d91adf952c"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-verticadatabaseaccount"},"label":{"value":"Vertica connection"}}}},"settings":{"multiExecuteTable":{"value":[{"path":{"expression":true,"value":"jsonPath($, \"$ADJUSTMENTS[*]\")"},"sqlStatement":{"value":"Insert into ADJUSTMENTS VALUES ($BUS_AREA_CD, $CR_FG, $FUNC_AREA_CD, $LGCL_DEL_FG, $MAIN_MCC_FG, $PR_EFF_DT, $SO_ADJ_AM, $SO_ADJ_CD)"}},{"path":{"expression":true,"value":"$ORDER_DETAIL"},"sqlStatement":{"value":"Insert into wrongname VALUES ($FXD_VALU_DT, $ORD_LN_CNCL_DT, $SO_DTL_CLOSE_DT, $SO_DTL_CRT_DT, $SO_LN_ITM_NR)"}}]},"executable_during_suggest":{"value":true}},"output":{"output101":{"view_type":{"value":"document"},"label":{"value":"output0"},"data_uris":null,"header_uris":null}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"continue"}},"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"0001"},"6fa87795-3d5e-4527-85ae-2cce837ade36":{"class_fqid":"com-snaplogic-snaps-vertica-multiexecute_1-0001","class_id":"com-snaplogic-snaps-vertica-multiexecute","class_version":1,"instance_fqid":"6fa87795-3d5e-4527-85ae-2cce837ade36_6","instance_id":"6fa87795-3d5e-4527-85ae-2cce837ade36","instance_version":6,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Vertica - Multi Execute (Beta)"}},"view_serial":101,"account":{"account_ref":{"value":{"label":{"value":"Vertica connection"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-verticadatabaseaccount"},"ref_id":{"value":"bbf22cd1-279d-4f49-9bf6-b7d91adf952c"}}}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"multiExecuteTable":{"value":[{"path":{"expression":true,"value":"jsonPath($, \"$ADJUSTMENTS[*]\")"},"sqlStatement":{"value":"Insert into ADJUSTMENTS VALUES ($BUS_AREA_CD, $CR_FG, $FUNC_AREA_CD, $LGCL_DEL_FG, $MAIN_MCC_FG, $PR_EFF_DT, $SO_ADJ_AM, $SO_ADJ_CD)"}},{"path":{"expression":true,"value":"$ORDER_DETAIL"},"sqlStatement":{"value":"Insert into ORDER_DETAIL VALUES ($FXD_VALU_DT, $ORD_LN_CNCL_DT, $SO_DTL_CLOSE_DT, $SO_DTL_CRT_DT, $SO_LN_ITM_NR)"}}]},"executable_during_suggest":{"value":true}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null,"header_uris":null},"error_behavior":{"value":"fail"}},"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"0001"},"97ce86bc-b97d-45c9-b365-b27dfa0177cf":{"class_fqid":"com-snaplogic-snaps-flow-tail_1-SNAPSHOT","class_id":"com-snaplogic-snaps-flow-tail","class_version":1,"instance_fqid":"97ce86bc-b97d-45c9-b365-b27dfa0177cf_1","instance_id":"97ce86bc-b97d-45c9-b365-b27dfa0177cf","instance_version":1,"property_map":{"info":{"label":{"value":"Tail"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"numOfDocs":{"value":1},"offset":{"value":0}},"error":{"error0":{"header_uris":null,"snap_schema_fqid":{"instance_id":"6fa87795-3d5e-4527-85ae-2cce837ade36","output_view_id":"output101"},"label":{"value":"error0"},"view_type":{"value":"document"},"data_uris":null},"error_behavior":{"value":"fail"}},"output":{"output0":{"header_uris":null,"snap_schema_fqid":{"instance_id":"6fa87795-3d5e-4527-85ae-2cce837ade36","output_view_id":"output101"},"label":{"value":"output0"},"view_type":{"value":"document"},"data_uris":["__suggest__/902b80d7-16e0-4a41-aba6-8f4dc35ebe56/543864617adce21042e6a8af_ad5ab5a7-0200-4ffe-8e7a-26a499bd504e_97ce86bc-b97d-45c9-b365-b27dfa0177cf_output_output0-data-page0.json"]}}},"class_build_tag":"SNAPSHOT"},"f3295bee-1420-401f-936a-556d37ac4f8f":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"f3295bee-1420-401f-936a-556d37ac4f8f_1","instance_id":"f3295bee-1420-401f-936a-556d37ac4f8f","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper (Data)"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"targetPath":{"value":"$ADJUSTMENTS"},"expression":{"expression":true,"value":"jsonPath($, \"$ORDER.ITEMS[0].ADJUSTMENTS\")"}},{"targetPath":{"value":"$ORDER_DETAIL"},"expression":{"expression":true,"value":"jsonPath($, \"$ORDER.ITEMS[0].ORDER_DETAIL\")"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"header_uris":null,"snap_schema_fqid":{"instance_id":"7284cf1f-891e-4c0a-8452-b5840474ecbc","output_view_id":"output0"},"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"SNAPSHOT"},"d5950fd6-d3df-4b8c-b8c7-4bf74855940d":{"class_fqid":"com-snaplogic-snaps-flow-tail_1-SNAPSHOT","class_id":"com-snaplogic-snaps-flow-tail","class_version":1,"instance_fqid":"d5950fd6-d3df-4b8c-b8c7-4bf74855940d_1","instance_id":"d5950fd6-d3df-4b8c-b8c7-4bf74855940d","instance_version":1,"property_map":{"info":{"label":{"value":"Tail"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"numOfDocs":{"value":1},"offset":{"value":0}},"error":{"error0":{"header_uris":null,"snap_schema_fqid":{"instance_id":"e27981c2-cdaa-4f5b-a365-aa6311c44739","output_view_id":"output102"},"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null},"error_behavior":{"value":"fail"}},"output":{"output0":{"header_uris":null,"snap_schema_fqid":{"instance_id":"e27981c2-cdaa-4f5b-a365-aa6311c44739","output_view_id":"output102"},"view_type":{"value":"document"},"label":{"value":"output0"},"data_uris":["__suggest__/902b80d7-16e0-4a41-aba6-8f4dc35ebe56/543864617adce21042e6a8af_ad5ab5a7-0200-4ffe-8e7a-26a499bd504e_d5950fd6-d3df-4b8c-b8c7-4bf74855940d_output_output0-data-page0.json"]}}},"class_build_tag":"SNAPSHOT"},"a1213546-3982-46fb-a2e2-c71a6d04984d":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"a1213546-3982-46fb-a2e2-c71a6d04984d_1","instance_id":"a1213546-3982-46fb-a2e2-c71a6d04984d","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper (Data)"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":true},"transformations":{"value":{"mappingTable":{"value":[{"targetPath":{"value":null},"expression":{"expression":true,"value":"jsonPath($, \"$execution_1.errorDocuments[*].stacktrace\")"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"header_uris":null,"snap_schema_fqid":{"instance_id":"cc5ea335-e6e6-442e-8397-e54fa297377f","output_view_id":"error0"},"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"SNAPSHOT"}},"path_id":"/snaplogic/projects/diagnostic","path_snode":"53bf231c7adce2796c3c6ef3"}