{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"5b39d71f36b98b35d1f18a23","instance_id":"a6393e1e-e6a7-4063-a9a3-fa1bc7946df6","instance_version":57,"link_map":{"link111":{"src_view_id":"output0","dst_view_id":"input0","src_id":"c681b25f-4a64-4239-8708-26a973116967","dst_id":"3a62fc08-b4cf-4744-ab7a-a305258a2889","isGoto":false},"link110":{"src_view_id":"output0","dst_view_id":"input0","src_id":"eec7ca33-4a92-496f-8cf2-cc5f191f0f12","dst_id":"4c6494aa-a0e9-4c7d-9c8d-b026966902aa","isGoto":false},"link113":{"src_view_id":"output0","dst_view_id":"inputRows","src_id":"3a62fc08-b4cf-4744-ab7a-a305258a2889","dst_id":"e9568ac8-80d4-4ade-9271-7a444520a9a4","isGoto":false},"link109":{"src_view_id":"output0","dst_view_id":"input0","src_id":"4c6494aa-a0e9-4c7d-9c8d-b026966902aa","dst_id":"b09eaa03-2403-484a-a477-6e6ed1021e48","isGoto":false},"link102":{"src_view_id":"output0","dst_view_id":"input101","src_id":"b09eaa03-2403-484a-a477-6e6ed1021e48","dst_id":"c681b25f-4a64-4239-8708-26a973116967","isGoto":false},"link100":{"src_view_id":"output0","dst_view_id":"input0","src_id":"59dcb997-2977-4d8e-885a-501d843b6de8","dst_id":"eec7ca33-4a92-496f-8cf2-cc5f191f0f12","isGoto":false}},"link_serial":114,"property_map":{"info":{"notes":{"value":"Associated JIRA Ticket#:\nhttps://mysnaplogic.atlassian.net/browse/SNAP-4044\n\nWhat this Pipeline Does: \nRetrieves data from an SLDB file, filters the list of users, retrieves data from Workday about the filtered user list, and uploads retrieved data into a SQL server.\n\nRelated Data Required:\n../shared/Staff.json\n\nContact Dev Person\nPatan Manzoor\n\nContact QA Person\nSatish Reddi"},"label":{"value":"Workday_PM"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"sreddi@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":{"e9568ac8-80d4-4ade-9271-7a444520a9a4_output101":{"view_type":{"value":"document"},"label":{"value":"SQL Server Bulk Load - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"55772b8495526e3fc62ac7ea","scale_ratio":1,"detail_map":{"4c6494aa-a0e9-4c7d-9c8d-b026966902aa":{"grid_x_int":4,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"rot_int":0},"b09eaa03-2403-484a-a477-6e6ed1021e48":{"grid_x_int":5,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"rot_int":0},"3a62fc08-b4cf-4744-ab7a-a305258a2889":{"grid_x_int":7,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"rot_int":0},"59dcb997-2977-4d8e-885a-501d843b6de8":{"grid_x_int":2,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"rot_int":0},"e9568ac8-80d4-4ade-9271-7a444520a9a4":{"grid_x_int":8,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"rot_int":0},"eec7ca33-4a92-496f-8cf2-cc5f191f0f12":{"grid_x_int":3,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"output":{},"input":{},"rot_int":0},"c681b25f-4a64-4239-8708-26a973116967":{"grid_x_int":6,"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":{"4c6494aa-a0e9-4c7d-9c8d-b026966902aa":{"class_fqid":"com-snaplogic-snaps-flow-filter_2-MULTIPLE5360","class_id":"com-snaplogic-snaps-flow-filter","class_version":2,"instance_fqid":"4c6494aa-a0e9-4c7d-9c8d-b026966902aa_13","instance_id":"4c6494aa-a0e9-4c7d-9c8d-b026966902aa","instance_version":13,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Filter User Data"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"filterExpression":{"expression":true,"value":"parseInt(jsonPath($, \"$['wd:Worker'][*]['wd:Worker_Data']['wd:Worker_ID']\")[0]) > 21040"}},"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":"MULTIPLE5360"},"b09eaa03-2403-484a-a477-6e6ed1021e48":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-MULTIPLE5366","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"b09eaa03-2403-484a-a477-6e6ed1021e48_14","instance_id":"b09eaa03-2403-484a-a477-6e6ed1021e48","instance_version":14,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Map Data Fields"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"targetPath":{"value":"$Request_References.Worker_Reference[*].ID[*].value"},"expression":{"expression":true,"value":"jsonPath($, \"$['wd:Worker'][*]['wd:Worker_Reference']['wd:ID'][0]['$']\").toString()"}},{"targetPath":{"value":"$Request_References.Worker_Reference[*].ID[*].type"},"expression":{"expression":false,"value":"WID"}}]},"mappingRoot":{"value":"$"}}}},"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":"MULTIPLE5366"},"3a62fc08-b4cf-4744-ab7a-a305258a2889":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsrc970","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"3a62fc08-b4cf-4744-ab7a-a305258a2889_4","instance_id":"3a62fc08-b4cf-4744-ab7a-a305258a2889","instance_version":4,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Map to SQL"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":true,"value":"jsonPath($, \"$['wd:Worker'][*]['wd:Worker_Reference']['wd:ID'][*]['$']\").toString()"},"targetPath":{"value":"$Id"}},{"expression":{"expression":true,"value":"jsonPath($, \"$['wd:Worker'][*]['wd:Worker_Reference']['wd:ID'][*]['@wd:type']\").toString()"},"targetPath":{"value":"$Type"}},{"expression":{"expression":true,"value":"jsonPath($, \"$['wd:Worker'][*]['wd:Worker_Reference']['@wd:Descriptor']\").toString()"},"targetPath":{"value":"$Descriptor"}}]},"mappingRoot":{"value":"$"}}}},"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":"snapsrc970"},"59dcb997-2977-4d8e-885a-501d843b6de8":{"class_fqid":"com-snaplogic-snaps-binary-simpleread_1-binary5402","class_id":"com-snaplogic-snaps-binary-simpleread","class_version":1,"instance_fqid":"59dcb997-2977-4d8e-885a-501d843b6de8_4","instance_id":"59dcb997-2977-4d8e-885a-501d843b6de8","instance_version":4,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Read Data from SLDB"}},"view_serial":100,"account":{"account_ref":{"expression":false,"value":{}}},"settings":{"enableStaging":{"value":false},"executeDuringPreview":{"value":true},"preventURLEncoding":{"value":false},"filePath":{"expression":false,"value":"../shared/Staff.json"}},"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":"binary5402"},"e9568ac8-80d4-4ade-9271-7a444520a9a4":{"class_fqid":"com-snaplogic-snaps-sqlserver-bulkload_1-snapsrc970","class_id":"com-snaplogic-snaps-sqlserver-bulkload","class_version":1,"instance_fqid":"e9568ac8-80d4-4ade-9271-7a444520a9a4_3","instance_id":"e9568ac8-80d4-4ade-9271-7a444520a9a4","instance_version":3,"property_map":{"info":{"notes":{"value":null},"label":{"value":"SQL Server Bulk Load"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"d5cb895e-3417-4828-9801-d4d0adfed255"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-sqlserverdatabaseaccount"},"label":{"expression":false,"value":"SQL Server TestDB xl - not for diagnostics"}}}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"settings":{"maxError":{"value":10},"KeyBcpPath":{"value":null},"tableName":{"expression":false,"value":"\"dbo\".\"Workday\""},"executable_during_suggest":{"value":true},"createTable":{"value":true},"schemaName":{"expression":false,"value":"\"dbo\""}},"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":"snapsrc970"},"eec7ca33-4a92-496f-8cf2-cc5f191f0f12":{"class_fqid":"com-snaplogic-snaps-transform-jsonparser_1-MULTIPLE5366","class_id":"com-snaplogic-snaps-transform-jsonparser","class_version":1,"instance_fqid":"eec7ca33-4a92-496f-8cf2-cc5f191f0f12_1","instance_id":"eec7ca33-4a92-496f-8cf2-cc5f191f0f12","instance_version":1,"property_map":{"info":{"label":{"value":"JSON Parser"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"binary"}}},"settings":{"allowNonStandardJson":{"value":true},"arrayElementsAsDocuments":{"value":true},"jsonFilterPath":{"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":"MULTIPLE5366"},"c681b25f-4a64-4239-8708-26a973116967":{"class_fqid":"com-snaplogic-snaps-workday-workdayread_3-MULTIPLE5360","class_id":"com-snaplogic-snaps-workday-workdayread","class_version":3,"instance_fqid":"c681b25f-4a64-4239-8708-26a973116967_9","instance_id":"c681b25f-4a64-4239-8708-26a973116967","instance_version":9,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Workday Read"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"Workday Read"},"ref_class_id":{"value":"com-snaplogic-snaps-workday-workdaysoapaccount"},"ref_id":{"expression":false,"value":"6e0cfac6-907b-4caa-a92a-dbc304e4e109"}}}},"settings":{"PageSize":{"value":100},"service":{"expression":false,"value":"Staffing"},"outputs":{"value":[]},"object":{"expression":false,"value":"Get_Workers"},"PageNumber":{"value":0},"timeout":{"value":60},"SimplifiedOutput":{"value":false}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"MULTIPLE5360"}},"path_id":"/QA/projects/shared","path_snode":"5717ec1695526e327e7781f9","snap_history":{"4c6494aa-a0e9-4c7d-9c8d-b026966902aa":{"index":null,"added_ts":1530527873270,"is_deleted":false,"class_id":"com-snaplogic-snaps-flow-filter","recommendation_id":null,"source":"snap catagory","deleted_ts":null},"2e6d9972-f56a-4d16-b0b8-92a4c2bb2802":{"index":null,"added_ts":1530519461225,"is_deleted":true,"class_id":"com-snaplogic-snaps-flow-head","recommendation_id":null,"source":"snap catagory","deleted_ts":1530529786438},"b09eaa03-2403-484a-a477-6e6ed1021e48":{"index":null,"added_ts":1530517290552,"is_deleted":true,"class_id":"com-snaplogic-snaps-transform-datatransform","recommendation_id":null,"source":"snap catagory","deleted_ts":1530519501148},"3a62fc08-b4cf-4744-ab7a-a305258a2889":{"index":null,"added_ts":1530881676852,"is_deleted":false,"class_id":"com-snaplogic-snaps-transform-datatransform","recommendation_id":null,"source":"snap catagory","deleted_ts":null},"7a5b1abd-b576-4d1c-bcfb-84208ca7e066":{"index":null,"added_ts":1530529295250,"is_deleted":true,"class_id":"com-snaplogic-snaps-transform-datatransform","recommendation_id":null,"source":"snap catagory","deleted_ts":1530529736777},"59dcb997-2977-4d8e-885a-501d843b6de8":{"index":null,"added_ts":1530517303044,"is_deleted":false,"class_id":"com-snaplogic-snaps-binary-simpleread","recommendation_id":null,"source":"snap catagory","deleted_ts":null},"e9568ac8-80d4-4ade-9271-7a444520a9a4":{"index":null,"added_ts":1530881907874,"is_deleted":false,"class_id":"com-snaplogic-snaps-sqlserver-bulkload","recommendation_id":null,"source":"snap catagory","deleted_ts":null},"8235645b-0274-4cbb-b902-3370eba1b1f4":{"index":null,"added_ts":1530881690379,"is_deleted":true,"class_id":"com-snaplogic-snaps-azuresql-azuresqlbulkload","recommendation_id":null,"source":"snap catagory","deleted_ts":1530881909481},"eec7ca33-4a92-496f-8cf2-cc5f191f0f12":{"index":null,"added_ts":1530517308796,"is_deleted":false,"class_id":"com-snaplogic-snaps-transform-jsonparser","recommendation_id":null,"source":"snap catagory","deleted_ts":null},"c681b25f-4a64-4239-8708-26a973116967":{"index":null,"added_ts":1530517756798,"is_deleted":false,"class_id":"com-snaplogic-snaps-workday-workdayread","recommendation_id":null,"source":"snap catagory","deleted_ts":null},"x1234":{"index":null,"added_ts":1530529279133,"is_deleted":true,"class_id":"com-snaplogic-snaps-transform-datatransform","recommendation_id":null,"source":"snap catagory","deleted_ts":1530529292603}}}