Skip to main content Skip to complementary content
Announcements

Update records partially in one bulk operation

Performs partial update of records in one bulk operation. The records will be provided in the request content as XML or JSON.
Request 
PATCH /services/rest/data/{containerName}/{type}/bulk
Parameters
  • containerName: This is a String value which specifies the name of the data container in which you want to update records partially in one bulk operation.
  • type: This is a String value which specifies the name of the entity.
  • container: This is a String value which represents the type of the data container. It is either MASTER (default) or STAGING.
  • updateReport: This is a Boolean value which controls whether to generate a journal entry (update report). By default, it is true.
Headers
  • Content-Type: application/xml or text/xml or application/json
    Information noteNote: If the XML declaration is included in the XML request content and the encoding attribute is used, you must set its value to UTF-8.
  • Authorization: Basic Authentication scheme
Response No content.
Status
  • 200 OK: The operation is executed successfully.
  • 400 BAD REQUEST: The request contains invalid parameter, for example, invalid storage name, invalid storage type, or wrong XML document.
  • 401 UNAUTHORIZED: Login fails, invalid username or password.
  • 403 FORBIDDEN: Missing required permission, for example, no required WRITE permission.
  • 404 NOT FOUND: The resource does not exist, for example, invalid service URL.
  • 500 INTERNAL SERVER ERROR: Other errors.
Limitation This REST API does not support updating records partially in one bulk operation for the Role entity in the PROVISIONING system data container.

Sample request in XML

<records>
    <Product>
        <Id>231035933</Id>
        <Name>PartialNameUpdate1</Name>
        <Price>111</Price>
        <Stores>
            <Store>[100001]</Store>
        </Stores>
    </Product>
    <Product>
        <Id>231035934</Id>
        <Name>PartialNameUpdate2</Name>
        <Price>222</Price>
        <Family>[2]</Family>
    </Product>
</records>

Sample request in JSON (1)

[
    {
        "Product": {
            "Id": "231035933",
            "Name": "PartialNameUpdate1",
            "Price": "111",            
            "Stores": {
                "Store": ["100001"]
            }
        }
    },
    {
        "Product": {
            "Id": "231035934",
            "Name": "PartialNameUpdate2",
            "Price": "222",
            "Family": "[2]"
        }
    }
]

Sample request in JSON (2)

{
    "records": {
        "Product": [
            {
                "Id": "231035933",
                "Name": "PartialNameUpdate1",
                "Price": "111",
                "Stores": {
                    "Store": ["100001"]
                }
            },
            {
                "Id": "231035934",
                "Name": "PartialNameUpdate2",
                "Price": "222",
                "Family": "[2]"
            }
        ]
    }
}

For more examples of this REST API, see How to perform mass partial update on MDM data records through the REST API.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here