Skip to main content

​
Intro

Box Inc. is an online file-sharing and personal cloud content management service for businesses. Use this connector to pull data files from your Box account into Domo. You can retrieve data files using any of the following file types: CSV, JSON, XLS, XLSX, XML, ZIP, and GZIP. This connector pulls data by file name and type. You can connect to your Box Advanced Connector account in the Data Center. This topic discusses the fields and menus that are specific to the Box Advanced Connector connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Connector.

​
Prerequisites

To connect to your Box Advanced Connector account and create a DataSet, you must have the email address and password associated with your Box account.

​
Connecting to Your Box Advanced Connector Account

This section enumerates the options in the Credentials and Details panes on the Box Advanced Connector Connector page. The components of the other panes on this page, Scheduling, and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a Connector.

​
Credentials Pane

Once you have entered valid Box Advanced Connector credentials, you can use the same account at any time to create a new Box Advanced Connector DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector Accounts.

​
Details Pane

Menu Description
File Name Enter the Box file’s name (or a portion of the name) to retrieve. The connector returns the most recently created or modified file which matches the name, based on what you have selected in the Date Field menu.
Match Type Specify whether the retrieved file starts with or contains the name you have entered in File Name .
File Type Select the file type for the data file you want to retrieve.
File name or portion of file name to search for in zip This field appears when you select the File Type as Zip . Enter the name of the zipped file you want to retrieve. Leave blank to retrieve the first zipped file.
Zipped File Type Select the file type for the zipped data file you want to retrieve.
Date Field Specify whether to retrieve a file based on its creation or last modified date. This is useful when multiple files contain the name you entered in File Name .
Would you like to choose file from Folder? Select Yes if you are required to pull files from a specific folder. If No is selected, then it will pull the file based on Date field Parameter.

​
Preview

This section helps you to preview the selected reports and format the cells (column headers, row headers or cross tab). You also have the option to set delimiter and file encoding using the Advanced options. Click the Edit Selection option to format the layout of your file.

​
Format

You can select the layout of your csv file. The following options are available:
  • Column headers: Indicates that your csv data uses a column-based layout (i.e. each column has a header). This option is selected by default. The following options are available under Column headers.
    • Use first row as headers: You can use the first row of your selection as the column headers of your DataSet.
    • Generated Headers: Select this option if your data does not contain any headers and you want Domo to generate the headers for you.
    • Choose a specific range: You can select the specific cell range to be used as column headers.
  • Row headers: Indicates that your csv data uses a row-based layout (i.e. each row has a header). The following options are available under Row headers.
    • Use first column as headers: Use the first row of your selection as the column headers of your DataSet.
    • Generate Headers: Select this option if your data does not contain any headers and you want Domo to generate the headers for you.
    • Choose a specific range: You can select the specific cell range to be used as headers for columns.
  • Crosstab. Indicates that your csv data uses a cross-tab (pivot) layout. The following options are available under Crosstab.
    • Column headers
      • Use first row as headers: You can use the first row of your selection as the column headers of your DataSet.
      • Choose a specific range: You can select the specific cell range to be used as column headers.
    • Row headers
      • Use first column as headers: Use the first row of your selection as the column headers of your DataSet.
      • Choose a specific range: You can select the specific cell range to be used as column headers.

​
Advanced Options

In this pane you configure advanced options for the CSV file you have uploaded.
  • Include batch upload metadata (checkbox) : Select this box to add the batch columns in the data.
  • Keep leading zeros (checkbox) : Select this checkbox to include leading zeros in numeric values like ‘0123’. Note: The connector will parse the values with leading zeroes as text.
  • Delimiter: By default, a comma is used as the delimiter for your CSV file. If desired you can select a different delimiter in the Delimiter menu.
  • File Encoding: By default, UTF-8 encoding is used for your CSV file. If desired you can select a different encoding type in the File Encoding menu.

​
Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Connector.