UpdateStatus
Updates a record's status field to move it through a workflow step or process stage.
Stored Procedure Specific Information
Kintone allows only a small subset of columns to be used in the Exec query. These columns can typically be used with only = comparison.
To update the status of one or more records, provide the app ID, a single record ID or a comma-separated list of record IDs, and the corresponding action names.
EXECUTE UpdateStatus AppId = '1', RecordId = '21', Action = 'Start'; EXECUTE UpdateStatus AppId = '1', RecordId = '21,22,23', Action = 'Start,Progress,Complete'; EXECUTE UpdateStatus AppId = '1', RecordId = '21,22,23', Action = 'Start,Progress,Complete', Revision = '-1,-1,-1', Assignee = 'user1,user2,user3';
Input
| Name | Type | Required | Description |
| AppId | String | True | Identifier of the Kintone app that contains the record whose status is updated. |
| RecordId | String | True | Identifier of the record to update, allowing a single value or a comma-separated list of record IDs. |
| Action | String | True | Name of the workflow action to run, allowing a single value or a comma-separated list of action names that correspond to each record ID. |
| Assignee | String | False | Login name of the next assignee after the status transition, allowing a single value or a comma-separated list of assignees that correspond to each record ID. |
| Revision | String | False | Revision number of the record before the status update, allowing a single value or a comma-separated list. The request fails if the provided revision does not match the latest record revision. |
| GuestSpaceId | String | False | Identifies the guest space that contains the record, and should not be provided when the connection property GuestSpaceId is already set in the connection string. |
Result Set Columns
| Name | Type | Description |
| Success | String | Indicates whether the operation completed successfully by returning a Boolean value. |
| Id | String | Identifier of the record whose status was updated. |
| Revision | String | Revision number of the record after the update, which increases by two because both running the action and updating the status count as separate operations. |