{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"59775f3e95526e6408f15626","instance_id":"7ba55f0b-76a9-42e1-9bff-211730e726b3","instance_version":3,"link_map":{"link112":{"src_view_id":"outputRows","dst_view_id":"input102","src_id":"a5c41b6c-8c42-4e84-978b-e460658e347d","dst_id":"aef8d988-1c9c-4372-b382-8beebf214bec","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-insert data from sql server"}},"input":{},"settings":{"param_table":{"value":[]},"imports":{"value":[]}},"error":{"error_behavior":{"value":"none"}},"output":{"aa288568-4078-4227-8977-69448bfa62f0_output101":{"view_type":{"value":"document"},"label":{"value":"Azure SQL - Execute - output0"}},"aef8d988-1c9c-4372-b382-8beebf214bec_output101":{"label":{"value":"Azure SQL - Execute - output0"},"view_type":{"value":"document"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"55772b8495526e3fc62ac7ea","scale_ratio":1,"detail_map":{"aef8d988-1c9c-4372-b382-8beebf214bec":{"grid_x_int":3,"error":{},"grid_y_int":1,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"a5c41b6c-8c42-4e84-978b-e460658e347d":{"grid_x_int":2,"error":{},"grid_y_int":1,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"aa288568-4078-4227-8977-69448bfa62f0":{"grid_x_int":2,"error":{},"grid_y_int":2,"rot_tail_int":0,"input":{},"output":{},"rot_int":0}},"pan_y_num":0},"snap_map":{"aef8d988-1c9c-4372-b382-8beebf214bec":{"class_fqid":"com-snaplogic-snaps-azuresql-execute_1-azuresql3050","class_id":"com-snaplogic-snaps-azuresql-execute","class_version":1,"instance_fqid":"aef8d988-1c9c-4372-b382-8beebf214bec_2","instance_id":"aef8d988-1c9c-4372-b382-8beebf214bec","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL - Execute"}},"view_serial":102,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"46cb5a63-66bb-4cd2-9e70-c63708abd863"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqldatabaseaccount"},"label":{"expression":false,"value":"AzureSQL_Diag"}}}},"input":{"input102":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"autoCommit":{"value":"Use account setting"},"passThrough":{"value":true},"executable_during_suggest":{"value":true},"sqlStatement":{"expression":true,"value":"\"INSERT INTO SnapLogicDB1.SampleDB.sqltoemployees\n\t(title, employee_id)\nVALUES \n\t('$title',$employee_id )\""},"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"},"a5c41b6c-8c42-4e84-978b-e460658e347d":{"class_fqid":"com-snaplogic-snaps-sqlserver-select_3-c405","class_id":"com-snaplogic-snaps-sqlserver-select","class_version":3,"instance_fqid":"a5c41b6c-8c42-4e84-978b-e460658e347d_1","instance_id":"a5c41b6c-8c42-4e84-978b-e460658e347d","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"SQL Server - Select"}},"view_serial":100,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"d15d6c96-5225-4c3a-bf76-48f363a0215a"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-sqlserverdatabaseaccount"},"label":{"expression":false,"value":"sql server prasanna schema - not for diagnostics"}}}},"settings":{"orderBy":{"value":[]},"limitRows":{"expression":false,"value":null},"passThrough":{"value":true},"tableName":{"expression":false,"value":"\"dbo\".\"avemployees\""},"ignoreEmptyResult":{"value":false},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":null},"schemaName":{"expression":false,"value":"\"dbo\""},"limitOffset":{"expression":false,"value":null}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"outputRows":{"label":{"value":"rows"},"view_type":{"value":"document"}}}},"class_build_tag":"c405"},"aa288568-4078-4227-8977-69448bfa62f0":{"class_fqid":"com-snaplogic-snaps-azuresql-execute_1-azuresql3050","class_id":"com-snaplogic-snaps-azuresql-execute","class_version":1,"instance_fqid":"aa288568-4078-4227-8977-69448bfa62f0_2","instance_id":"aa288568-4078-4227-8977-69448bfa62f0","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL - Execute"}},"view_serial":102,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"46cb5a63-66bb-4cd2-9e70-c63708abd863"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqldatabaseaccount"},"label":{"expression":false,"value":"AzureSQL_Diag"}}}},"settings":{"autoCommit":{"value":"Use account setting"},"passThrough":{"value":true},"executable_during_suggest":{"value":true},"sqlStatement":{"expression":false,"value":"TRUNCATE TABLE SnapLogicDB1.SampleDB.sqltoemployees"},"advancedSnapProperties":{"value":[]},"ignoreEmptyResult":{"value":false}},"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{}},"class_build_tag":"azuresql3050"}},"path_id":"/QA/projects/Aparna Tayi","path_snode":"57dfe69295526e323448ebe3"}