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 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)

Input:

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 (Refer 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.

JSON input for Bulk Create Records

{

"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"}

]

}

Output:

JSON output for Bulk Create Records

{

"message": {

"@uri": "/ws/rest/service/status/job/115",

"job_id": "115"

},

"status": "202"

}

Response:

For when async parameter is false or not available in options.

JSON output for Bulk Create Records

{

"data":

[

],

"message":

[ "success"

],

"status":200

}

Related Topics