--- title: "Data Destination - kintone" slug: "data-destination-kintone" updated: 2024-09-19T08:16:46Z published: 2024-09-19T08:16:46Z canonical: "documents.trocco.io/data-destination-kintone" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # Data Destination - kintone ## summary Help page for ETL Configuration of Data Setting to Cybozu's kintone. ## constraints - There are limitations of the kintone API. - For more information, please refer to [the kintone API official documentation - (Bulk record retrieval)](https://developer.cybozu.io/hc/ja/articles/360029152012-%E3%83%AC%E3%82%B3%E3%83%BC%E3%83%89%E3%81%AE%E4%B8%80%E6%8B%AC%E5%8F%96%E5%BE%97)**Limitations of**[creating a cursor](https://developer.cybozu.io/hc/ja/articles/360029152012-%E3%83%AC%E3%82%B3%E3%83%BC%E3%83%89%E3%81%AE%E4%B8%80%E6%8B%AC%E5%8F%96%E5%BE%97). - For each ETL Configuration, an application must be created on the kintone side. - It is not possible to automatically create an application from the TROCCO side. - If `the` transfer mode is `upsert` and the update key contains an empty record, the record will be newly added. - Even if a record with an empty key exists in Data Destination, the row will not be updated. ## supplementary information Regarding Column Setting in ETL Configuration STEP2 Enter the **field code in** the kintone application **for** the **column name in** ETL Configuration STEP 2 "Column Setting". ## Setting items ### STEP1 Basic settings | item name | indispensable | Contents | | --- | --- | --- | | kintone Connection Configuration | Yes | From the previously registered [Connection Configuration of kintone](/docs/connection-configuration-kintone), select the one that has the necessary permissions for this ETL Configuration. | | App ID | Yes | Enter the kintone application ID to which the data Destination will be sent. The application ID can be found at the URL on the application screen. ![data-destination-kintone-2024-08-29-5-57-0](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-destination-kintone-2024-08-29-5-57-0.png) If you want to use the API, please refer to [the kintone API official document - Obtaining the ID of the app](https://developer.cybozu.io/hc/ja/articles/202166300-%E3%82%A2%E3%83%97%E3%83%AAID%E5%8F%96%E5%BE%97). | | Guest Space ID | No | If you are using a guest space, please enter the guest space ID. | | transfer mode | Yes | Specifies the transfer mode.`insert`: Transfers a record to Data Destination.`update`: Update records with matching update keys.`upsert`: If there is a record with a matching update key, update it; otherwise, transfer a new record. | | update key | Yes | Enter when `update` or `upsert is` selected `in` transfer mode. Enter the column name of the field with unique values. You can also specify a record ID. In that case, enter `$id.` Note that the update key must match any column name in the STEP2 Column Setting. | ### STEP1 Detailed settings Click on **Advanced Settings** to display the configuration items. | item name | default value | Contents | | --- | --- | --- | | table transfer key | - | Enter if you want to transfer records to a table (formerly a subtable) in the application. For details, please refer to the [case where you want to update a table (formerly: sub-table) in the application](/docs/en/data-destination-kintone#%E3%82%A2%E3%83%97%E3%83%AA%E5%86%85%E3%81%AE%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E6%97%A7%E3%82%B5%E3%83%96%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%82%92%E6%9B%B4%E6%96%B0%E3%81%97%E3%81%9F%E3%81%84%E5%A0%B4%E5%90%88). | | Number of records to be updated in one request | 100 | Enter the number of records to be updated at one time. | | Update processing when NULL is included | Update with NULL | You can set how to handle `null` values contained in ETL Configuration data when updating records on kintone. Please select from the following - **Update with NULL** - `NULL` values in the transferred data **will be reflected in the** data on kintone to be updated. - **Skip Update** - `NULL` values in Data Source data **are not reflected in the** data on kintone to be updated **, and the original values are retained**. Note that this item Setting is not applied to records newly appended on kintone, and `null` values of ETL Configuration data will be added as `null` values. | ### STEP2 Output Option You can configure detailed settings regarding columns. | (data) item | Contents | | --- | --- | | column name | Enter any **column name** in ETL Configuration STEP2 **Column Setting**. | | field code | Enter the field code of the Data Destination kintone application. | | data type | Select this option if you want to explicitly specify the data type of a field. **List of available types** `SINGLE_LINE_TEXT``MULTI_LINE_TEXT``RICH_TEXT``NUMBER``CHECK_BOX``RADIO_BUTTON``MULTI_SELECT``DROP_DOWN``DATE``TIME``DATETIME``LINK``SUBTABLE` | | time zone | You can enter the time zone to be used during the deployment if you want to transfer with `DATE` or `TIME` type. | | Columns to sort rows in table | If you want to transfer by `SUBTABLE` type, you can register the values in a table (formerly known as a subtable) with the values sorted in ascending order. For details, please refer to the [case where you want to update a table (formerly: sub-table) in the application](/docs/en/data-destination-kintone#%E3%82%A2%E3%83%97%E3%83%AA%E5%86%85%E3%81%AE%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E6%97%A7%E3%82%B5%E3%83%96%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%82%92%E6%9B%B4%E6%96%B0%E3%81%97%E3%81%9F%E3%81%84%E5%A0%B4%E5%90%88). | ## If you want to update a table (formerly a subtable) in the application You can also transfer records to a table within the application (referred to as **a sub-table** from this description onward **)**. In the following, **fields** are distinguished by hierarchical structure. - Fields directly below the application - Fields in subtables A single transfer can be used to transfer to fields directly under the application and to update fields in sub-tables at once. Restrictions on transfers to sub-tables - Even if `update or``upsert is` selected as the transfer mode, data transfer to the sub-table is always **a wash**. That is, the records in the existing sub-tables are replaced by the newly transferred data after each transfer. - There must be at least one **field** directly under the app **that consists of unique values**. ### Update sub-tables using 2D tables #### Transfer data to be prepared Prepare a table in which the values of **the fields immediately below the app** are flattened and joined in a way that the records of the **fields****in the sub-tables** are of minimum granularity. Specific examples will be used to illustrate this point. - Directly below the application: A field **called****Case ID** and **Company Name** exists. - Sub-table: A sub-table **called Activity History** with fields **called****Activity Date** and **Activity Details** In such a case, prepare a table with four columns as follows Note that the transfer data need not include elements related to the subtable itself ( **activity history** in the above example). ![data-destination-kintone-2024-08-29-5-57-1](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-destination-kintone-2024-08-29-5-57-1.png) #### Table ETL Configuration STEP1 Detailed ETL Configuration Table Forwarding Keys Enter the appropriate column name in **the field directly below the app that consists of unique values**. The records of the subtables are grouped based on the column values specified here. The value entered in this section must match any column name in the Column Setting to be set in the next step. ![data-destination-kintone-2024-08-29-5-57-2](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-destination-kintone-2024-08-29-5-57-2.png) #### Column Setting for ETL Configuration STEP2 Enter the **column names** as follows, respectively - Fields directly under the app: **Field code of the corresponding field** - Field in a sub-table: **Field Codes in Sub-Tables. Field Codes for Fields in Sub-Tables** " - `.` must be included in the entry. ![data-destination-kintone-2024-08-29-5-57-3](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-destination-kintone-2024-08-29-5-57-3.png) #### ETL Configuration STEP2Column Settings for Output Option By adding a Column Setting, you can explicitly specify the data type for each field. For **Column Name,** enter the **column name** specified [in Column Setting in ETL Configuration STEP 2](/docs/en/data-destination-kintone#%E8%BB%A2%E9%80%81%E8%A8%AD%E5%AE%9Astep2%E3%81%AE%E3%82%AB%E3%83%A9%E3%83%A0%E5%AE%9A%E7%BE%A9). Note that for fields in sub-tables, the `.` must be included in the field. It is also possible to transfer data to a sub-table by sorting in ascending order based on the value of some field. If you want to sort and ETL Configuration, please add column configuration as follows - Column Name: From the field in the sub-table specified in [Column Setting in ETL Configuration STEP 2](/docs/en/data-destination-kintone#%E8%BB%A2%E9%80%81%E8%A8%AD%E5%AE%9Astep2%E3%81%AE%E3%82%AB%E3%83%A9%E3%83%A0%E5%AE%9A%E7%BE%A9), enter the " **Field Code of Sub-Table** " part of the **column name** (the part before `the .` ) of the column name from the field in the sub-table specified in the column definition in STEP 2. - Field Code: Enter the field code for the relevant sub-table. - Select data type: **SUBTABLE**. - Columns to sort rows in table: please enter the **field code of the field in** any **subtable**. - In this section, " **Field codes for sub-tables .** " ( `.` ) is not required in this section. ![data-destination-kintone-2024-08-29-5-57-4](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-destination-kintone-2024-08-29-5-57-4.png) When an ETL Job is executed based on the above Job Settings, data will be transferred as follows ![data-destination-kintone-2024-08-29-5-57-5](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-destination-kintone-2024-08-29-5-57-5.png) If you check the contents of the case ID of 1, you will see that the sub-tables have also been updated. ![data-destination-kintone-2024-08-29-5-57-6](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-destination-kintone-2024-08-29-5-57-6.png)