When you want to upload, download, or delete objects in Box or write data to CSV files in Box, specify a Box connection while configuring the target in a synchronization task.
1In Data Integration, click New > Tasks.
2Select Synchronization Tasks, and click Create to create a synchronization task.
The Definition tab appears.
3Configure the following fields on the Definition tab:
Field
Description
Task Name
Name of the synchronization task.
The name of a synchronization task must be unique within the organization. A synchronization task name can contain alphanumeric characters, spaces, and the following special characters:_ . + -. A synchronization task name is not case sensitive.
Description
Description of the synchronization task. Maximum length is 255 characters.
Task Operation
Specify the target task operation. Choose one of the following options:
- Insert for the upload, download, and write data to CSV file Box object operations.
- Delete to delete Box objects.
4Click Next to specify the source connection. Choose one of the following options:
- Select a flat file connection that points to the location of the upload.csv, download.csv, or delete.csv files.
- Select a source connection that connects to the source from which you want to read data from.
5Select Singleas the source type.
6Specify the Box source object. Specify one of the following options:
- The upload.csv file to upload Box objects.
- The download.csv file to download Box objects.
- The delete.csv file to delete Box objects.
- The name of the source object that you want to read data from and write data to a CSV file in Box.
7Click Next to specify the target connection and target object.
8Select a Box connection.
9Specify the Box object. Specify one of the following options:
- Upload to upload Box objects.
- Download to download Box objects.
- Delete to delete Box objects.
- The name of the CSV file to which you want to write the source data.
10Click Next to configure the field mappings. Perform any of the following steps based on your requirements.
aClick Edit Types in the Source column to edit the precision and scale of the source objects. Note that this option is not available for all source types.
bClick Automatch to match source and target fields with similar names.
cClick Edit Types in the Target column to edit the data type, precision, and scale of the target object.
dSelect a source field and drag it to the target field to map the source and target fields. Repeat for all the fields that you want to map.
eClick the Add or Edit Expression icon to define a field expression to transform data.
fClick Validate Mapping to validate all the field mappings.
gClick Clear Mapping to clear all the field mappings.
11Click Next to configure a schedule and advanced options. Perform any of the following steps based on your requirements.
aClick Run this task on schedule and specify the schedule you want to use.
bConfigure the email notification options.
cConfigure advanced options for the task.
dConfigure the advanced source and target properties.
eSpecify the execution mode.
12Click Save and then Finish.
13From the Explore page, select the task, and click Actions > Run.
In Monitor, you can monitor the status of the logs after you run the task.