{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"60d2d4569dcb34a5732bf541","instance_id":"74832aa8-8496-4279-b7aa-b8c4377cd2a5","instance_version":8,"link_map":{"link101":{"src_view_id":"output0","dst_view_id":"input0","src_id":"b2a666a4-6047-40a5-b34c-a483ed7b6eb8","dst_id":"058cdfe0-35e0-4b5d-b6a9-c0eacc71f856","isGoto":false}},"link_serial":110,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Example_Worksheet_Writer_Snap_Populating_TargetSchema_in_UpstreamSnap"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"kmalladi@snaplogic.com"}},"input":{"b2a666a4-6047-40a5-b34c-a483ed7b6eb8_input101":{"label":{"value":"Mapper - input0"},"view_type":{"value":"document"}}},"settings":{"imports":{"value":[]},"suspendable":{"value":false},"error_param_table":{"value":[]},"param_table":{"value":[{"capture":{"value":false},"description":{"value":null},"data_type":{"value":"string"},"required":{"value":false},"value":{"value":"DG_GoogleSpreadSheet_Account"},"key":{"value":"SpreadSheetAccount"}},{"capture":{"value":false},"description":{"value":null},"data_type":{"value":"string"},"required":{"value":false},"value":{"value":"TestSpreadSheetRead"},"key":{"value":"WorkBookName"}},{"capture":{"value":false},"description":{"value":null},"data_type":{"value":"string"},"required":{"value":false},"value":{"value":"TestRowNameWritten"},"key":{"value":"SheetName"}}]},"error_pipeline":{"expression":false,"value":null}},"error":{"error_behavior":{"value":"none"}},"output":{"058cdfe0-35e0-4b5d-b6a9-c0eacc71f856_output101":{"view_type":{"value":"document"},"label":{"value":"Worksheet Writer - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"55772b8495526e3fc62ac7ea","scale_ratio":1,"detail_map":{"b2a666a4-6047-40a5-b34c-a483ed7b6eb8":{"grid_x_int":3,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"rot_int":0},"058cdfe0-35e0-4b5d-b6a9-c0eacc71f856":{"grid_x_int":4,"index":null,"recommendation_id":null,"output":{},"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"error":{},"input":{},"rot_int":0}},"pan_y_num":0},"snap_map":{"b2a666a4-6047-40a5-b34c-a483ed7b6eb8":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-develop6644","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"b2a666a4-6047-40a5-b34c-a483ed7b6eb8_3","instance_id":"b2a666a4-6047-40a5-b34c-a483ed7b6eb8","instance_version":3,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper"}},"view_serial":101,"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":false,"value":"$msg"},"targetPath":{"value":"$Message"}},{"expression":{"expression":false,"value":"$num"},"targetPath":{"value":"$SerialNumber"}},{"expression":{"expression":false,"value":"$num1"},"targetPath":{"value":"$Street"}},{"expression":{"expression":false,"value":"$numstr"},"targetPath":{"value":"$address"}}]},"mappingRoot":{"value":"$"}}}},"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":"develop6644"},"058cdfe0-35e0-4b5d-b6a9-c0eacc71f856":{"class_fqid":"com-snaplogic-snaps-google-spreadsheet-worksheetwriter_1-develop6644","class_id":"com-snaplogic-snaps-google-spreadsheet-worksheetwriter","class_version":1,"instance_fqid":"058cdfe0-35e0-4b5d-b6a9-c0eacc71f856_1","instance_id":"058cdfe0-35e0-4b5d-b6a9-c0eacc71f856","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Worksheet Writer"}},"view_serial":101,"account":{"account_ref":{"expression":true,"value":"_SpreadSheetAccount"}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"retryInterval":{"expression":false,"value":1},"retries":{"expression":false,"value":3},"execution_mode":{"value":"Validate & Execute"},"connectionProperties":{"value":{"connTimeout":{"expression":false,"value":20},"timeout":{"expression":false,"value":180}}},"KeyOverwriteWorksheet":{"value":true},"KeyWriteHeaderRow":{"value":true},"executable_during_suggest":{"value":false},"KeySpreadsheet":{"expression":true,"value":"_WorkBookName"},"rowCount":{"value":10000},"batchValueInputProp":{"value":"RAW"},"batchWrite":{"value":false},"KeyWorksheet":{"expression":true,"value":"_SheetName"}},"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":"develop6644"}},"path_id":"/QA/projects/shared","path_snode":"5717ec1695526e327e7781f9","target_runtime":"standard"}