{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"666748ee9705251980585782","instance_id":"42cf9af7-d161-4bdd-aad6-3e197371364c","instance_version":16,"link_map":{"link100":{"dst_id":"611c5ee9-6c87-4fd9-9845-60a9a3c07b5e","dst_view_id":"input0","src_id":"10b52dcf-7e7a-4bcf-8401-b90f2d0b336d","src_view_id":"output0","isGoto":false},"link101":{"dst_id":"3658bce7-9879-4b54-b639-19d67c9c8649","dst_view_id":"input0","src_id":"611c5ee9-6c87-4fd9-9845-60a9a3c07b5e","src_view_id":"output0","isGoto":false}},"link_serial":102,"property_map":{"info":{"label":{"value":"Community 26089 - Extract values"},"author":{"value":"koryknick@snaplogic.com"},"pipeline_doc_uri":{"value":null},"notes":{"value":null},"purpose":{"value":null}},"error":{"error_behavior":{"value":"none"}},"settings":{"error_pipeline":{"value":null,"expression":false},"error_param_table":{"value":[]},"param_table":{"value":[]},"imports":{"value":[]},"cache_pipelines":{"value":[]}},"input":{},"output":{"3658bce7-9879-4b54-b639-19d67c9c8649_output0":{"view_type":{"value":"document"},"label":{"value":"Map field to changedFields - output0"}}}},"render_map":{"scale_ratio":1,"pan_x_num":0,"pan_y_num":0,"default_snaplex":"5a7406fbf405bb1dcc706e58","detail_map":{"10b52dcf-7e7a-4bcf-8401-b90f2d0b336d":{"grid_x_int":3,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"input":{}},"611c5ee9-6c87-4fd9-9845-60a9a3c07b5e":{"grid_x_int":4,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0},"3658bce7-9879-4b54-b639-19d67c9c8649":{"grid_x_int":5,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0}}},"snap_map":{"10b52dcf-7e7a-4bcf-8401-b90f2d0b336d":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-437patches26453","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"10b52dcf-7e7a-4bcf-8401-b90f2d0b336d_2","instance_id":"10b52dcf-7e7a-4bcf-8401-b90f2d0b336d","instance_version":2,"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":"{\n\"guid\": \"bdb6cdfc-8008-4a1d-95df-8e789732ad32\",\n\"name\": \"Eric Employee\",\n\"createdOn\": \"2016-04-14T11:50:28.590+02:00\",\n\"lastModified\": \"2024-06-10T00:05:00.700+02:00\",\n\"lastExtractionDate\": \"2024-05-10T14:11:00+02:00\",\n\"hasPlannedChange\": \"1\",\n\"firstName\": \"Eric\",\n\"lastName\": \"Employee\",\n\"legalEntity\": \"Company Inc\",\n\"field\": [\n{\n\"name\": \"Country\",\n\"lastModified\": \"2024-05-17T12:46:31.460+02:00\",\n\"dataValidFrom\": \"2024-05-17\",\n\"type\": \"SCALE\",\n\"typeId\": \"8\",\n\"data\": {\n\"guid\": \"630dd5a0-aa2a-4ab7-9977-c1e9d48cb379\",\n\"value\": \"Denmark\",\n\"alternativeExportValue\": \"DK\"\n},\n\"visible\": \"1\"\n},\n{\n\"name\": \"E-mail\",\n\"lastModified\": \"2024-06-10T00:05:00.700+02:00\",\n\"dataValidFrom\": \"2024-06-10\",\n\"type\": \"TEXT\",\n\"typeId\": \"1\",\n\"data\": {\n\"value\": \"eric_employee_2@company.com\"\n},\n\"visible\": \"1\",\n\"plannedChange\": {\n\"lastModified\": \"2024-06-10T13:39:30.923+02:00\",\n\"dataValidFrom\": \"2024-06-11\",\n\"dataValidTo\": \"2024-06-28\",\n\"status\": \"1\",\n\"data\": {\n\"value\": \"eric.employee@company.com\"\n}\n}\n},\n{\n\"name\": \"Manager\",\n\"lastModified\": \"2024-06-06T10:38:42.333+02:00\",\n\"dataValidFrom\": \"2024-06-06\",\n\"type\": \"PERSON\",\n\"typeId\": \"10\",\n\"data\": {\n\"guid\": \"a4666edc-d1ab-456a-ae06-8625eb933c06\",\n\"value\": \"Manager Boss\",\n\"username\": \"man.boss@company.com\",\n\"employeeId\": \"200384\"\n},\n\"visible\": \"1\"\n}\n]\n}\n"},"arrayElementsAsDocuments":{"value":true},"passThroughProp":{"value":false},"supportTypeExts":{"value":false}},"view_serial":100,"input":{}},"class_build_tag":"437patches26453"},"611c5ee9-6c87-4fd9-9845-60a9a3c07b5e":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-437patches26453","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"611c5ee9-6c87-4fd9-9845-60a9a3c07b5e_6","instance_id":"611c5ee9-6c87-4fd9-9845-60a9a3c07b5e","instance_version":6,"property_map":{"info":{"label":{"value":"ReMap field array"},"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":false},"transformations":{"value":{"mappingRoot":{"value":"$field[*]"},"mappingTable":{"value":[{"expression":{"expression":true,"value":"$name"},"targetPath":{"value":"$name"}},{"expression":{"value":"$.hasPath('plannedChange') ? $plannedChange.data.value : $data.value","expression":true},"targetPath":{"value":"$value"}},{"expression":{"value":"$.hasPath('plannedChange') ? 1 : null","expression":true},"targetPath":{"value":"$isPlannedChange"}},{"expression":{"value":"$.hasPath('plannedChange') ? $plannedChange.dataValidFrom : $dataValidFrom","expression":true},"targetPath":{"value":"$dataValidFrom"}},{"expression":{"value":"$.hasPath('plannedChange') ? $plannedChange.get('dataValidTo') : $.get('dataValidTo')","expression":true},"targetPath":{"value":"$dataValidTo"}}]}}},"nullSafeAccess":{"value":false}},"view_serial":100},"class_build_tag":"437patches26453"},"3658bce7-9879-4b54-b639-19d67c9c8649":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-437patches26453","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"3658bce7-9879-4b54-b639-19d67c9c8649_7","instance_id":"3658bce7-9879-4b54-b639-19d67c9c8649","instance_version":7,"property_map":{"info":{"label":{"value":"Map field to changedFields"},"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":{"expression":true,"value":"$field.map(elem => elem.filter((val,key) => val > ''))"},"targetPath":{"value":"$changedFields"}},{"expression":{"value":"$field","expression":true},"targetPath":{"value":null}}]}}},"nullSafeAccess":{"value":false}},"view_serial":100},"class_build_tag":"437patches26453"}},"path_id":"/SnapLogic-PS-Team/KoryK/Examples","path_snode":"5ec42662c1917d398931e634","target_runtime":"standard"}