Job Runner

Update Records by Key Value

Overview

Update the data in an existing record of the specified app by providing the key to search for the record with the value.

Usage

Place the action Kintone connection settings before the action Update Records by Key Value.

The result of the action is a set of updated records.

You can do further field value changes by passing the Update Records by Key Value result value as the record parameter to a type of Do that changes the field value, such as Set Field Value. However, it is not efficient because it will be saved to Kintone twice. It is recommended to complete only the Update Records by Key Value if possible.

Parameter

Set Target app, API Token, Key Fields, Key Value, Mapping, and Check Conflict.

Target app

Select the app with the record to update.

API token setting

Specify the API Token to access the destination app. Choose from the Set Kintone API Token action.

The API Token must have view record and edit record privileges.

Key Field

Select the key fields to update the record.

This parameter does not accept fields that are inside tables.

Note that this parameter does not accept the following field types:

  • Category
  • Table
  • Related records
  • Field group
  • Blank space

Key Value

Enter key value for the record to be updated.

Mapping

Enter the information you want to register in the record.

See Field Mapping Description for detailed descriptions of this parameter.

You can use @out in this mapping, where @out refers to the record that matches the key.

Check Conflict

Select from Check or Do Not Check.

If Check, update records are checked for conflicts with updates from other users, and if so, an error is raised at runtime. If Do Not Check, do not check this.

If you’re not sure, we recommend to select Check.

Occurrence of record Retrieval Criteria

Criteria Occurrence
When Record Is Ready It doesn’t happen.
When All Records Are Ready It doesn’t happen.

Webhook notification

This Do does not trigger webhook notifications in the target app.

関連記事