Contents x
    Data Source - kintone
    • 07 Dec 2022
    • Print
    • Dark
      Light
    • PDF
    Contents

    Data Source - kintone

    • Updated on 07 Dec 2022
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    Note

    This is a machine-translated version of the original Japanese article.
    Please understand that some of the information contained on this page may be inaccurate.

    summary

    This page is a help page for setting up data transfer from Cybozu kintone.

    Supported Protocols

    constraint

    • Since it uses the cursor API, specifying limit and offset clauses in the query will result in an error when retrieving data. Anything that matches the query is retrieved.
    • There are restrictions on cursor API, so please check the official page.

    Setting items

    STEP1 Basic settings

    Itemnamerequireddefault
    		valuecontent
    kintone connection informationYes-From the connection information registered in advance, select the one that has the necessary permissions for this transfer setting.
    Please refer to here for how to set the connection information.
    App IDYes-Enter the ID of the kintone app from which you want to collect data.
    If you are an administrator, you can check the ID of each app in the gear → app management at the top of the screen.
    If you want to get it by API, please refer to the official website.
    fieldYes-In the record list of kintone apps, check the field code and type of the data you want to retrieve.
    Learn more about field codes.
    Also, if you want to read it as timestamp type in trocco, specify the format.
    The format value of the kintone DATETIME type is

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

    It has become.

    If you are using kintone's DATE type,

    %Y-%m-%d

    and please.
    Guest Space IDNo-If you are using a guest space, please enter your guest space ID here.
    queryNo-Enter a query to condition the data to be transferred.
    Custom variables can also be used to dynamically determine the setting value during trocco data transfer.
    If not specified, all specified fields in the app are transferred.
    Please refer to the official website for how to write a query.
    Limit and offset clauses cannot be used.
    Was this article helpful?
    What's Next