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: The RAP will not be triggered upon creation of the records. (since 19.12.13.1)
Request Format
Authentication
Integration user authorization token is required as part of Authorization header with necessary BP Create service permission for that integration user.
The integration user token can be generated by using the Unifier Admin UI or by using API (for more information, see REST Services V1).
Header
Authorization:Bearer eyJ0eXAiOiJEQiJ9.eyJ1c2VybmFtZSI6IiQkaW50ZWcxIn0=.43E4736D-37C2-60AF-E643-C6B648DE07DD26CDA133C93F3DF5B37D129FA40232F6
Content-Type:application/json
Both input & output in JSON format in the body.
Notes:
- The "async" param in the options JSON is optional and if true, processes the request asynchronously. A call back URL is obtained in response for the caller to ping back on the status of the request.
- The record_no will be auto generated; even if it is specified, it will be ignored.
- Logic for auto-population of values from Details form (sum of all lines) for the amount type fields was not included in bulk BP records creation code.
- Amount DE in upper form is rolled up from line items; it should not be a part of upper form data.
- Auto-population from Data Picker Data Element (DE): When you use Bulk Create or Bulk Update, you start by exporting the BP design structure to a Microsoft Excel or CSV file and then populating the required fields. During a Bulk Update, in cases where one or more DEs in the Upper Form selected as the Integration Form is configured for auto-population from a Data Picker DE, the system allows these DEs to be auto-populated from the data picker or updated independently. To allow for auto-population, the DEs should be excluded from the Integration Data Elements tab; in this case, if the value of the data picker is updated during Bulk Update, the configured auto-population is applied. However, if the DEs are included in the Data Elements tab, the auto-population is ignored, which allows these DEs to be updated individually.
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, April 9, 2025