SSIS Components for Kintone

Build 26.0.9655

UpdateStatus

Updates a record's status field to move it through a workflow step or process stage.

Note:このプロシージャは、インデックス付きパラメータを使用します。 インデックス付きパラメータは、プロシージャの入力として単一のパラメータを複数のインスタンスに提供することを容易にします。

Param# という名前の入力パラメータがあるとします。このようなインデックス付きパラメータの複数のインスタンスを入力するには、次のように実行します。

EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"

以下のInput テーブルでは、インデックス付きの入力パラメータは、名前の末尾に '#' 文字が付きます。

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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655