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.
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.
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 name | indispensable | default value | Contents |
|---|---|---|---|
| Box Connection Configuration | Yes | - | Select Connection Configuration for Box. For more information, see Box's Connection Configuration. |
| folder ID | Yes | - | 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.  |
| file prefix | Yes | - | 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 format | No | - | 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 . bzip2gziptar.gzzipIf 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 format | Yes | CSV/TSV | Specify the format of the input file. For more information, see About input file format settings. |