{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"636ac9ebb7f9a6e3a94407de","instance_id":"fedd401c-22db-45cc-943d-1c150b58db1c","instance_version":11,"link_map":{"link102":{"src_view_id":"output101","dst_view_id":"in","src_id":"6e5039f1-519b-4726-a131-de9bd82b8bd8","dst_id":"be071eb2-9cd7-4672-a44a-fdc013d47b27","isGoto":false},"link103":{"src_view_id":"out","dst_view_id":"input0","src_id":"be071eb2-9cd7-4672-a44a-fdc013d47b27","dst_id":"bd20da36-7de3-4550-906a-957113554033","isGoto":false},"link100":{"src_view_id":"output0","dst_view_id":"input0","src_id":"0d10aa3f-0392-4893-9103-ea5f1a15bc74","dst_id":"bd6d6fc6-b314-4000-be12-9217ac2a8d45","isGoto":false},"link101":{"src_view_id":"output0","dst_view_id":"input0","src_id":"bd6d6fc6-b314-4000-be12-9217ac2a8d45","dst_id":"6e5039f1-519b-4726-a131-de9bd82b8bd8","isGoto":false}},"link_serial":104,"property_map":{"info":{"notes":{"value":"This example Pipeline demonstrates how to use the Amazon S3 Select Snap to select a subset of data from a JSON file."},"author":{"value":"chall@snaplogic.com"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"label":{"value":"S3 Select Example - JSON"}},"input":{},"settings":{"imports":{"value":[]},"error_pipeline":{"expression":false,"value":null},"error_param_table":{"value":[]},"param_table":{"value":[]},"suspendable":{"value":false}},"error":{"error_behavior":{"value":"none"}},"output":{"bd20da36-7de3-4550-906a-957113554033_output0":{"label":{"value":"JSON Parser - output0"},"view_type":{"value":"document"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"6170ef57da71d373377c3751","scale_ratio":1,"detail_map":{"bd20da36-7de3-4550-906a-957113554033":{"grid_x_int":7,"input":{},"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":2,"rot_tail_int":0,"error":{},"output":{},"rot_int":0},"bd6d6fc6-b314-4000-be12-9217ac2a8d45":{"grid_x_int":4,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":2,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"0d10aa3f-0392-4893-9103-ea5f1a15bc74":{"grid_x_int":3,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":2,"rot_tail_int":0,"error":{},"input":{},"rot_int":0},"6e5039f1-519b-4726-a131-de9bd82b8bd8":{"grid_x_int":5,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":2,"rot_tail_int":0,"rot_int":0},"be071eb2-9cd7-4672-a44a-fdc013d47b27":{"grid_x_int":6,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":2,"rot_tail_int":0,"rot_int":0}},"pan_y_num":0},"snap_map":{"bd20da36-7de3-4550-906a-957113554033":{"class_fqid":"com-snaplogic-snaps-transform-jsonparser_1-main18944","class_id":"com-snaplogic-snaps-transform-jsonparser","class_version":1,"instance_fqid":"bd20da36-7de3-4550-906a-957113554033_1","instance_id":"bd20da36-7de3-4550-906a-957113554033","instance_version":1,"property_map":{"info":{"notes":{},"label":{"value":"JSON Parser"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"binary"},"label":{"value":"input0"}}},"settings":{"execution_mode":{"value":"Validate & Execute"},"allowNonStandardJson":{"value":true},"jsonFilterPath":{"value":null},"jsonLines":{"value":true},"arrayElementsAsDocuments":{"value":true},"supportTypeExts":{"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":"main18944"},"bd6d6fc6-b314-4000-be12-9217ac2a8d45":{"class_fqid":"com-snaplogic-snaps-transform-jsonformatter_2-main18944","class_id":"com-snaplogic-snaps-transform-jsonformatter","class_version":2,"instance_fqid":"bd6d6fc6-b314-4000-be12-9217ac2a8d45_1","instance_id":"bd6d6fc6-b314-4000-be12-9217ac2a8d45","instance_version":1,"property_map":{"info":{"notes":{},"label":{"value":"JSON Formatter"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"deriveSchemaLimit":{"value":"None"},"execution_mode":{"value":"Validate & Execute"},"prettyPrint":{"value":false},"contentPath":{"value":"$"},"jsonLines":{"value":true},"ignoreEmptyStream":{"value":false},"header":{"value":[{"targetPath":{"value":null},"expression":{"expression":true,"value":null}}]},"supportTypeExts":{"value":false},"formatSingleDocument":{"value":false},"schema":{"expression":false,"value":null}},"error":{"error0":{"view_type":{"value":"binary"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"binary"},"label":{"value":"output0"}}}},"class_build_tag":"main18944"},"0d10aa3f-0392-4893-9103-ea5f1a15bc74":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-main18944","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"0d10aa3f-0392-4893-9103-ea5f1a15bc74_1","instance_id":"0d10aa3f-0392-4893-9103-ea5f1a15bc74","instance_version":1,"property_map":{"info":{"notes":{},"label":{"value":"JSON Generator"}},"view_serial":100,"input":{},"settings":{"arrayElementsAsDocuments":{"value":true},"execution_mode":{"value":"Validate & Execute"},"editable_content":{"value":"[\n {\n   \"Name\": \"Albert Maro\",\n   \"Location\": \"Field\",\n   \"Extension\": 4357,\n   \"Email\": \"amaro@company.com\",\n   \"Title\": \"Director,\",\n   \"Department\": \"1100\",\n   \"Dept ID\": null\n },\n {\n   \"Name\": \"Anthony Dunn\",\n   \"Location\": \"HQ\",\n   \"Extension\": 4387,\n   \"Email\": \"adunn@company.com\",\n   \"Title\": \"Social Media Director\",\n   \"Department\": \"Marketing\",\n   \"Dept ID\": 1200\n },\n {\n   \"Name\": \"Rich Harris\",\n   \"Location\": \"CO\",\n   \"Extension\": 4368,\n   \"Email\": \"rharris@company.com\",\n   \"Title\": \"Principal Developer\",\n   \"Department\": \"Engineering\",\n   \"Dept ID\": 1300\n },\n {\n   \"Name\": \"Glen Neal\",\n   \"Location\": \"HQ\",\n   \"Extension\": 4398,\n   \"Email\": \"gneal@company.com\",\n   \"Title\": \"HR Admin\",\n   \"Department\": \"Operations\",\n   \"Dept ID\": 1400\n },\n {\n   \"Name\": \"Kristine Arnold\",\n   \"Location\": \"Field\",\n   \"Extension\": 4352,\n   \"Email\": \"karnold@company.com\",\n   \"Title\": \"Field Rep\",\n   \"Department\": \"Sales\",\n   \"Dept ID\": 1100\n },\n {\n   \"Name\": \"Tim Salazaar\",\n   \"Location\": \"HQ\",\n   \"Extension\": 4367,\n   \"Email\": \"tsalazaar@company.com\",\n   \"Title\": \"Website Admin\",\n   \"Department\": \"Marketing\",\n   \"Dept ID\": 1200\n },\n {\n   \"Name\": \"Belina Joseph\",\n   \"Location\": \"CO\",\n   \"Extension\": 4311,\n   \"Email\": \"bjoseph@company.com\",\n   \"Title\": \"Developer\",\n   \"Department\": \"Engineering\",\n   \"Dept ID\": 1300\n },\n {\n   \"Name\": \"Emilio Welch\",\n   \"Location\": \"HQ\",\n   \"Extension\": 4389,\n   \"Email\": \"ewelch@company.com\",\n   \"Title\": \"Helpdesk Administrator\",\n   \"Department\": \"Operations\",\n   \"Dept ID\": 1400\n },\n {\n   \"Name\": \"Garrett Reeves\",\n   \"Location\": \"Field\",\n   \"Extension\": 4326,\n   \"Email\": \"greeves@company.com\",\n   \"Title\": \"Field Rep\",\n   \"Department\": \"Sales\",\n   \"Dept ID\": 1100\n },\n {\n   \"Name\": \"Gayle Fleming\",\n   \"Location\": \"HQ\",\n   \"Extension\": 4334,\n   \"Email\": \"gfleming@company.com\",\n   \"Title\": \"Intern\",\n   \"Department\": \"Marketing\",\n   \"Dept ID\": 1200\n },\n {\n   \"Name\": \"Elijah Burke\",\n   \"Location\": \"CO\",\n   \"Extension\": 4333,\n   \"Email\": \"eburke@company.com\",\n   \"Title\": \"Lead Developer\",\n   \"Department\": \"Engineering\",\n   \"Dept ID\": 1300\n },\n {\n   \"Name\": \"Karthik Patel\",\n   \"Location\": \"HQ\",\n   \"Extension\": 4398,\n   \"Email\": \"kpatel@company.com\",\n   \"Title\": \"Facilities\",\n   \"Department\": \"Operations\",\n   \"Dept ID\": 1400\n },\n {\n   \"Name\": \"Laxman Sharma\",\n   \"Location\": \"HQ\",\n   \"Extension\": 4309,\n   \"Email\": \"lsharma@company.com\",\n   \"Title\": \"VP, Sales\",\n   \"Department\": \"Sales\",\n   \"Dept ID\": 1100\n },\n {\n   \"Name\": \"Kamal Mullur\",\n   \"Location\": \"HQ\",\n   \"Extension\": 4390,\n   \"Email\": \"kmullur@company.com\",\n   \"Title\": \"Manager\",\n   \"Department\": \"Marketing\",\n   \"Dept ID\": 1200\n }\n]"},"supportTypeExts":{"value":false},"passThroughProp":{"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":"main18944"},"6e5039f1-519b-4726-a131-de9bd82b8bd8":{"class_fqid":"com-snaplogic-snaps-s3-s3upload_1-main18944","class_id":"com-snaplogic-snaps-s3-s3upload","class_version":1,"instance_fqid":"6e5039f1-519b-4726-a131-de9bd82b8bd8_2","instance_id":"6e5039f1-519b-4726-a131-de9bd82b8bd8","instance_version":2,"property_map":{"info":{"notes":{},"label":{"value":"S3 Upload"}},"view_serial":101,"account":{"account_ref":{"value":{"label":{"expression":false,"value":"AKIAISMKKOLYHBBNSQOA","label":"../../shared/AKIAISMKKOLYHBBNSQOA"},"ref_class_id":{"value":"com-snaplogic-snaps-s3-s3account"},"ref_id":{"expression":false,"value":"ce8aca28-4aff-4e58-af25-d27a09aa2538"}}}},"input":{"input0":{"view_type":{"value":"binary"},"label":{"value":"input0"}}},"settings":{"execution_mode":{"value":"Validate & Execute"},"userDefinedMetadata":{"value":[]},"showAdvancedProperties":{"value":false},"threadPoolSize":{"expression":false,"value":10},"bucket":{"expression":false,"value":"test"},"multipartSize":{"expression":false,"value":10},"executable_during_suggest":{"value":false},"acl":{"value":[]},"writeEmptyFile":{"value":false},"objectKey":{"expression":false,"value":"employee_list.json"},"objectTags":{"value":[]},"passThrough":{"value":false},"cannedACL":{"expression":false,"value":"None"},"maxRetries":{"expression":false,"value":3}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"main18944"},"be071eb2-9cd7-4672-a44a-fdc013d47b27":{"class_fqid":"com-snaplogic-snaps-s3-s3select_1-main18944","class_id":"com-snaplogic-snaps-s3-s3select","class_version":1,"instance_fqid":"be071eb2-9cd7-4672-a44a-fdc013d47b27_6","instance_id":"be071eb2-9cd7-4672-a44a-fdc013d47b27","instance_version":6,"property_map":{"info":{"notes":{},"label":{"value":"S3 Select"}},"view_serial":100,"account":{"account_ref":{"value":{"ref_id":{"expression":false,"value":"ce8aca28-4aff-4e58-af25-d27a09aa2538"},"ref_class_id":{"value":"com-snaplogic-snaps-s3-s3account"},"label":{"expression":false,"value":"AKIAISMKKOLYHBBNSQOA","label":"../../shared/AKIAISMKKOLYHBBNSQOA"}}}},"input":{"in":{"label":{"value":"Input view"},"view_type":{"value":"document"}}},"settings":{"execution_mode":{"value":"Validate & Execute"},"showAdvancedProperties":{"value":false},"inputDataFormat":{"value":{"compressionType":{"expression":false,"value":"NONE"},"fieldDelimiter":{"expression":false,"value":","},"recordDelimiter":{"expression":false,"value":"LF"},"dataFormat":{"expression":false,"value":"JSON"},"quoteChar":{"expression":false,"value":"\""},"quoteEscapeChar":{"expression":false,"value":"\\"},"fileHeaderInfo":{"expression":false,"value":"USE"}}},"bucket":{"expression":false,"value":"test"},"objectKey":{"expression":false,"value":"employee_list.json"},"query":{"expression":false,"value":"SELECT * FROM S3Object[*] s WHERE s.Department = 'Sales'"},"maxRetries":{"expression":false,"value":3}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"out":{"label":{"value":"Output view"},"view_type":{"value":"binary"}}}},"class_build_tag":"main18944"}},"path_id":"/QA/Documentation/S3_Example_Pipelines","path_snode":"6299bc35de89f9b36d37905b","target_runtime":"standard"}