# Box properties

Properties to configure to connect to Box.

## Box connection

Select Box in the list and configure the connection.

## Configuration

Select your engine from the list and set the main and advanced settings.

Main settingsMain settings

| Property | Configuration |
| --- | --- |
| Authentication type | Select one of the following method to connect to Box:<br><br><ul> <li> <span>JWT</span>: specify the credentials in the                                 <span>JWT authentication</span> section to authenticate                              using JSON Web Tokens (JWT).</li> <li> <span>Developer token</span>: specify the credentials in the                                 <span>Developer token</span> field to authenticate using                              a developer token. You can find the developer token in the                                 <span>Configuration</span> tab of your <span>Box                                 Developer</span> console.</li> </ul><br><br><br>For more information about secure authentication to Box, see [Authentication](https://developer.box.com/guides/authentication/) from the official Box<br>documentation. |
| JWT authentication | If you select the JWT authentication method,<br>specify the following parameters that you can retrieve in the Box developer &gt; Configuration &gt; App settings section:<br><br><ul> <li> <span>Client ID</span>: enter the client ID associated with                              your account.</li> <li> <span>Client secret</span>: enter the client secret                              associated with your account.</li> <li> <span>Public key ID</span>: enter the key associated with                              your account.</li> <li> <span>Private key</span>: enter the private key associated                              with your account.</li> <li> <span>Private key passphrase</span>: enter the passphrase                              associated with your account.</li> <li> <span>Enterprise ID</span>: enter the enterprise ID                              associated with your account.</li> <li> <span>Set user ID</span>: toggle the option ON if you want                              to authenticate with a user ID (Box account) rather than an enterprise                              ID (Box admin account) and specify it in the <span>User                                 ID</span> field that appears.</li> </ul> |
| Check connection | Click the Check connection button to validate the<br>connection parameters and verify the connection status. |

After configuring the connection, give it a display name (mandatory) and a description (optional).

## Box dataset

Dataset configurationDataset configuration

| Property | Configuration |
| --- | --- |
| Dataset name | Enter a<br>display name for the dataset. This name will be used as a unique identifier of<br>the dataset in all Talend Cloud apps. |
| Connection | Select<br>your connection in the list. If you are creating a dataset based on an existing<br>connection, this field is read-only. |
| Type | Select the type of dataset you want to create:<br><br><ul> <li> <span>Query</span>: to query the data in your existing                              tables.</li> <li> <span>Table name</span>: to access the table located in your                              Amazon Aurora database using its unique name.</li> <li> <span>Table streams</span>: to access the specific table                              where changes are tracked using its unique name.</li> </ul> |

Main settingsMain settings

| Property | Configuration |
| --- | --- |
| Box folder ID or Path to Box<br>folder | <ul> <li><span>Box folder ID</span> (if <span>Get folder by                                 ID</span> is enabled in the <span>Advanced</span>                              parameters): Enter or select the identifier of the Box folder.                              Example: <span>/All Files/MyFolder/12345678</span></li> <li><span>Path to Box folder</span> (if <span>Get folder                                 by ID</span> is disabled in the                                 <span>Advanced</span> parameters): Enter a name for the                              Box folder you want to create or select an existing one in the list.                           </li> </ul> |
| File name template | Enter a file name to use as a template. |
| Format configuration | From the Content format list, select the format<br>of the file:<br><br><ul> <li> <span>CSV</span>: specify the parameters in the                                 <span>CSV configuration</span> section from the                                 <span>Main</span> and <span>Advanced</span>                              tabs.</li> <li> <span>Avro</span>: no specific parameters required for this                              format.</li> <li> <span>Excel</span>: specify the parameters in the                                 <span>Excel configuration</span> section from the                                 <span>Main</span> tab.</li> <li> <span>JSON</span>: specify the parameters in the                                 <span>JSON configuration</span> section from the                                 <span>Advanced</span> tab.</li> </ul> |
| CSV configuration | If you select the CSV format, specify the<br>following parameters:<br><br><ul> <li> <span>Line separator type</span>: select the type of line                              separator used in the file.</li> <li> <span>Encoding type</span>: select the type of encoding used                              in the file.</li> <li> <span>Set header</span>: toggle the option ON if the file                              contains header lines and specify the number of lines to be skipped in                              the <span>Number of lines</span> field.</li> <li> <span>Field separator type</span>: select the type of field                              separator used.</li> </ul> |
| Excel configuration | If you select the Excel format, specify the<br>following parameters:<br><br><ul> <li> <span>Excel format</span>: select the Excel                              version/format.</li> <li> <span>Sheet name</span>: enter a name for the Excel                              sheet.</li> <li> <span>Set header</span>: toggle the option ON if the file                              contains header lines and specify the number of lines to be skipped in                              the <span>Number of lines</span> field.</li> <li> <span>Set footer</span>: toggle the option ON if the file                              contains footer lines and specify the number of lines to be skipped in                              the <span>Number of lines</span> field.</li> </ul> |

Advanced settingsAdvanced settings

| Property | Configuration |
| --- | --- |
| Format configuration | If you select the CSV format, specify the<br>following parameters:<br><br><ul> <li> <span>Escape character</span>: enter the escape character                              you want to be used. The escape character used by default is                                 <span>\</span>.</li> <li> <span>Quote character</span>: enter the quote character you                              want to be used. The quote character used by default is                                 <span>"</span>.</li> </ul> |
| Format configuration | If you select the JSON format, specify the<br>following parameter:<br><br><ul> <li> <span>Infer all numbers as double</span>: toggle the option                              ON if you want the numbers to be inferred as double in the JSON file.                           </li> </ul> |
| Get folder by ID | Toggle this option OFF to disable the possibility to use Box folder IDs<br>instead of Box folder paths. |