Customize

Export Each Record With Tables to the App

Summary

Export records while updating the field values. Each record will be saved in the Kintone app during the process. Data in a table can be exported.

How to use

Records retrieved by “Retrieve Records by Providing Conditions” and other actions will be exported to the same app.

It is almost the same as “Export Each Record to the App,” but in “Export Each Record With Tables to the App,” you can include the table in the output.

“Export Records With Tables to App” is almost the same, but there are two differences:

  • “Export Records With Tables to App” saves records in bulk, while “Export Each Record With Tables to the App” saves them one record at a time.
    • As a result, in “Export Each Record With Tables to the App”, if a Webhook for “editing records” is set in the destination app, a Webhook notification will occur. No Webhook notifications will occur when “Export Records to App.”
    • If there are many records, “Export Records With Tables to App” results in fewer Kintone API calls and is faster.
  • In “Export Records With Tables to App”, you can add new records to another app, but in “Export Each Record With Tables to the App”, you can only overwrite records in the same app.
    • However, there is a constraint that the table structure must be the same between the source and destination when exporting to another app with “Export Records With Tables to App.”
「やること」 別アプリへ書き出し テーブルの書き出し Webhook
「レコードを書き出す」 ○ × ×
「レコードを１つずつ書き出す」 × × ○
「テーブル付きでレコードを書き出す」 △ ○ ×
「テーブル付きでレコードを１つずつ書き出す」 × ○ ○

Parameters

Set Record, App, Mapping, Destination Subtable, Condition Field, Criteria, Comparison value, Condition Field, Comparison value, and Mapping for Table.

Record

Specify the action used to obtain the source records.

App

Select the app to export to.

You need to specify the same app as the source record.

Mapping

Set the field value of the record to export.

For detailed descriptions of this parameter, please refer to How to Define Field Mappings.

If the value of the field is left empty, that field will not be outputted instead of outputting an empty value. In that case, the field values of the source record will be maintained.

In the " Value to Set " in the mapping, enter the fields of the app’s record from which the data is exported.

Destination Subtable

Select which table to output to.

Condition Field(1)

To apply “Mapping for Table” to specific rows in a table, select the fields from the “Destination Subtable” that will serve as conditions.

Table rows that do not meet this condition will not have the “Mapping for Table” applied, and all fields of that table row will be copied. It does not mean that the table row will not be output.

To apply “Mapping for Table” to all table rows, please leave the condition empty (no field selected).

Criteria(1)

Select the comparison method between the fields that are the conditions for the target table rows and the comparison values.

Comparison value(1)

Enter the value to compare with the field’s value. When you make it empty, it compares with the empty value.

You can either specify a direct value or use an expression.

Caution is required when using formulas. You cannot reference the field values in the table of the row being compared.

Condition Field(2)

Condition Field(3)

Select when you want to specify the second and third conditions. If you only require one condition, you can omit the others.

You need to select from the same table as the field (1) that serves as the condition for the target table row.

Criteria(2)

Criteria(3)

Select when you want to specify the second and third conditions. If you only require one condition, you can omit the others.

Comparison value(2)

Comparison value(3)

Select when you want to specify the second and third conditions. You can omit these if you only require one condition or want to compare with an empty value.

Mapping for Table

Enter the mapping for the output table.

The source table in the mapping is the same as the “export source table.” Mapping between different tables is not possible.

If the mapping for the field is left empty, instead of writing out an empty value, the field value of the same field code from the source table is copied.

In the " Value to Set " in the mapping, enter the fields of the source table field.

About detecting competition

Conflicts in updates will be checked.

Webhook Notifications

If the Target App is set to send Webhook notifications under the condition of “Editing Records,” notifications will be sent when this action is executed. The same number of notifications will occur as the number of records exported.

Restrictions

  • If the records obtained with the “Retrieve Subtable Row as Record” are specified in the “Record” parameter, the export will not be performed correctly.

  • You cannot export multiple tables at once.

  • The destination table and the source table must be the same. Cannot export records to a different table.

  • When filtering the target table rows based on condition parameters, it is impossible to filter by comparing two fields within the table. To perform conditional branching like this, please use the If function in the mapping for the table.

  • You cannot specify more than four conditions for the target table rows.