Customize

Export Records With Tables to App

Summary

Export records while updating the field values. Data in a table can be exported.

How to use

Records retrieved by “Retrieve Records by Providing Conditions” and other actions will be exported.

You can also export while updating the field values in the same app, or export as a new record to another app.

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

“Export Each Record to the 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 at 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, Mapping for Table, and Update or Add.

Record

Specify the action used to obtain the source records.

App

Select the app to export to.

It doesn’t matter whether it’s the same app as the source record or a different app.

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 the case of an update, the values of the source record will be maintained, and in the case of addition, the initial values set in the app settings will be applied.

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 in the destination app to output to.

The source also needs a table with the same field codes and the same structure.

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).

At runtime, the conditions will be checked against the “source” table row, not the “destination”.

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 there is only one condition, it can be omitted.

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

Criteria(2)

Criteria(3)

Select when you want to specify the second and third conditions. If there is only one condition, it can be omitted.

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 mapping table is considered to be the table of field codes of the source table.

For example, if app A is for “Record” and the “Target App” is app B, then the “Destination Subtable” is selected from app B. However, if the field code is Table_1, the source mapping table will be app A’s Table_1. In other words, it is mapped from A’s Table_1 to B’s Table_1.

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.

Update or Add

Selecting “Update Existing Record” updates the records of the same value of records as the source.

Selecting “Add New Record” adds a new record instead of overwriting.

The “Update Existing Record” requires the source app to export the records and the “Target App” to be the same.

About detecting competition

Selecting “Update Existing Record” checks conflicts for updates.

Selecting “Add New Record” does not check conflicts.

Webhook Notifications

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

Restrictions

  • You cannot export multiple tables at once.

  • The field codes of the destination table and the source table must be the same. You cannot export to a table with different field codes.

  • 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.