{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"69fb20ab347f62a6d5bcda64","instance_id":"b03a78cd-289b-4305-8530-c44faff1dbea","instance_version":3,"link_map":{"link103":{"dst_id":"a776cde4-6ff8-4bb8-8347-9b42f505cd27","dst_view_id":"input0","src_id":"b0d851a2-c8c5-45c3-b3f3-be7cee3b6ecb","src_view_id":"output0","isGoto":true},"link104":{"dst_id":"a776cde4-6ff8-4bb8-8347-9b42f505cd27","dst_view_id":"input1","src_id":"685679bc-6cc0-416f-bf80-e849be33ac4a","src_view_id":"output1","isGoto":true},"link109":{"dst_id":"8a3d4a68-9219-467d-b0c3-669894d51079","dst_view_id":"input0","src_id":"a776cde4-6ff8-4bb8-8347-9b42f505cd27","src_view_id":"output0","isGoto":false},"link110":{"dst_id":"8a3d4a68-9219-467d-b0c3-669894d51079","dst_view_id":"input1","src_id":"f0d9e074-81d9-494f-8576-e5eb3edeb2ed","src_view_id":"output0","isGoto":true},"link111":{"dst_id":"b0d851a2-c8c5-45c3-b3f3-be7cee3b6ecb","dst_view_id":"input0","src_id":"3f803221-9697-435c-b1e4-32492d1554b7","src_view_id":"error0","isGoto":false},"link112":{"dst_id":"3f803221-9697-435c-b1e4-32492d1554b7","dst_view_id":"inputRows","src_id":"685679bc-6cc0-416f-bf80-e849be33ac4a","src_view_id":"output0","isGoto":false},"link113":{"dst_id":"f0d9e074-81d9-494f-8576-e5eb3edeb2ed","dst_view_id":"input0","src_id":"3f803221-9697-435c-b1e4-32492d1554b7","src_view_id":"output101","isGoto":false}},"link_serial":114,"property_map":{"info":{"label":{"value":"postgres child pipeline bulk upsert"},"author":{"value":"admin@snaplogic.com"},"pipeline_doc_uri":{"value":null},"notes":{"value":null},"purpose":{"value":null}},"error":{"error_behavior":{"value":"none"}},"settings":{"suspendable":{"value":false},"error_pipeline":{"value":null,"expression":false},"error_param_table":{"value":[]},"param_table":{"value":[]},"imports":{"value":[]},"cache_pipelines":{"value":[]},"tags":{"value":[]}},"input":{"685679bc-6cc0-416f-bf80-e849be33ac4a_input0":{"view_type":{"value":"document"},"label":{"value":"Copy - input0"}}},"output":{"8a3d4a68-9219-467d-b0c3-669894d51079_output0":{"view_type":{"value":"document"},"label":{"value":"Union - output0"}}}},"render_map":{"scale_ratio":1,"pan_x_num":0,"pan_y_num":0,"default_snaplex":"6822d5719f577ec4a9f736a4","detail_map":{"685679bc-6cc0-416f-bf80-e849be33ac4a":{"grid_x_int":1,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"output":{"output1":{"rot_int":0,"dx_int":0,"dy_int":1}},"input":{},"error":{}},"3f803221-9697-435c-b1e4-32492d1554b7":{"grid_x_int":2,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"error":{"error0":{"rot_int":0,"dx_int":0,"dy_int":-1}}},"f0d9e074-81d9-494f-8576-e5eb3edeb2ed":{"grid_x_int":3,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"input":{},"output":{},"error":{}},"b0d851a2-c8c5-45c3-b3f3-be7cee3b6ecb":{"grid_x_int":3,"grid_y_int":1,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"input":{},"output":{},"error":{}},"a776cde4-6ff8-4bb8-8347-9b42f505cd27":{"grid_x_int":5,"grid_y_int":1,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"input":{"input1":{"rot_int":0,"dx_int":0,"dy_int":1}},"output":{},"error":{}},"8a3d4a68-9219-467d-b0c3-669894d51079":{"grid_x_int":6,"grid_y_int":1,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"output":{},"input":{"input1":{"rot_int":0,"dx_int":0,"dy_int":1}},"error":{}}}},"snap_map":{"685679bc-6cc0-416f-bf80-e849be33ac4a":{"class_fqid":"com-snaplogic-snaps-flow-copy_1-main34730","class_id":"com-snaplogic-snaps-flow-copy","class_version":1,"instance_fqid":"685679bc-6cc0-416f-bf80-e849be33ac4a_1","instance_id":"685679bc-6cc0-416f-bf80-e849be33ac4a","instance_version":1,"property_map":{"info":{"label":{"value":"Copy"}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}},"output1":{"view_type":{"value":"document"},"label":{"value":"output1"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"}},"view_serial":100},"class_build_tag":"main34730"},"3f803221-9697-435c-b1e4-32492d1554b7":{"class_fqid":"com-snaplogic-snaps-postgres-bulkupsert_1-main34730","class_id":"com-snaplogic-snaps-postgres-bulkupsert","class_version":1,"instance_fqid":"3f803221-9697-435c-b1e4-32492d1554b7_2","instance_id":"3f803221-9697-435c-b1e4-32492d1554b7","instance_version":2,"property_map":{"info":{"label":{"value":"PostgreSQL - Bulk Upsert"},"notes":{}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"continue"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"executable_during_suggest":{"value":false},"schemaName":{"value":null,"expression":false},"tableName":{"value":"\"public\".\"target_table1\"","expression":false},"columnList":{"value":[{"columns":{"value":"id","expression":false}}]},"deleteProp":{"value":null,"expression":false},"additionalOptionsProp":{"value":[]}},"account":{"account_ref":{"value":{"label":{"value":"postgreslocal","label":"shared/postgreslocal","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-postgresdatabaseaccount"},"ref_id":{"value":"422b3d3d-6dcf-4620-baf9-6ae56e358a5c","expression":false}}}},"view_serial":101,"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"main34730"},"f0d9e074-81d9-494f-8576-e5eb3edeb2ed":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-main33142","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"f0d9e074-81d9-494f-8576-e5eb3edeb2ed_1","instance_id":"f0d9e074-81d9-494f-8576-e5eb3edeb2ed","instance_version":1,"property_map":{"info":{"label":{"value":"Mapper"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"passThrough":{"value":true},"transformations":{"value":{"mappingRoot":{"value":"$"},"mappingTable":{"value":[{"expression":{"expression":true,"value":"'success'"},"targetPath":{"value":"customField"}}]}}},"nullSafeAccess":{"value":false}},"view_serial":100},"class_build_tag":"main33142"},"b0d851a2-c8c5-45c3-b3f3-be7cee3b6ecb":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-main33142","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"b0d851a2-c8c5-45c3-b3f3-be7cee3b6ecb_1","instance_id":"b0d851a2-c8c5-45c3-b3f3-be7cee3b6ecb","instance_version":1,"property_map":{"info":{"label":{"value":"Mapper1"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"passThrough":{"value":false},"transformations":{"value":{"mappingRoot":{"value":"$"},"mappingTable":{"value":[{"expression":{"expression":true,"value":"'failure'"},"targetPath":{"value":"customField"}}]}}},"nullSafeAccess":{"value":false}},"view_serial":100},"class_build_tag":"main33142"},"a776cde4-6ff8-4bb8-8347-9b42f505cd27":{"class_fqid":"com-snaplogic-snaps-transform-multijoin_1-main33142","class_id":"com-snaplogic-snaps-transform-multijoin","class_version":1,"instance_fqid":"a776cde4-6ff8-4bb8-8347-9b42f505cd27_1","instance_id":"a776cde4-6ff8-4bb8-8347-9b42f505cd27","instance_version":1,"property_map":{"info":{"label":{"value":"Join"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}},"input1":{"view_type":{"value":"document"},"label":{"value":"input1"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"availableMemoryThreshold":{"value":20,"expression":false},"joinPaths":{"value":[{"leftPath":{"expression":true,"value":"true"},"rightPath":{"expression":true,"value":"true"},"rightInputView":{"value":"input1"}}]},"joinType":{"value":"Inner"},"execution_mode":{"value":"Validate & Execute"},"outOfResourceTimeout":{"value":30,"expression":false},"noMatchData":{"value":false},"minimumMemory":{"value":500,"expression":false},"minimumFreeDiskSpace":{"value":500,"expression":false},"nullGreater":{"value":false},"sortedStreams":{"value":"Ascending"},"nullSafeAccess":{"value":false}},"view_serial":100},"class_build_tag":"main33142"},"8a3d4a68-9219-467d-b0c3-669894d51079":{"class_fqid":"com-snaplogic-snaps-flow-union_2-main34730","class_id":"com-snaplogic-snaps-flow-union","class_version":2,"instance_fqid":"8a3d4a68-9219-467d-b0c3-669894d51079_1","instance_id":"8a3d4a68-9219-467d-b0c3-669894d51079","instance_version":1,"property_map":{"info":{"label":{"value":"Union"}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}},"input1":{"view_type":{"value":"document"},"label":{"value":"input1"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"}},"view_serial":100},"class_build_tag":"main34730"}},"path_id":"/snaplogic/projects/shared","path_snode":"67597d0cbf225a345176406e"}