{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"5975b1d495526e6408f126e4","instance_id":"41cfee32-ecdb-4563-8bd6-fcbe1972ac4a","instance_version":17,"link_map":{"link112":{"src_view_id":"output101","dst_view_id":"input0","src_id":"fcd26709-c155-40ba-af6e-6107f51c1059","dst_id":"42900e1c-755f-45c4-aa70-40bdbb5e563e","isGoto":false},"link116":{"src_view_id":"output0","dst_view_id":"input102","src_id":"40a324b3-feea-4665-9de2-728179641e98","dst_id":"ae96ef47-dd01-4be6-a7f6-89ce0ecf0280","isGoto":false}},"link_serial":117,"property_map":{"info":{"notes":{"value":null},"author":{"value":"atayi@snaplogic.com"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"label":{"value":"Azure SQL Execute-Basic Test-Pipeline params"}},"input":{},"settings":{"param_table":{"value":[{"capture":{"value":false},"value":{"value":"Persons"},"key":{"value":"table"}}]},"imports":{"value":[]}},"error":{"error_behavior":{"value":"none"}},"output":{"ae96ef47-dd01-4be6-a7f6-89ce0ecf0280_output101":{"label":{"value":"Azure SQL - Execute - output0"},"view_type":{"value":"document"}},"42900e1c-755f-45c4-aa70-40bdbb5e563e_output0":{"view_type":{"value":"document"},"label":{"value":"Mapper1 - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"55772b8495526e3fc62ac7ea","scale_ratio":1,"detail_map":{"fcd26709-c155-40ba-af6e-6107f51c1059":{"grid_x_int":5,"rot_int":0,"grid_y_int":3,"rot_tail_int":0},"ae96ef47-dd01-4be6-a7f6-89ce0ecf0280":{"grid_x_int":4,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"40a324b3-feea-4665-9de2-728179641e98":{"grid_x_int":3,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"42900e1c-755f-45c4-aa70-40bdbb5e563e":{"grid_x_int":6,"error":{},"grid_y_int":3,"rot_tail_int":0,"input":{},"output":{},"rot_int":0}},"pan_y_num":0},"snap_map":{"fcd26709-c155-40ba-af6e-6107f51c1059":{"class_fqid":"com-snaplogic-snaps-azuresql-execute_1-azuresql3050","class_id":"com-snaplogic-snaps-azuresql-execute","class_version":1,"instance_fqid":"fcd26709-c155-40ba-af6e-6107f51c1059_3","instance_id":"fcd26709-c155-40ba-af6e-6107f51c1059","instance_version":3,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL - Execute Pipeline"}},"view_serial":102,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"AzureSQL_Diag"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqldatabaseaccount"},"ref_id":{"expression":false,"value":"46cb5a63-66bb-4cd2-9e70-c63708abd863"}}}},"settings":{"autoCommit":{"value":"Use account setting"},"passThrough":{"value":true},"executable_during_suggest":{"value":true},"sqlStatement":{"expression":true,"value":"\"select * from \"+_table"},"advancedSnapProperties":{"value":[]},"ignoreEmptyResult":{"value":false}},"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":"azuresql3050"},"ae96ef47-dd01-4be6-a7f6-89ce0ecf0280":{"class_fqid":"com-snaplogic-snaps-azuresql-execute_1-azuresql3050","class_id":"com-snaplogic-snaps-azuresql-execute","class_version":1,"instance_fqid":"ae96ef47-dd01-4be6-a7f6-89ce0ecf0280_7","instance_id":"ae96ef47-dd01-4be6-a7f6-89ce0ecf0280","instance_version":7,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL - Execute"}},"view_serial":102,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"AzureSQL_Diag"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqldatabaseaccount"},"ref_id":{"expression":false,"value":"46cb5a63-66bb-4cd2-9e70-c63708abd863"}}}},"settings":{"autoCommit":{"value":"Use account setting"},"passThrough":{"value":true},"ignoreEmptyResult":{"value":false},"executable_during_suggest":{"value":true},"sqlStatement":{"expression":true,"value":"\"INSERT INTO Persons (ID,FirstName,LastName,Age) VALUES (100,'\"+$FirstName+\"','\"+$LastName+\"',30)\""}},"output":{"output101":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"input":{"input102":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"azuresql3050"},"40a324b3-feea-4665-9de2-728179641e98":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-ALL3303","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"40a324b3-feea-4665-9de2-728179641e98_1","instance_id":"40a324b3-feea-4665-9de2-728179641e98","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"JSON Generator"}},"view_serial":100,"settings":{"editable_content":{"value":"[{\"ID\":999,\"LastName\":\"manzoor\",\"FirstName\":\"patan\",\"Age\":29},{\"ID\":9999,\"LastName\":\"manzoor\",\"FirstName\":\"patan\",\"Age\":19}]"},"arrayElementsAsDocuments":{"value":true}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}}},"class_build_tag":"ALL3303"},"42900e1c-755f-45c4-aa70-40bdbb5e563e":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsrc806","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"42900e1c-755f-45c4-aa70-40bdbb5e563e_1","instance_id":"42900e1c-755f-45c4-aa70-40bdbb5e563e","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper1"}},"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":"$FirstName"},"expression":{"expression":true,"value":"$FirstName"}},{"targetPath":{"value":"$ID"},"expression":{"expression":true,"value":"$ID"}},{"targetPath":{"value":"$LastName"},"expression":{"expression":true,"value":"$LastName"}}]},"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":"snapsrc806"}},"path_id":"/QA/projects/Aparna Tayi","path_snode":"57dfe69295526e323448ebe3"}