Overview
Box is a simple, secure, cloud based file sharing and collaboration service that allows you to access your files from anywhere. Here are some things you can expect from the Box/Grow integration.
How to Connect
Before starting, please collect your Box login information.
- Click on the Data tab at the top left of the global navigation. Then click on "Connections" in the Data Library section.
- Click on the blue "Connect" button, search for Box, and click on the logo.
- You'll need your Box username (email address) and password to connect your account to Grow. Once you have entered these in, click the blue Authorize button.
- You will then need to grant Grow permission to access your Box account. Go ahead and click Grant Access to Box.
- Once you've done that, you'll be returned to Grow.
And that's it! You are good to go.
Endpoints
Instead of having set endpoints that you can pull from, Box lets you pull in the files you have hosted on Box. This can be useful if you have exported files from platforms that may not yet have an integration with Grow.
FAQs + Tips and Tricks
API is slow pulling data.
Box’s API limits how many calls to their API a user can make, so pulling data into a warehouse might be a little slow.
Syncing Files
Make sure that the files you want to use in your Grow metrics are synced folders in Box. If they aren't, your metrics won't automatically reflect changes made to the Box file.
One Sheet per Report
For Excel-based files, you can select 1 sheet at a time. So if you have an Excel doc with multiple sheets, you need to create a report for each sheet.
Uniquely Named Headers
If there isn’t a unique column header in your chart, you will have difficulty using Grow’s transform tools as we wont know which columns to filter, group, pivot, etc.
Size Limits
Google places has some size limits on spreadsheets. If you are getting close to any of these limits, you'll get a warning at the top of your spreadsheet (in Google Sheets) telling you which limit you are about to reach. The sheets can have a total of 400,000 cells across all sheets (within one spreadsheet), 256 columns per sheet, 40,000 cells containing formulas, and 100 sheets per workbook.
Supported File Formats
XLS, XLSX, XLSM, and CSV. If you're looking to use JSON or XML files, Grow can pull those in, but we suggest converting to a CSV first.