Intro
Box is an online file-sharing and personal content cloud management service for businesses. Use Domo’s Box Analytics connector to pull data on files and folders, users, enterprise events, and single-user events from the Box. The Box Analytics Advanced connector enables you to filter options for ‘File and Folder’ and ‘Enterprise Events’ reports. To learn more about the Box Analytics Advanced API, see (https://developer.box.com/reference/ ). You can connect to your Box Analytics Advanced account in the Data Center. This topic discusses the fields and menus that are specific to the Box Analytics Advanced connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Data Connector.Prerequisites
To connect to your Box Analytics Advanced account and create a DataSet, you need the email address and password associated with your Box account.Connecting to Your Box Analytics Advanced Account
This section enumerates the options in the Credentials and Details panes in the Box Analytics Advanced Connector page. The components of the other panes in this page, including Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a Data Connector.Credentials Pane
Once you have entered valid Box Analytics Advanced credentials, you can use the same account any time to create a new Box Analytics Advanced DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.Details Pane
This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.Menu | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Report | Select the Box Analytics Advanced report you want to run. The following reports are available:
| ||||||||||
| Events To Filter On | Select the event types to be included in the report. | ||||||||||
| Duration | Select the duration for the report (a Single Date, or a Date Range) | ||||||||||
| Retrieve all data or just new data since last successful run | All data will return all the available data. As the last successful run gets data from the last successful run, unless there has never been a successful run, then it will run the All data option once. | ||||||||||
| Use Short Column Names | Select the option for column names length. If you select No , then the long and default column names displays. If you select Yes , then the short column names displays in the report. | ||||||||||
| Start Date | Select the report start date using relative or specific dates. Relative indicates the number of days from today or by selecting a specific date using the date selector. | ||||||||||
| Select Specific Start Date | Select the report date using the date selector. | ||||||||||
| Days back to start from | The number of days back that you want to get the data from (start day). Specify either today or 0, yesterday or 1, or today-7 or 7 to get data for 7 days into the past. | ||||||||||
| End Date | Select the report end date using relative or specific dates. Relative indicates the number of days from today or by selecting a specific date using the date selector. | ||||||||||
| Select Specific End Date | Select the report date using the date selector. | ||||||||||
| Days back to end at | The number of days back that you want to get the data to (end day). Specify either today or 0, yesterday or 1, or today-7 or 7 to get data for 7 days into the past. | ||||||||||
| Report Date | Select the report date using relative or specific dates. Relative indicates the number of days from today or by selecting a specific date using the date selector. | ||||||||||
| Select Specific Date | Select the report date using the date selector. | ||||||||||
| Days Back | The number of days back that you want to get data for. Specify either today or 0, yesterday or 1, or today-7 or 7 to get data for 7 days into the past. | ||||||||||
| Folder ID | The box folder that you want to pull the information for (for example, 342963669). Leave the field blank to pull information for all files and folders. | ||||||||||
| Fields to include | Select the field parameters to be included in the report. | ||||||||||
| Get Image Thumbnail | If you select Yes , then the connector will return the file’s thumbnail. The Field ‘id’ is required. | ||||||||||
| Include Subfolders | If you select Yes , then the connector will return the results for the files in subfolders. | ||||||||||
| Squash Arrays | Select this checkbox to squash arrays. This results in increasing the columns. | ||||||||||