{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"6501afbc957ff2bf763a73a9","instance_id":"dc58f14b-ec7d-47dc-b50d-bc6f7e0c640d","instance_version":56,"link_map":{"link100":{"dst_id":"4ff58c4c-8754-4b1b-bab0-ed60b787b051","dst_view_id":"input0","src_id":"c6c62aaa-1884-428b-b538-60b2398dd01c","src_view_id":"output0","isGoto":false},"link106":{"dst_id":"81e38585-7a9e-4e64-bc80-e52d90bde0a6","dst_view_id":"inputRows","src_id":"4ff58c4c-8754-4b1b-bab0-ed60b787b051","src_view_id":"output0","isGoto":false}},"link_serial":109,"property_map":{"info":{"label":{"value":"Mapper Example with 20 inputs"},"author":{"value":"sreddi@snaplogic.com"},"pipeline_doc_uri":{"value":null},"notes":{"value":null},"purpose":{"value":null}},"error":{"error_behavior":{"value":"none"}},"settings":{"suspendable":{"value":false},"error_pipeline":{"value":null,"expression":false},"error_param_table":{"value":[]},"param_table":{"value":[]},"imports":{"value":[]}},"input":{},"output":{"81e38585-7a9e-4e64-bc80-e52d90bde0a6_output101":{"label":{"value":"PostgreSQL - Insert - output0"},"view_type":{"value":"document"}}}},"render_map":{"scale_ratio":1,"pan_x_num":0,"pan_y_num":0,"default_snaplex":"650bf42320db4c2ebbc5bf0f","detail_map":{"4ff58c4c-8754-4b1b-bab0-ed60b787b051":{"grid_x_int":3,"grid_y_int":1,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0},"c6c62aaa-1884-428b-b538-60b2398dd01c":{"grid_x_int":2,"grid_y_int":1,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"input":{}},"81e38585-7a9e-4e64-bc80-e52d90bde0a6":{"grid_x_int":4,"grid_y_int":1,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0}}},"snap_map":{"4ff58c4c-8754-4b1b-bab0-ed60b787b051":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-develop22843","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"4ff58c4c-8754-4b1b-bab0-ed60b787b051_11","instance_id":"4ff58c4c-8754-4b1b-bab0-ed60b787b051","instance_version":11,"property_map":{"info":{"label":{"value":"Mapper"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"passThrough":{"value":true},"transformations":{"value":{"mappingRoot":{"value":"$"},"mappingTable":{"value":[{"expression":{"value":"$Address+$['Street Number']+$city+$country","expression":true},"targetPath":{"value":"$Address"}},{"expression":{"value":"$department","expression":true},"targetPath":{"value":null}},{"expression":{"value":"$pincode","expression":true},"targetPath":{"value":null}},{"expression":{"value":"$first_name+$last_name","expression":true},"targetPath":{"value":"$FullName"}}]}}},"nullSafeAccess":{"value":false}},"view_serial":100},"class_build_tag":"develop22843"},"c6c62aaa-1884-428b-b538-60b2398dd01c":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-develop22843","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"c6c62aaa-1884-428b-b538-60b2398dd01c_3","instance_id":"c6c62aaa-1884-428b-b538-60b2398dd01c","instance_version":3,"property_map":{"info":{"label":{"value":"JSON Generator"},"notes":{}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"editable_content":{"value":"[{\"id\":1,\"first_name\":\"Major\",\"last_name\":\"Earpe\",\"email\":\"mearpe0@omniture.com\",\"gender\":\"M\",\"city\":\"Manna\",\"country\":\"Indonesia\",\"state\":null,\"department\":\"Outdoors\",\"FullName\":\"Major Earpe\",\"Job Title\":\"Software Consultant\",\"Address\":\"Suite 30\",\"pincode\":null,\"Phone\":\"775-339-7272\",\"Street Number\":\"69051\"},\n{\"id\":2,\"first_name\":\"Audra\",\"last_name\":\"Redford\",\"email\":\"aredford1@bandcamp.com\",\"gender\":\"F\",\"city\":\"Sacramento\",\"country\":\"United States\",\"state\":\"California\",\"department\":\"Outdoors\",\"FullName\":\"Audra Redford\",\"Job Title\":\"Financial Advisor\",\"Address\":\"PO Box 71799\",\"pincode\":\"95833\",\"Phone\":\"530-600-9684\",\"Street Number\":\"463\"},\n{\"id\":3,\"first_name\":\"Betteann\",\"last_name\":\"Keach\",\"email\":\"bkeach2@sitemeter.com\",\"gender\":\"F\",\"city\":\"Bohutín\",\"country\":\"Czech Republic\",\"state\":null,\"department\":\"Health\",\"FullName\":\"Betteann Keach\",\"Job Title\":\"Internal Auditor\",\"Address\":\"Apt 534\",\"pincode\":\"789 62\",\"Phone\":\"867-608-6520\",\"Street Number\":\"11\"},\n{\"id\":4,\"first_name\":\"Thomasina\",\"last_name\":\"Kitchiner\",\"email\":\"tkitchiner3@tinypic.com\",\"gender\":\"F\",\"city\":\"Mapulo\",\"country\":\"Philippines\",\"state\":null,\"department\":\"Home\",\"FullName\":\"Thomasina Kitchiner\",\"Job Title\":\"Biostatistician IV\",\"Address\":\"PO Box 35347\",\"pincode\":\"9201\",\"Phone\":\"332-239-8374\",\"Street Number\":\"721\"},\n{\"id\":5,\"first_name\":\"Roland\",\"last_name\":\"Timbs\",\"email\":\"rtimbs4@adobe.com\",\"gender\":\"M\",\"city\":\"Muarabadak\",\"country\":\"Indonesia\",\"state\":null,\"department\":\"Beauty\",\"FullName\":\"Roland Timbs\",\"Job Title\":\"Systems Administrator IV\",\"Address\":\"Suite 91\",\"pincode\":null,\"Phone\":\"537-857-5070\",\"Street Number\":\"0\"},\n{\"id\":6,\"first_name\":\"Elsworth\",\"last_name\":\"Deshorts\",\"email\":\"edeshorts5@simplemachines.org\",\"gender\":\"M\",\"city\":\"Rzhavki\",\"country\":\"Russia\",\"state\":null,\"department\":\"Music\",\"FullName\":\"Elsworth Deshorts\",\"Job Title\":\"Product Engineer\",\"Address\":\"Room 349\",\"pincode\":\"141580\",\"Phone\":\"757-391-9252\",\"Street Number\":\"97721\"},\n{\"id\":7,\"first_name\":\"Rachelle\",\"last_name\":\"Fraser\",\"email\":\"rfraser6@acquirethisname.com\",\"gender\":\"F\",\"city\":\"Oehaunu\",\"country\":\"Indonesia\",\"state\":null,\"department\":\"Garden\",\"FullName\":\"Rachelle Fraser\",\"Job Title\":\"Physical Therapy Assistant\",\"Address\":\"Apt 1901\",\"pincode\":null,\"Phone\":\"458-168-7474\",\"Street Number\":\"1711\"},\n{\"id\":8,\"first_name\":\"Palm\",\"last_name\":\"Drinkwater\",\"email\":\"pdrinkwater7@archive.org\",\"gender\":\"M\",\"city\":\"Fazenda de Santa Cruz\",\"country\":\"Portugal\",\"state\":\"Ilha das Flores\",\"department\":\"Games\",\"FullName\":\"Palm Drinkwater\",\"Job Title\":\"Internal Auditor\",\"Address\":\"Suite 45\",\"pincode\":\"9970-244\",\"Phone\":\"943-202-5496\",\"Street Number\":\"18532\"},\n{\"id\":9,\"first_name\":\"Katerine\",\"last_name\":\"Stott\",\"email\":\"kstott8@joomla.org\",\"gender\":\"F\",\"city\":\"Qingshan\",\"country\":\"China\",\"state\":null,\"department\":\"Books\",\"FullName\":\"Katerine Stott\",\"Job Title\":\"Analog Circuit Design manager\",\"Address\":\"PO Box 12959\",\"pincode\":null,\"Phone\":\"219-201-1237\",\"Street Number\":\"57\"},\n{\"id\":10,\"first_name\":\"Collette\",\"last_name\":\"Humm\",\"email\":\"chumm9@shop-pro.jp\",\"gender\":\"F\",\"city\":\"Port Saint Lucie\",\"country\":\"United States\",\"state\":\"Florida\",\"department\":\"Tools\",\"FullName\":\"Collette Humm\",\"Job Title\":\"Software Consultant\",\"Address\":\"Room 687\",\"pincode\":\"34985\",\"Phone\":\"772-474-2676\",\"Street Number\":\"1664\"}]"},"arrayElementsAsDocuments":{"value":true},"passThroughProp":{"value":false},"supportTypeExts":{"value":false}},"view_serial":100,"input":{}},"class_build_tag":"develop22843"},"81e38585-7a9e-4e64-bc80-e52d90bde0a6":{"class_fqid":"com-snaplogic-snaps-postgres-insert_1-develop22978","class_id":"com-snaplogic-snaps-postgres-insert","class_version":1,"instance_fqid":"81e38585-7a9e-4e64-bc80-e52d90bde0a6_9","instance_id":"81e38585-7a9e-4e64-bc80-e52d90bde0a6","instance_version":9,"property_map":{"info":{"label":{"value":"PostgreSQL - Insert"},"notes":{}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"executable_during_suggest":{"value":false},"createTable":{"value":true},"preserveCaseSensistiveness":{"value":false},"maxRetryProp":{"value":0,"expression":false},"retryIntervalProp":{"value":1,"expression":false},"schemaName":{"value":"\"snapteam1\"","expression":false},"tableName":{"value":"new_integration1","expression":false}},"account":{"account_ref":{"value":{"label":{"value":"Postgres","label":"Postgres","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-postgresdatabaseaccount"},"ref_id":{"value":"3092c094-4abb-46ef-a164-035f749290a2","expression":false}}}},"view_serial":101,"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"develop22978"}},"path_id":"/QA/shared_assets/core","path_snode":"642b235871d225971e30036d","target_runtime":"standard"}