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.
WHAT TO EXPECT
Here's what you can expect from the Box integration.
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.
Make sure your sheets are formatted correctly.
Find some helpful tips on spreadsheet formatting in Grow here.
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.
Most files must be smaller than 15 MB in order to successfully pull them into Grow. Under some extenuating circumstances, our support teams can make exceptions for Box files up to 50 MB. You can learn more here.
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 dataset
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 dataset for each sheet.
Uniquely Named Headers
If there isn’t a unique column header, we can’t add the data to your dataset.
The Box integration is unlike most other integrations in that there aren't any specific endpoints to choose from after connecting. You'll simply choose the Box files that you want to use to create your metrics, and Grow will pull data directly from the source.
As we're sure you can imagine, this is a useful feature for several reasons. Many Grow users store exported .csv files from platforms that may not yet have an integration with Grow in their synced Box folders, so you don't have to worry about missing any of your important data from metrics in Grow. Whenever the Box data files behind your metrics are updated, the Grow app will automatically update to reflect the change.
Questions about the Box/Grow integration? Email us at email@example.com or chat in on the site.