{"_dirty_type":"upd","class_fqid":"com-snaplogic-pipeline_8","snode_id":"597f18c495526e094b073dfa","instance_id":"1e14eb2d-f809-4c02-a35d-c7b7deb7292a","instance_version":2,"link_map":{"link104":{"src_view_id":"output0","dst_view_id":"input101","src_id":"8fcde1d3-7f34-4b1c-9b27-7c87befbb744","dst_id":"205af88c-3942-45e7-8534-99b9fc0c51b7","isGoto":false}},"link_serial":108,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL Stored Procedure Select - Portal"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"atayi@snaplogic.com"}},"input":{},"settings":{"param_table":{"value":[]},"imports":{"value":[]}},"error":{"error_behavior":{"value":"none"}},"output":{}},"render_map":{"pan_x_num":0,"default_snaplex":"55772b8495526e3fc62ac7ea","scale_ratio":1,"detail_map":{"8fcde1d3-7f34-4b1c-9b27-7c87befbb744":{"grid_x_int":1,"error":{},"grid_y_int":1,"rot_tail_int":0,"input":{},"output":{},"rot_int":0},"205af88c-3942-45e7-8534-99b9fc0c51b7":{"grid_x_int":2,"error":{},"grid_y_int":1,"rot_tail_int":0,"input":{},"output":{"output1":{"dx_int":0,"rot_int":0,"dy_int":1}},"rot_int":0}},"pan_y_num":0},"snap_map":{"8fcde1d3-7f34-4b1c-9b27-7c87befbb744":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-ALL2765","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"8fcde1d3-7f34-4b1c-9b27-7c87befbb744_1","instance_id":"8fcde1d3-7f34-4b1c-9b27-7c87befbb744","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"JSON Generator"}},"view_serial":101,"input":{},"settings":{"editable_content":{"value":"## Enter your JSON-encoded data in this space. Note that this text is\n## treated as an Apache Velocity template, so you can substitute values\n## from input documents or the pipeline parameters. See the following\n## URL for more information about Velocity:\n## https://velocity.apache.org/engine/devel/user-guide.html\n\n[\n {\n \"Emp_ID\" : 101\n }\n]\n\n\n## Tips:\n## * The sample data above will generate a single empty document, uncomment\n## the line in the middle to include the sample fields. Adding more\n## objects to the root array will cause the snap to generate more\n## than one document.\n## * Pipeline parameters can be referenced by prefixing the parameter\n## name with an underscore, like so:\n## ${_pipelineParamName}\n## * If you add an input view to the snap, this template will be\n## evaluated for each input document.\n## * Fields in the input documents can be referenced by prefixing them\n## with a dollar-sign ($), like so:\n## $parent.child[0].value\n## * Any referenced document values and pipeline parameters will\n## automatically be JSON-encoded when they are inserted into the final\n## JSON document. You should not have to worry about escaping values\n## yourself.\n## * If you are having troubles getting a template to produce valid JSON,\n## you can add an error view to the snap to get a document that\n## contains the output of the template evaluation."},"arrayElementsAsDocuments":{"value":true}},"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":"ALL2765"},"205af88c-3942-45e7-8534-99b9fc0c51b7":{"class_fqid":"com-snaplogic-snaps-azuresql-storedprocedure_1-ALL3110","class_id":"com-snaplogic-snaps-azuresql-storedprocedure","class_version":1,"instance_fqid":"205af88c-3942-45e7-8534-99b9fc0c51b7_2","instance_id":"205af88c-3942-45e7-8534-99b9fc0c51b7","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Azure SQL - Stored Procedure"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"Azure Sql Active Directory"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-azuresqlactivedirectoryaccount"},"ref_id":{"expression":false,"value":"cd313058-1ebf-4bfe-bb0a-5972cd01661c"}}}},"input":{"input101":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"parameterValues":{"value":[{"parameterValue":{"expression":true,"value":"$Emp_ID"}}]},"passThrough":{"value":true},"schemaName":{"expression":false,"value":null},"storedProcedureName":{"expression":false,"value":"Emp_Select_2"},"executable_during_suggest":{"value":true}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"Output Parameter OutputView"},"view_type":{"value":"document"}},"output1":{"label":{"value":"Result Set Output View"},"view_type":{"value":"document"}}}},"class_build_tag":"ALL3110"}},"path_id":"/QA/projects/Aparna Tayi","path_snode":"57dfe69295526e323448ebe3"}