Export table data to records in another app.
Place the action to set Kintone API Token before the action to Write Table Row to Another app as Record.
Get the record with the destination table. For example, you can use Query to Get Record . Designate this record as the record.
The set of records added as the result value of an action is set, and can be referenced using expressions such as “$=1.” However, only fields set in the mapping can be referenced.
Set Record, Source Table, target app, API Token, Mapping, Whether to Write Empty Row or not, and Whether to reflect immediately.
Select the action that used to retrieve the records with the destination table.
If multiple records exist, processing is performed on each record.
If the record count is zero, nothing is processed. A zero result does not result in an error.
Select the table field from which to write the data.
Select the app to export to.
Specify the API Token to access the target app. Choose from the Set Kintone API Token actions.
The API Token must have Add record permission.
Defines the data to be exported.
See Field Mapping Description for detailed descriptions of this parameter.
By specifying the Field code in the expression for this Mapping, you are referencing a Field in the Source Table.
If you select Do Not Write Empty Rows, if the Destination table row is empty, the records for that row are not written.
The criteria are not whether the record is empty, but whether the Destination table row is empty.
Here, “empty rows” means “all columns (Fields) are empty, unselected.” Note that if a Field has an Initial Value, it will not be considered empty if it is still filled with that Initial Value. Fields that cannot be unselected, such as radio Button Names, are always written out, as they cannot be empty. However, calculated Fields, even if they have Values, are ignored.
If you set it to Never Write Empty Lines, but depending on what Mapping is configured, There is still a possibility that records with no data will be written out.
If you select Do not propagate immediately (aggregate later), the action will not be immediately reflected in the Kintone app. It will be a movement to save to Kintone app after accumulating some amount.
Reflect Immediately reflects the record addition to the Kintone app as soon as the action is executed. If you want subsequent actions to get the records back from Kintone, choose Reflect Immediately.
| Criteria | Occurrence |
|---|---|
| “When record Row Is Ready” | |
| “When All record Rows Are Ready” |
This Do does not trigger webhook notifications in the target app.