ServiceNow Workday Integration Guide

// Configure the Get Workers action data pills
// In the Flow Designer action configuration:
{
  "workers_request": {
    "Worker_Request_Criteria": {
      "Exclude_Inactive_Workers": true,
      "Exclude_Contingent_Workers": false
    },
    "Response_Group": {
      "Include_Personal_Information": true,
      "Include_Employment_Information": true,
      "Include_Organizations": true
    }
  }
}

// User record update script in Flow Designer Script step
var user = new GlideRecord('sys_user');
user.addQuery('employee_number', fd_data.lookup.workday_worker_id);
user.query();

if (user.next()) {
  user.email = fd_data.lookup.workday_email;
  user.first_name = fd_data.lookup.workday_first_name;
  user.last_name = fd_data.lookup.workday_last_name;
  user.department = fd_data.lookup.workday_department;
  user.title = fd_data.lookup.workday_title;
  user.manager = fd_data.lookup.workday_manager_sys_id;
  user.active = fd_data.lookup.workday_active_status;
  user.update();
  fd_data.action_result = 'updated';
} else {
  user.initialize();
  user.employee_number = fd_data.lookup.workday_worker_id;
  user.user_name = fd_data.lookup.workday_email;
  user.email = fd_data.lookup.workday_email;
  user.first_name = fd_data.lookup.workday_first_name;
  user.last_name = fd_data.lookup.workday_last_name;
  user.active = true;
  user.insert();
  fd_data.action_result = 'created';
}

// Department synchronization logic in Script step
var dept = new GlideRecord('cmn_department');
dept.addQuery('dept_head', fd_data.lookup.workday_org_id);
dept.query();

if (!dept.next()) {
  dept.initialize();
  dept.name = fd_data.lookup.workday_org_name;
  dept.dept_head = fd_data.lookup.workday_manager_sys_id;
  dept.cost_center = fd_data.lookup.workday_cost_center;
  dept.head_count = fd_data.lookup.workday_headcount;
  dept.parent = fd_data.lookup.parent_dept_sys_id;
  dept.insert();
} else {
  dept.name = fd_data.lookup.workday_org_name;
  dept.head_count = fd_data.lookup.workday_headcount;
  dept.update();
}

// Business rule on sys_user table for onboarding trigger
(function executeRule(current, previous) {
  // Trigger when new user created with employee_number
  if (current.isNewRecord() && current.employee_number && current.active) {
    var onboardingFlow = new sn_fd.FlowAPI();
    var inputs = {
      'employee_sys_id': current.sys_id,
      'employee_number': current.employee_number.toString(),
      'start_date': current.u_start_date || gs.nowDate(),
      'department': current.department.getDisplayValue(),
      'manager_sys_id': current.manager.toString()
    };
    onboardingFlow.startFlow('hr_onboarding_process', inputs);
  }
  
  // Trigger offboarding when user becomes inactive
  if (!current.isNewRecord() && !current.active && previous.active) {
    var offboardingFlow = new sn_fd.FlowAPI();
    var inputs = {
      'employee_sys_id': current.sys_id,
      'termination_date': gs.nowDate(),
      'last_day': current.u_last_day || gs.nowDate()
    };
    offboardingFlow.startFlow('hr_offboarding_process', inputs);
  }
})(current, previous);

// Error handling and logging in flow script step
try {
  var response = request.execute();
  if (response.getStatusCode() != 200) {
    gs.error('Workday API Error: ' + response.getStatusCode() + ' - ' + response.getBody());
    
    // Create event for monitoring
    var event = new GlideRecord('em_event');
    event.initialize();
    event.source = 'Workday Integration';
    event.node = gs.getProperty('instance_name');
    event.type = 'Integration Failure';
    event.severity = 3;
    event.description = 'Failed to retrieve worker data from Workday: ' + response.getStatusCode();
    event.insert();
    
    fd_data.error_occurred = true;
    fd_data.error_message = response.getBody();
  } else {
    fd_data.worker_data = response.getBody();
    gs.info('Successfully retrieved ' + JSON.parse(response.getBody()).length + ' workers from Workday');
  }
} catch (ex) {
  gs.error('Exception in Workday integration: ' + ex.getMessage());
  fd_data.error_occurred = true;
  fd_data.error_message = ex.getMessage();
}