Accelerate the Value of Data

Cumulative Entity Update

You can make multiple changes to an entity's attribute at the same time using a cumulative update request.

The following request allows you to do a cumulative entity update:

Request

POST {TenantURL}/{objectURI}/_update
Table 1. Parameters
Parameter Required Details
HeadersAuthorizationYesInformation about the authentication access token must be in the following format "Bearer <accessToken>". For more information, see Authentication API.
QuerychangeRequestIdNoIf this parameter is present, all changes will be added to the DCR with a given ID instead of updating the entity.
alwaysCreateDCRNo

If true, create a DCR without updating an entity.

Example:

POST {{api_uri}}/{{tenant}}/entities/{{entity_id}}/_update?alwaysCreateDCR=true
[
    {
        "type": "UPDATE_ATTRIBUTE",
        "uri": "entities/{{entityID}}/attributes/FirstName/{{FirstNameID}}",
        "newValue": {
            "value": "Updated"
        },
        "crosswalk": {
            "type": "configuration/sources/Reltio",
            "value": "{{entityID}}",
            "sourceTable": "testTable"
        }
    },
    {
        "type": "DELETE_ATTRIBUTE",
        "uri": "entities/{{entityID}}/attributes/LastName/{{LastNameID}}",
        "crosswalk": {
            "type": "configuration/sources/Reltio",
            "value": "{{entityID}}",
            "sourceTable": "testTable"
        }
    },
    {
        "type": "IGNORE_ATTRIBUTE",
        "uri": "entities/{{entityID}}/attributes/MiddleName/{{MiddleNameID}}",
        "newValue": {
            "value": true
        }
    },
    {
        "type": "INSERT_ATTRIBUTE",
        "uri": "entities/{{entityID}}/attributes/Int",
        "newValue": [
            {
                "value": "55"
            }
        ]
    }
]

overwriteDefaultCrosswalkValueNoIf set to false, the process of normalization of Reltio crosswalk is skipped. Default is true.
BodyRequest definitionYes

Array of JSON objects, where each object represents changing of an attribute, tags, or roles. Each object must have a type property, which is the type of change.

The following types of changes can be done for an entity:

  • INSERT_ATTRIBUTE
  • UPDATE_ATTRIBUTE
  • DELETE_ATTRIBUTE
  • PIN_ATTRIBUTE
  • IGNORE_ATTRIBUTE
  • UPDATE_TAGS
  • UPDATE_ROLES
  • UPDATE_START_DATE
  • UPDATE_END_DATE

All changes, except DELETE_ATTRIBUTE, must have a newValue property, which is the new value of attributes, tags, or roles.

INSERT_ATTRIBUTE, UPDATE_ATTRIBUTE, DELETE_ATTRIBUTE, PIN_ATTRIBUTE, IGNORE_ATTRIBUTE changes must have the uri property,which is the URI of the attribute.

INSERT_ATTRIBUTE, UPDATE_ATTRIBUTE, and DELETE_ATTRIBUTE changes must have the crosswalk property, which is the crosswalk for which this attribute should be updated.

Request Examples

Example 1:
[
    {
        "type": "INSERT_ATTRIBUTE",
        "uri": "entities/000005KL/attributes/FirstName",
        "newValue": [
            {
                "value": "John"
            },
            {
                "value": "Jonny"
            }
        ],
        "crosswalk": {
            "type": "configuration/sources/HMS",
            "value": "test1",
            "sourceTable": "testTable"
        }
    },
    {
        "type": "INSERT_ATTRIBUTE",
        "uri": "entities/000005KL/attributes/Identifiers",
        "newValue": [
            {
                "value": {
                    "Type": [
                        {
                            "value": "Test"
                        }
                    ],
                    "ID": [
                        {
                            "value": "1111"
                        }
                    ]
                }
            }
        ],
        "crosswalk": {
            "type": "configuration/sources/Reltio",
            "value": "000005KL",
            "sourceTable": "testTable"
        }
    },
    {
        "type": "UPDATE_ATTRIBUTE",
        "uri": "entities/000005KL/attributes/LastName/ohg4GDs3",
        "newValue": {
            "value": "Smith"
        },
        "crosswalk": {
            "type": "configuration/sources/HMS",
            "value": "test1",
            "sourceTable": "testTable"
        }
    },
    {
        "type": "DELETE_ATTRIBUTE",
        "uri": "entities/000005KL/attributes/MiddleName/Jk07LJ3d",
        "crosswalk": {
            "type": "configuration/sources/HMS",
            "value": "test1",
            "sourceTable": "testTable"
        }
    },
    {
        "type": "PIN_ATTRIBUTE",
        "uri": "entities/000005KL/attributes/ProductMetrics/IL98KH3f",
        "newValue": {
            "value": "true"
        }
    },
    {
        "type": "IGNORE_ATTRIBUTE",
        "uri": "entities/000005KL/attributes/ProductMetrics/IL98KH3f/Name/ohgGk4wd",
        "newValue": {
            "value": "false"
        }
    },
    {
        "type": "UPDATE_TAGS",
        "newValue": [
            "tag1",
            "tag2"
        ]
    },
    {
        "type": "UPDATE_ROLES",
        "newValue": []
    },
    {
        "type": "UPDATE_START_DATE",
        "newValue": "1455702524000"
    },
    {
        "type": "UPDATE_END_DATE",
        "newValue": "1455702524000"
    }
]
    
Example 2:
 [
    {
        "type": "INSERT_ATTRIBUTE",
        "uri": "entities/000005KL/attributes/Address",
        "newValue": [
            {
                "value": {
                    "AddressRank": [
                        {
                            "value": "1"
                        }
                    ],
                    "AddressLine1": [
                        {
                            "value": "Address1"
                        }
                    ]
                },
                "refEntity": {
                    "crosswalks": [
                        {
                            "type": "configuration/sources/Veeva",
                            "value": "763127815f9f6ec9e2b9a399db8d18c7",
                            "sourceTable": "testTable"
                        }
                    ]
                },
                "refRelation": {
                    "crosswalks": [
                        {
                            "type": "configuration/sources/Veeva",
                            "value": "r1",
                            "sourceTable": "testTable"
                        }
                    ],
                    "startRefPinned": false,
                    "endRefPinned": false,
                    "startRefIgnored": false,
                    "endRefIgnored": false
                }
            }
        ],
        "crosswalk": {
            "type": "configuration/sources/Reltio",
            "value": "000005KL",
            "sourceTable": "testTable"
        }
    },
    {
        "type": "UPDATE_ATTRIBUTE",
        "uri": "entities/000005KL/attributes/Address/IL98KH3f/AddressRank/ohgGk4wd",
        "newValue": {
            "value": "7"
        },
        "crosswalk": {
            "type": "configuration/sources/Reltio",
            "value": "00000Hg3",
            "sourceTable": "testTable"
        }
    }
]

Response

Changed entity or data change request (if changeRequestId is defined or if you do not have access to update the object, but you do have permission to initiate a data change request).

Note: If the cumulative update request contains a crosswalk of an existing entity that does not belong to the entity being updated, such a request is rejected, and the following error message is returned: "Cumulative update request should not contain crosswalk of already existing entity".