UpdateStatus
Updates a record's status field to move it through a workflow step or process stage.
Note: This procedure makes use of indexed parameters. Indexed parameters facilitate providing multiple instances a single parameter as inputs for the procedure.
Suppose there is an input parameter named Param#. To input multiple instances of an indexed parameter like this, execute:
EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"
In the Input table below, indexed parameters are denoted with a '#' character at the end of their names.
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 that is moved to a new status when the action is executed. |
| Action# | String | True | Name of the workflow action to run, which must match the action name in the user's language settings when localized action names are in use. |
| Assignee# | String | False | Login name of the user who becomes the next assignee after the status transition is completed. |
| Revision# | String | False | Revision number of the record before the status update, required to ensure the record has not been modified since it was last retrieved. |
| 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. |