Overview

The bulk update action is designed for the use case where employees leave balance is maintained externally and the balance details need to be synced into NetSuite for reporting purposes. The bulk update   allows multiple employees to be submitted in the same request, and it performs no business or record level script resulting in less overhead and improved performance over syncEmployee. The bulk update is currently only supported on the employee record for the update of leave balances.

Bulk Update functions

Back to Payroll REST Integration

Fields

Field In JSON Request ObjectMap To NetSuite Employee Field
annualbalancecustentity_pr_annual_leave_accrued
annualavailablecustentity_pr_annual_leave_available
personalbalancecustentity_pr_personal_leave_accrued
personalavailablecustentity_pr_personal_leave_available
longservicebalancecustentity_pr_lsl_accrued
longserviceavailablecustentity_pr_lsl_available
alternatebalancecustentity_pr_alt_leave_balance
inlieubalancecustentity_pr_time_in_lieu_accrued

Example

An example request and response is listed below, containing updates for two employees. One or more fields must be specified but it is not mandatory to submit all.

RequestResponse
Bulk Update Request
{"action":"function",
 "function":"bulkupdate",
 "recordtype":"employee",
 "data":[
	{"id": "15857", "inlieubalance" : 15,"alternatebalance": 25},
    {"id": "15856", "annualbalance" : 12}
]} 
Bulk Update Response
{"success":true,
 "data":[
   {"success":true,"id":"15857"},
   {"success":true,"id":"15856"}
],"processms":"6745"}
  • No labels