Bulk Create Records
POST /ws/rest/service/v2/bp/record/bulk
Purpose
To create bulk BP records of Simple and Line Item BP (non-workflow) type.
There are a couple of optimizations done in this service with reference to existing v1/v2 BP Create services.
Note Beginning with Unifier version 19.12.13.1, reverse auto-population (RAP) is no longer triggered upon creation of records.
Request Format
Authentication
An integration user authorization token is required in the Authorization header, and the integration user must have the necessary BP Create service permission. The integration user token can be generated by using the Unifier Admin UI or by using the API (for more information, see Accessing Representational State Transfer (REST) Services V1 and V2).
Header
Authorization:Bearer eyJ0eXAiOiJEQiJ9.eyJ1c2VybmFtZSI6IiQkaW50ZWcxIn0=.43E4736D-37C2-60AF-E643-C6B648DE07DD26CDA133C93F3DF5B37D129FA40232F6
Content-Type:application/json
Both input & output in JSON format in the body.
Note
- The "async" parameter in the options JSON is optional. If set to true, the request is processed asynchronously, and a callback URL is provided in the response for the caller to check the status of the request.
- The record_no is auto-generated. Any value specified will be ignored.
- The logic for auto-populating amount-type fields from the Details form (sum of all lines) is not included in the Bulk Create code.
- The Amount DE in the upper form is rolled up from the line items and should not be included in the upper form data.
- Auto-population from Data Picker Data Element (DE): When using Bulk Create or Bulk Update, begin by exporting the BP design structure to a Microsoft Excel or CSV file and populate the required fields. During Bulk Update, if one or more DEs in the Upper Form (selected as the Integration Form) are configured for auto-population from a Data Picker DE, the system enables these DEs to be either auto-populated from the data picker or updated independently. For auto-population to occur, the DEs must be excluded from the Integration Data Elements tab. When they are excluded, any changes to the data picker value during Bulk Update will trigger the configured auto-population. If the DEs are included in the Data Elements tab, auto-population is ignored, and these DEs can be updated individually.
- After records are created using Bulk Create, subsequent integration runs can generate the auto-sequence values.
Response Format
A JSON object is returned in the following format.
{
"data": [],
"message": [],
"status": <REST status code value>
}
A successful response displays a status code 200.
A failed response displays a message with a status code.
Sample Request
{
"options":{
"project_number":"P-0001",
"bpname":"Areas Bulk Create",
"async": true
},
"data":[
{"ugenProjectName": "P-002", "Quantity": 1.0, "uMatCost": 1.0, "ugenVendorBP": "VEN-0001","title": "AreasBulkCreate1","uem_rate": 1.0,"Assigned_To": "Company Administrator","ugenProjectNumber": "P-0001", "uriEnvironImpactPD": "Yes","CPLGrossAreaND": 0.0,"creator_id": "Company Administrator","uPracqSiteVisDateDOP": "06-05-2020 00:00:00","WaterMeterBPDP": "uwm-0000","status": "Active"},
{"ugenProjectName": "P-002", "Quantity": 2.0, "uMatCost": 1.0, "ugenVendorBP": "VEN-0001","title": "AreasBulkCreate2","uem_rate": 1.0,"Assigned_To": "Company Administrator","ugenProjectNumber": "P-0001", "uriEnvironImpactPD": "Yes","CPLGrossAreaND": 0.0,"creator_id": "Company Administrator","uPracqSiteVisDateDOP": "06-05-2020 00:00:00","WaterMeterBPDP": "uwm-0001","status": "Active"},
{"ugenProjectName": "P-002", "Quantity": 3.0, "uMatCost": 1.0, "ugenVendorBP": "VEN-0001","title": "AreasBulkCreate3","uem_rate": 1.0,"Assigned_To": "Company Administrator","ugenProjectNumber": "P-0001", "uriEnvironImpactPD": "Yes","CPLGrossAreaND": 0.0,"creator_id": "Company Administrator","uPracqSiteVisDateDOP": "06-05-2020 00:00:00","WaterMeterBPDP": "uwm-0000","status": "Active"}
]
}
Sample Response
{
"message": {
"@uri": "/ws/rest/service/status/job/115",
"job_id": "115"
},
"status": "202"
}
Sample Response
For when async parameter is false or not available in options.
{
"data":
[
],
"message":
[ "success"
],
"status":200
}
Related Topics
Create BP Record with Attachment
Update BP Record with Attachment
Payment Application with Auto-populate from SOV and Commits
Add Assignees to Workflow BP Records
Task Reassignment of Workflow Records
Bulk Reverse Auto-populate Records
Get Schedule of Values (SOVs) For Base Commit Type BPs
Terminate Workflow and Non-Workflow BP Records
Last Published Wednesday, December 10, 2025