{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"5e68a9ad382865225458fce8","instance_id":"5ea903b9-7be4-474f-8208-b00ab850a7cd","instance_version":8,"link_map":{"link111":{"src_view_id":"output0","dst_view_id":"input0","src_id":"59decb98-3493-4bba-9384-ed257c73d7b0","dst_id":"6cbe1a48-a9f0-4b2e-87d3-b03bbd6a0f72","isGoto":false},"link107":{"src_view_id":"output0","dst_view_id":"input0","src_id":"0e2c4030-dbb2-4bb2-a05d-c5f7902bafd6","dst_id":"6a6e7912-db75-4e67-af20-ea60f9bed44b","isGoto":false},"link108":{"src_view_id":"output0","dst_view_id":"input0","src_id":"6a6e7912-db75-4e67-af20-ea60f9bed44b","dst_id":"6e4eaf51-22a0-4a32-9ac6-3b5894761806","isGoto":false},"link110":{"src_view_id":"output101","dst_view_id":"input101","src_id":"6e4eaf51-22a0-4a32-9ac6-3b5894761806","dst_id":"59decb98-3493-4bba-9384-ed257c73d7b0","isGoto":false}},"link_serial":112,"property_map":{"info":{"notes":{"value":null},"label":{"value":"ExcelFormatterMultipleSheets"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"rsachdeva@snaplogic.com"}},"input":{},"settings":{"imports":{"value":[]},"error_param_table":{"value":[]},"param_table":{"value":[]},"error_pipeline":{"expression":false,"value":null}},"error":{"error_behavior":{"value":"none"}},"output":{"6cbe1a48-a9f0-4b2e-87d3-b03bbd6a0f72_output0":{"label":{"value":"Excel Parser - output0"},"view_type":{"value":"document"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"5b4e3c83a3a8dd3e034aecff","scale_ratio":1,"detail_map":{"6a6e7912-db75-4e67-af20-ea60f9bed44b":{"grid_x_int":4,"input":{},"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"output":{},"rot_int":0},"0e2c4030-dbb2-4bb2-a05d-c5f7902bafd6":{"grid_x_int":3,"input":{},"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"output":{},"rot_int":0},"6cbe1a48-a9f0-4b2e-87d3-b03bbd6a0f72":{"grid_x_int":7,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"output":{},"input":{},"rot_int":0},"59decb98-3493-4bba-9384-ed257c73d7b0":{"grid_x_int":6,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"rot_int":0,"view":"output"},"6e4eaf51-22a0-4a32-9ac6-3b5894761806":{"grid_x_int":5,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"rot_int":0}},"pan_y_num":0},"snap_map":{"6a6e7912-db75-4e67-af20-ea60f9bed44b":{"class_fqid":"com-snaplogic-snaps-transform-excelformatter_3-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-excelformatter","class_version":3,"instance_fqid":"6a6e7912-db75-4e67-af20-ea60f9bed44b_1","instance_id":"6a6e7912-db75-4e67-af20-ea60f9bed44b","instance_version":1,"property_map":{"info":{"label":{"value":"Excel Formatter"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"execution_mode":{"value":"Validate & Execute"},"ignoreEmptyStream":{"value":false},"writeHeaderProp":{"value":true},"includeAllColumns":{"value":false},"translateDateTimeTypes":{"value":false},"convertNumericString":{"value":true},"sheetNameProp":{"expression":true,"value":"$country"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"binary"},"label":{"value":"output0"}}}},"class_build_tag":"SNAPSHOT"},"0e2c4030-dbb2-4bb2-a05d-c5f7902bafd6":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"0e2c4030-dbb2-4bb2-a05d-c5f7902bafd6_1","instance_id":"0e2c4030-dbb2-4bb2-a05d-c5f7902bafd6","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"JSON Generator"}},"view_serial":100,"settings":{"execution_mode":{"value":"Validate & Execute"},"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    \"id\": 1,\n    \"first_name\": \"Pierre\",\n    \"last_name\": \"Geard\",\n    \"email\": \"pgeard0@npr.org\",\n    \"phone\": \"(917) 4669071\",\n    \"country\": \"Canada\"\n  },\n  {\n    \"id\": 2,\n    \"first_name\": \"Harry\",\n    \"last_name\": \"Curmi\",\n    \"email\": \"hcurmi1@ask.com\",\n    \"phone\": \"(221) 2191900\",\n    \"country\": \"United States\"\n  },\n  {\n    \"id\": 3,\n    \"first_name\": \"Roarke\",\n    \"last_name\": \"Lawrie\",\n    \"email\": \"rlawrie2@loc.gov\",\n    \"phone\": \"(763) 3090071\",\n    \"country\": \"Canada\"\n  },\n  {\n    \"id\": 4,\n    \"first_name\": \"Kevin\",\n    \"last_name\": \"Hartles\",\n    \"email\": \"khartles3@imgur.com\",\n    \"phone\": \"(364) 2485233\",\n    \"country\": \"United States\"\n  },\n  {\n    \"id\": 5,\n    \"first_name\": \"William\",\n    \"last_name\": \"Hearnshaw\",\n    \"email\": \"whearnshaw4@rakuten.co.jp\",\n    \"phone\": \"(742) 8085635\",\n    \"country\": \"Canada\"\n  },\n  {\n    \"id\": 6,\n    \"first_name\": \"Brock\",\n    \"last_name\": \"Lyttle\",\n    \"email\": \"blyttle5@ed.gov\",\n    \"phone\": \"(663) 6018986\",\n    \"country\": \"Canada\"\n  },\n  {\n    \"id\": 7,\n    \"first_name\": \"Ray\",\n    \"last_name\": \"Anmore\",\n    \"email\": \"ranmore6@washingtonpost.com\",\n    \"phone\": \"(419) 8076402\",\n    \"country\": \"United States\"\n  },\n  {\n    \"id\": 8,\n    \"first_name\": \"Michelle\",\n    \"last_name\": \"Terbeek\",\n    \"email\": \"mterbeek7@espn.com\",\n    \"phone\": \"(316) 4970401\",\n    \"country\": \"Canada\"\n  },\n  {\n    \"id\": 9,\n    \"first_name\": \"Rosabella\",\n    \"last_name\": \"Twinbourne\",\n    \"email\": \"rtwinbourne8@microsoft.com\",\n    \"phone\": \"(772) 1778566\",\n    \"country\": \"United States\"\n  },\n  {\n    \"id\": 10,\n    \"first_name\": \"Dru\",\n    \"last_name\": \"Gopsell\",\n    \"email\": \"dgopsell9@illinois.edu\",\n    \"phone\": \"(733) 9686006\",\n    \"country\": \"Canada\"\n  },\n  {\n    \"id\": 11,\n    \"first_name\": \"Odella\",\n    \"last_name\": \"Loft\",\n    \"email\": \"olofta@mozilla.com\",\n    \"phone\": \"(623) 1909432\",\n    \"country\": \"United States\"\n  },\n  {\n    \"id\": 12,\n    \"first_name\": \"Sabrina\",\n    \"last_name\": \"Dionisii\",\n    \"email\": \"sdionisiib@apple.com\",\n    \"phone\": \"(702) 9049274\",\n    \"country\": \"United States\"\n  },\n  {\n    \"id\": 13,\n    \"first_name\": \"Wendell\",\n    \"last_name\": \"McAneny\",\n    \"email\": \"wmcanenyc@linkedin.com\",\n    \"phone\": \"(410) 3943039\",\n    \"country\": \"United States\"\n  },\n  {\n    \"id\": 14,\n    \"first_name\": \"Gary\",\n    \"last_name\": \"Farrah\",\n    \"email\": \"gfarrahd@ubc.ca\",\n    \"phone\": \"(813) 2911172\",\n    \"country\": \"Canada\"\n  },\n  {\n    \"id\": 15,\n    \"first_name\": \"Allie\",\n    \"last_name\": \"Weare\",\n    \"email\": \"awearee@prnewswire.com\",\n    \"phone\": \"(913) 8922631\",\n    \"country\": \"United States\"\n  },\n  {\n    \"id\": 16,\n    \"first_name\": \"Deborah\",\n    \"last_name\": \"Linder\",\n    \"email\": \"dlinderf@canalplus.com\",\n    \"phone\": \"(360) 6988969\",\n    \"country\": \"Canada\"\n  },\n  {\n    \"id\": 17,\n    \"first_name\": \"Cori\",\n    \"last_name\": \"O' Loughran\",\n    \"email\": \"coloughrang@craigslist.org\",\n    \"phone\": \"(202) 1746838\",\n    \"country\": \"United States\"\n  },\n  {\n    \"id\": 18,\n    \"first_name\": \"Murielle\",\n    \"last_name\": \"Baine\",\n    \"email\": \"mbaineh@bmo.com\",\n    \"phone\": \"(969) 7830168\",\n    \"country\": \"Canada\"\n  },\n  {\n    \"id\": 19,\n    \"first_name\": \"Katy\",\n    \"last_name\": \"Ellacombe\",\n    \"email\": \"kellacombei@twitter.com\",\n    \"phone\": \"(214) 3986416\",\n    \"country\": \"United States\"\n  },\n  {\n    \"id\": 20,\n    \"first_name\": \"Irma\",\n    \"last_name\": \"Ranshaw\",\n    \"email\": \"iranshawj@blogspot.com\",\n    \"phone\": \"(814) 5314273\",\n    \"country\": \"United States\"\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}},"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":"SNAPSHOT"},"6cbe1a48-a9f0-4b2e-87d3-b03bbd6a0f72":{"class_fqid":"com-snaplogic-snaps-transform-excelparser_4-5059","class_id":"com-snaplogic-snaps-transform-excelparser","class_version":4,"instance_fqid":"6cbe1a48-a9f0-4b2e-87d3-b03bbd6a0f72_1","instance_id":"6cbe1a48-a9f0-4b2e-87d3-b03bbd6a0f72","instance_version":1,"property_map":{"info":{"label":{"value":"Excel Parser"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"binary"},"label":{"value":"input0"}}},"settings":{"execution_mode":{"value":"Validate & Execute"},"lastBlankHeaders":{"value":0},"headerRowProp":{"value":1},"containsHeaderProp":{"value":false},"cellFormatting":{"value":"Formatted"},"roundDateToSeconds":{"value":false},"sheetIndexOrNameProp":{"value":"0"},"nullEmptyColumns":{"value":false}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"5059"},"59decb98-3493-4bba-9384-ed257c73d7b0":{"class_fqid":"com-snaplogic-snaps-binary-simpleread_1-5059","class_id":"com-snaplogic-snaps-binary-simpleread","class_version":1,"instance_fqid":"59decb98-3493-4bba-9384-ed257c73d7b0_4","instance_id":"59decb98-3493-4bba-9384-ed257c73d7b0","instance_version":4,"property_map":{"info":{"notes":{"value":null},"label":{"value":"File Reader"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{}}},"input":{"input101":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"retryInterval":{"expression":false,"value":1},"retries":{"expression":false,"value":0},"execution_mode":{"value":"Validate & Execute"},"filePath":{"expression":false,"value":"country.xlsx"},"enableStaging":{"value":false},"executeDuringPreview":{"value":true},"advancedProperties":{"value":[]},"preventURLEncoding":{"value":false}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"binary"}}}},"class_build_tag":"5059"},"6e4eaf51-22a0-4a32-9ac6-3b5894761806":{"class_fqid":"com-snaplogic-snaps-binary-write_3-SNAPSHOT","class_id":"com-snaplogic-snaps-binary-write","class_version":3,"instance_fqid":"6e4eaf51-22a0-4a32-9ac6-3b5894761806_3","instance_id":"6e4eaf51-22a0-4a32-9ac6-3b5894761806","instance_version":3,"property_map":{"info":{"notes":{"value":null},"label":{"value":"File Writer"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{}}},"settings":{"retryInterval":{"expression":false,"value":1},"retries":{"expression":false,"value":0},"execution_mode":{"value":"Validate & Execute"},"flushIntervalKb":{"value":-1},"writeHeader":{"value":false},"createDir":{"value":false},"executable_during_suggest":{"value":false},"filename":{"expression":false,"value":"country.xlsx"},"writeEmptyFile":{"value":false},"UserPermissionsKey":{"value":[]},"advancedProperties":{"value":[]},"validate":{"value":false},"fileAction":{"value":"OVERWRITE"}},"output":{"output101":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"binary"}}}},"class_build_tag":"SNAPSHOT"}},"path_id":"/QA/Documentation/Diagnostics","path_snode":"5e4b79ad8bb3fe001c4681a0","target_runtime":"standard"}