# Box Export Integration

[Learn more about Box Import Integration.](/int/box-import-integration)

Export Treasure Data job results directly to your Box account.

Continue to the following topics:

Prerequisites

- Basic knowledge of Treasure Data
- Box cloud storage account


# Use the TD Console to Create Your Connection

You can use the Treasure Data Console to configure your connection.

## Setting Up a Connection with Box Account

1. Open the **TD Console**.
2. Navigate to the **Integrations Hub > Catalog**.
3. Click the search icon on the far-right of the Catalog screen, and enter **Box**.
4. Hover over the Box connector and select **Create Authentication**.![](/assets/box.504c996c6e5e04a8cd4fe277d5dac801f853528db614581055d3a60c29328e41.0c422bf5.png)
5. Enter your OAuth token or select **Click here** to authorize the connection with Box.


![](/assets/create_new_connection.18e52df4d747e34ad9478419c5ee33abd8453bb725c786059c83343086879e0c.0c422bf5.png)

You are redirected to Box to login if you haven't logged in yet, or to the consent page to grant access to Treasure Data from your Box account.

For the domain [https://console.treasuredata.com](https://console.treasuredata.com/), it shows:

![](/assets/mceclip0.5d9fd19b922965e4943218806404f8ee010e13fb7334fe810598b45884c7e266.0c422bf5.png)

For [https://console.treasuredata.co.jp](https://console.treasuredata.co.jp/)

![](/assets/mceclip1.6e6f42de60b14fa5347f2a7ed87c2893287103d5e9a0a22c8a49fd83820bc0c7.0c422bf5.png)

Select **Grant access to Box** and you are redirected back to the Treasure Data Connection screen.

Choose the Box connector again, go to the OAuth connection field. You see an OAuth connection with your account name in the dropdown list.

Choose the account you want to use and proceed to create the connection.

![](/assets/oauth_created.1675cbf114220075c935db6fd650ac575941db99062ea20aa4152bcc29b0d13b.0c422bf5.png)

Select **Continue** to go to the Details view.

![](/assets/2018-10-16_1241.0be2431abf4a0527a386768400d2ce3a12b08c698d6ee6e86f31ae284b525fb3.0c422bf5.png)

Enter a name for the connection then select **Done** to finish.

OAuth (and the only authentication) is only supported in treasuredata.com and its subdomains.

## Configure Output Results to the Data Connection

In this step, you create or reuse a query. In the query, you configure the data connection.

Go to the Treasure Data Console query editor page.

Access the query that you plan to use to export data.

Compile the query, if you need to.

## Specify the Result Export Target

Select **Export** **Results**.

Type the connection name in the search box to filter and select your Box connection.

Edit all the information.

![](/assets/screenshot-2025-06-26-at-10.02.20.495f9cea162e86325ed0abb9d912ce9dd282fb6139cbcf698a1bc96be3ef691a.0c422bf5.png)

Specify the parameters:

- **Export To** (Required) Available options:
  - Existing File.When selected, you must specify the File ID.
  - New File. When selected, you must specify the File Name and Folder ID.
- **File Name** The exported file name without extension. For example, `Result_1810212`
- **Folder ID** The Box Folder where exported file is to be stored.
- **File ID** Existing Box File ID.
- **Format** Specify the result file format: CSV or TSV
- **Encoders** Indicate whether the result is to be compressed or not. Available options: None, gz, and bzip2, encryption PGP
- **Public Key** The public key is used to encrypt the file before being uploaded
- **Key Identifier**Specifies the Key ID of the encryption subkey used to secure the file. The master key is excluded from the encryption process.
- **Amor**  Whether to use ASCII armor or not
- **Compression Type**
  - Defines the compression algorithm used to compress the file, which will be compressed before encryption for uploading to the Box server.
  - **Note: Please ensure that you compress your file before encrypting and uploading. When you decrypt it, the file will return to a compressed format such as .gz or .bz2.**
- **Header line** If selected, the exported data will have the column name as the header line.
- **Null String** Use this value to represent NULL values. Available options:
  - Default.If selected, an empty string **''** is used to represent the Null value for file format CSV, and \N is used for the TSV format.
  - Empty string
  - \N NULL
  - null
- **End-of-line character** The character at the end of lines. Available options are CRLF, LF, and CR
- **Quote Policy** Available options:
  - ALL. If selected, all values are enclosed by double quotes ("").
  - MINIMAL. If selected, any value that contains an embedded quote (") is presented with a consecutive pair of quotes (""). The MINIMAL quote policy is applied to CSV
  - NONE. If selected, no escape for embedded quote is applied. By default, NONE is applied to TSV file format
- **Max Retries** When an error occurs due to a Box server error or network error, the number of retries attempted before aborting the upload.
- **Retry Timeout**The upper limit time for a retry, measured in seconds.


## Execute the Query

Save the query with a name and run, or just run the query.

After the query has run successfully, the query result is automatically imported into the specified Container destination.

# Frequently Asked Questions

### Why did I get \ (backslash) characters in the final result?

When the data (value) contains a quote (") in a CSV file or a Tab in a TSV file and when the Quote Policy is set to NONE, then the character might incorrectly escape the data and cause the problem. To resolve this, try to set the Quote Policy to MINIMAL or ALL.