Export record data to the table in the specified app.
You can export the records that were retrieved using Getting Records by Providing Criteria etc. as rows of table.
The records can be from any other app or from the same app as the target app.
You can connect Retrieve Table Row as Record with this Export Records to Table to achieve a copy of the table data.
If you perform this Do, the field value is changed from its original value, and records are reserved for saving. Updated records are not saved immediately but automatically after all actions in the job are finished. Use Save Modified Record to save the updated records at a different time.
You will need an API Token with the edit and view record permission. Make sure to Set Kintone API Token and set the API Token for the Kintone app.
Set Record, Target Record, Destination Table, Mapping, amd Existing Row.
Select the Action you used to retrieve the source records.
This record is transcribed to a row in the rable based on the mapping.
Select the Action you used to retrieve the target records.
If this record contains multiple lines, action is taken on each record. If this record does not have any rows, nothing is done.
Select the table to export to.
Set the fields (columns) of the table to be written out.
See Field Mapping Description for detailed descriptions of this parameter.
For this mapping, write as follows
=Field Code
so the field can be referenced.
Choose whether to clear the rows originally in the table or append them without clearing them.
If Clear Existing Table Rows is selected, it is cleared even if there is no record to write.
| Criteria | Occurrence |
|---|---|
| When Record Is Ready It doesn’t happen. | |
| When All Records Are Ready It doesn’t happen. |