Data Source - Box
    • PDF

    Data Source - Box

    • PDF

    Article summary

    summary

    Help Page for ETL Configuration of Data Setting from Box.

    constraints

    Some of the Box API tokens, codes, and URLs have an expiration date.
    See Token and URL Expiration Dates for more information.

    Expiration date of access token

    An access token is used to retrieve data from the Data Source Box.
    The access token is valid for 60 minutes.

    If the data to be transferred cannot be retrieved from the Data Source Box within the expiration date, the relevant data will not be transferred.
    In the unlikely event that data acquisition is not completed within the expiration date, please take measures such as reducing the size of the data to be transferred.

    Renewal token expiration date

    When using Connection Configuration with OAuth 2.0 authentication selected as the authentication method, the update token is used to retrieve data from the Data Source Box.
    Renewal tokens are valid for 60 days from the creation or use of the renewal token.

    The renewal token will expire if no data transfer has been made for 60 days since the Connection Configuration was created or the last data transfer was made.
    If your renewal token has expired, please re-authenticate your Box account from the Edit Connection Configuration screen.

    Setting items

    STEP1 Basic settings

    item nameindispensabledefault valueContents
    Box Connection ConfigurationYes-Select Connection Configuration for Box.
    For more information, see Box's Connection Configuration.
    folder IDYes-Enter the folder ID.
    Go to the folder to be transferred from the administration screen of Box, and obtain the folder ID from the URL.
    ds_box_001
    file prefixYes-Enter the prefix of the file name to be retrieved.
    Note that only file data directly under the folder specified by the folder ID (first level) can be retrieved.
    decompression formatNo-If the Data Source data is compressed, it can be decompressed and transferred.
    The following decompression formats are supported Select according to the compression format of the data to be transferred.
    If the data to be transferred is an uncompressed file, do not select the decompression format .
  • bzip2
  • gzip
  • tar.gz
  • zip

  • If you change the decompression format later, be sure to perform Automatic Data Setting.
    Relative path after decompression (regular expression)No-This can be entered when zip or tar.gz is selected as the decompression format.
    If you include a path separator, escape it using a backslash ( ⌘).
    Input file formatYesCSV/TSVSpecify the format of the input file.
    For more information, see About input file format settings.

    Was this article helpful?