{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"5467ea0ba9733381efadaa3e","instance_id":"71cc09e5-3b61-4baa-a6c8-ecc5edff846f","instance_version":17,"link_map":{"link110":{"src_view_id":"output0","dst_view_id":"input0","src_id":"f5d118e3-ff6d-4ad6-958f-74f98bcd37e5","dst_id":"feb92bc5-30ae-400b-9cc0-883476cf9ee3","isGoto":false},"link104":{"src_view_id":"output0","dst_view_id":"input0","src_id":"0b6ac8ef-c749-4ffa-97dd-17d05a35cde7","dst_id":"f5d118e3-ff6d-4ad6-958f-74f98bcd37e5","isGoto":false},"link102":{"src_view_id":"output0","dst_view_id":"input0","src_id":"2195d294-6769-4d1a-b97a-1aad1df9d669","dst_id":"d4b6d164-f8e7-49d9-9162-167c614bea80","isGoto":false},"link100":{"src_view_id":"outputRows","dst_view_id":"input0","src_id":"e85f2420-f6dd-4ba6-a0ca-c4d14faacc85","dst_id":"0b6ac8ef-c749-4ffa-97dd-17d05a35cde7","isGoto":false},"link109":{"src_view_id":"output0","dst_view_id":"input0","src_id":"feb92bc5-30ae-400b-9cc0-883476cf9ee3","dst_id":"2195d294-6769-4d1a-b97a-1aad1df9d669","isGoto":false}},"link_serial":111,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Oracle_Lookup_Example"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"xwang@snaplogic.com"}},"input":{},"settings":{"param_table":{"value":[]}},"error":{"0b6ac8ef-c749-4ffa-97dd-17d05a35cde7_error0":{"view_type":{"value":"document"},"label":{"value":"Oracle - Lookup - error0"}},"error_behavior":{"value":"none"}},"output":{}},"render_map":{"pan_x_num":0,"default_snaplex":"53ab67598ecac41e67f1657c","scale_ratio":1,"detail_map":{"feb92bc5-30ae-400b-9cc0-883476cf9ee3":{"grid_x_int":4,"rot_int":0,"grid_y_int":6,"rot_tail_int":0},"e85f2420-f6dd-4ba6-a0ca-c4d14faacc85":{"grid_x_int":1,"rot_int":0,"grid_y_int":6,"rot_tail_int":0},"2195d294-6769-4d1a-b97a-1aad1df9d669":{"grid_x_int":5,"grid_y_int":6,"rot_tail_int":0,"output":{},"input":{},"rot_int":0},"f5d118e3-ff6d-4ad6-958f-74f98bcd37e5":{"grid_x_int":3,"rot_int":0,"grid_y_int":6,"rot_tail_int":0},"0b6ac8ef-c749-4ffa-97dd-17d05a35cde7":{"grid_x_int":2,"rot_int":0,"grid_y_int":6,"rot_tail_int":0,"error":{"error0":{"dx_int":0,"rot_int":0,"dy_int":-1}}},"d4b6d164-f8e7-49d9-9162-167c614bea80":{"grid_x_int":6,"rot_int":0,"grid_y_int":6,"rot_tail_int":0}},"pan_y_num":0},"snap_map":{"feb92bc5-30ae-400b-9cc0-883476cf9ee3":{"class_fqid":"com-snaplogic-snaps-flow-filter_2-SNAPSHOT","class_id":"com-snaplogic-snaps-flow-filter","class_version":2,"instance_fqid":"feb92bc5-30ae-400b-9cc0-883476cf9ee3_1","instance_id":"feb92bc5-30ae-400b-9cc0-883476cf9ee3","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Filter"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"filterExpression":{"expression":true,"value":"$NAME != \"Adam\""}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"},"data_uris":null,"header_uris":null,"snap_schema_fqid":{"instance_id":"e85f2420-f6dd-4ba6-a0ca-c4d14faacc85","output_view_id":"outputRows"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"},"data_uris":null,"header_uris":null,"snap_schema_fqid":{"instance_id":"e85f2420-f6dd-4ba6-a0ca-c4d14faacc85","output_view_id":"outputRows"}}}},"class_build_tag":"SNAPSHOT"},"e85f2420-f6dd-4ba6-a0ca-c4d14faacc85":{"class_fqid":"com-snaplogic-snaps-oracle-select_3-SNAPSHOT","class_id":"com-snaplogic-snaps-oracle-select","class_version":3,"instance_fqid":"e85f2420-f6dd-4ba6-a0ca-c4d14faacc85_2","instance_id":"e85f2420-f6dd-4ba6-a0ca-c4d14faacc85","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Oracle - Select"}},"view_serial":100,"account":{"account_ref":{"value":{"label":{"value":"oracle_account2-1e60fbf047b713afd440c45da1012a81"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-oraclethindatabaseaccount"},"ref_id":{"value":"660ddc81-203f-46c4-b2e1-3db7c4d29319"}}}},"settings":{"orderBy":{"value":[]},"limitRows":{"expression":false,"value":null},"tableName":{"expression":false,"value":"STUDENT"},"whereClause":{"value":"NAME = 'Adam'"},"schemaName":{"expression":false,"value":"TECTONIC"},"limitOffset":{"expression":false,"value":null}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null,"header_uris":null,"snap_schema_fqid":{"instance_id":"e85f2420-f6dd-4ba6-a0ca-c4d14faacc85","output_view_id":"error0"}},"error_behavior":{"value":"fail"}},"output":{"outputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}}},"class_build_tag":"SNAPSHOT"},"2195d294-6769-4d1a-b97a-1aad1df9d669":{"class_fqid":"com-snaplogic-snaps-transform-jsonformatter_2-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-jsonformatter","class_version":2,"instance_fqid":"2195d294-6769-4d1a-b97a-1aad1df9d669_1","instance_id":"2195d294-6769-4d1a-b97a-1aad1df9d669","instance_version":1,"property_map":{"info":{"label":{"value":"JSON Formatter"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"ignoreEmptyStream":{"value":false}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"binary"},"data_uris":null,"header_uris":null},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"binary"},"data_uris":["__suggest__/71cc09e5-3b61-4baa-a6c8-ecc5edff846f/5468f77ca973339c1df10b43_4907e331-1bbe-4db0-9c95-6dac7ce16c36_2195d294-6769-4d1a-b97a-1aad1df9d669_output_output0-data-binary0.dat"],"header_uris":["__suggest__/71cc09e5-3b61-4baa-a6c8-ecc5edff846f/5468f77ca973339c1df10b43_4907e331-1bbe-4db0-9c95-6dac7ce16c36_2195d294-6769-4d1a-b97a-1aad1df9d669_output_output0-header-data-binary0.dat"]}}},"class_build_tag":"SNAPSHOT"},"f5d118e3-ff6d-4ad6-958f-74f98bcd37e5":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"f5d118e3-ff6d-4ad6-958f-74f98bcd37e5_1","instance_id":"f5d118e3-ff6d-4ad6-958f-74f98bcd37e5","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":"$NAME"},"expression":{"expression":true,"value":"$NAME"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"},"data_uris":null,"header_uris":null,"snap_schema_fqid":{"instance_id":"e85f2420-f6dd-4ba6-a0ca-c4d14faacc85","output_view_id":"outputRows"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"},"data_uris":null,"header_uris":null,"snap_schema_fqid":{"instance_id":"e85f2420-f6dd-4ba6-a0ca-c4d14faacc85","output_view_id":"outputRows"}}}},"class_build_tag":"SNAPSHOT"},"0b6ac8ef-c749-4ffa-97dd-17d05a35cde7":{"class_fqid":"com-snaplogic-snaps-oracle-lookup_1-SNAPSHOT","class_id":"com-snaplogic-snaps-oracle-lookup","class_version":1,"instance_fqid":"0b6ac8ef-c749-4ffa-97dd-17d05a35cde7_7","instance_id":"0b6ac8ef-c749-4ffa-97dd-17d05a35cde7","instance_version":7,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Oracle - Lookup"}},"view_serial":100,"account":{"account_ref":{"value":{"ref_id":{"value":"660ddc81-203f-46c4-b2e1-3db7c4d29319"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-oraclethindatabaseaccount"},"label":{"value":"oracle_account2-1e60fbf047b713afd440c45da1012a81"}}}},"settings":{"outputFields":{"value":[{"outputField":{"expression":false,"value":"NAME"}}]},"lookupConditions":{"value":[{"column":{"expression":false,"value":"SCORE"},"value":{"expression":true,"value":"$SCORE"}}]},"schemaName":{"expression":false,"value":"TECTONIC"},"tableName":{"expression":false,"value":"STUDENT"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"},"data_uris":null,"header_uris":null,"snap_schema_fqid":{"instance_id":"e85f2420-f6dd-4ba6-a0ca-c4d14faacc85","output_view_id":"outputRows"}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"continue"}},"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"},"data_uris":null,"header_uris":null,"schema":{"properties":{"SCORE":{"type":"number"},"ID":{"type":"number"},"NAME":{"type":"string","maxLength":20}}}}}},"class_build_tag":"SNAPSHOT"},"d4b6d164-f8e7-49d9-9162-167c614bea80":{"class_fqid":"com-snaplogic-snaps-binary-write_3-SNAPSHOT","class_id":"com-snaplogic-snaps-binary-write","class_version":3,"instance_fqid":"d4b6d164-f8e7-49d9-9162-167c614bea80_2","instance_id":"d4b6d164-f8e7-49d9-9162-167c614bea80","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"File Writer"}},"view_serial":100,"account":{"account_ref":{"value":{"label":{"value":null},"ref_class_id":{"value":"com-snaplogic-snaps-binary-binarysmbaccount"},"ref_id":{"value":null}}}},"settings":{"executable_during_suggest":{"value":true},"writeHeader":{"value":false},"fileAction":{"value":"OVERWRITE"},"UserPermissionsKey":{"value":[]},"filename":{"expression":false,"value":"out_lookup_example.json"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"},"data_uris":null,"header_uris":null},"error_behavior":{"value":"fail"}},"input":{"input0":{"view_type":{"value":"binary"},"label":{"value":"input0"}}}},"class_build_tag":"SNAPSHOT"}},"path_id":"/snaplogic/projects/alpha","path_snode":"53ab67528ecac41e2b244c44"}