UpdateRequest
Updates a record using JSON-formatted attributes. This is useful for complex updates that involve multiple attribute types, including OptionSetValue and EntityReference.
Stored Procedure-Specific Information
To execute this procedure, enter:EXEC UpdateRequest @Entityset = 'account', @Id = '00000000-0000-0000-0000-000000000001', @UpdateRequestAttributes = '[{"attributeName": "name", "type": "string", "value": "Updated Account Name"}, {"attributeName": "statecode", "type": "OptionSetValue", "value": 0}]'
Input
| Name | Type | Description |
| Entityset | String | The entity name that has the item being updated. |
| Id | String | The GUID of the item that is being updated. |
| UpdateRequestAttributes | String | The accributes of the update. Accept type is JSON. |
Result Set Columns
| Name | Type | Description |
| Success | String | This field is true if the object was updated, false otherwise. |