Contents x
    Data Source - kintone
      • Print
      • PDF
      Contents

      Data Source - kintone

        • Print
        • PDF
        Article summary

        summary

        Help page for ETL Configuration of Data Setting from Cybozu's kintone.

        constraints

        • Because the cursor API is used, specifying a limit or offset clause in the query will result in an error when retrieving data. Any matches to the query are retrieved.
        • Please check the official page for cursor API restrictions.

        Setting items

        STEP1 Basic settings

        item nameindispensabledefault valueContents
        kintone Connection ConfigurationYes-Select the previously registered Connection Configuration that has the necessary permissions for this ETL Configuration.
        Click here to learn how to set up Connection Configuration .
        App IDYes-Enter the ID of the kintone application from which you want to retrieve data.
        If you are an administrator, you can check the ID of each app by going to Gear → Manage Apps at the top of the screen.
        Please refer to the official website to obtain the data via API.
        fieldYes-In the record list of the kintone application, check the field code and type of the data you wish to retrieve.
        For more information on field codes, please click here.
        Also,
        The format value of the DATETIME type in kintone is

        %Y-%m-%dT%H:%M:%S%z

        The following is a summary of the results of the survey.

        If you are using kintone's DATE type

        %Y-%m-%d

        Please use the following formula.
        If the format is not specified, it is determined as %Y-%m-%dT%H:%M:%S%z.
        If all fields are unspecified, all available fields are retrieved.
        Guest Space IDNo-If you are a guest space user, please enter your guest space ID here.
        queryNo-Enter a query to condition on the data to be transferred.
        Custom Variables can also be used to dynamically determine the value of a setting during ETL Configuration of TROCCO's data.
        If not specified, all fields specified in the app will be transferred.
        For more information, please refer to How to Write Queries in the kintone API documentation.
        Note that the limit and offset clauses cannot be used.

        STEP1 Detailed settings

        Click on Advanced Settings to display the configuration items.

        item namedefault valueContents
        Transfer by table rowsvalidityWhen enabled, tables (formerly subtables) are transferred by table (formerly subtable) rows rather than by records.
        In this case, each key of the JSON in the table (formerly subtable) is expanded into a column.

        STEP2 Column Setting

        If all fields are unspecified and fields are retrieved automatically, the DATE and TIME types in kintone will be inferred to be string types in the Column Setting in ETL Configuration STEP 2.
        If you want to read in timestamp type, select timestamp asthe data type and enter the following in the date/time format, respectively.

        • For DATE type: %Y-%m-%d
        • For TIME type: %H:%M
        Was this article helpful?
        What's Next