OneDrive is a simple, secure, cloud based file sharing and collaboration services that make it easy for your teams to manage and share your documents and work together in real time on any device. Here are some things you can expect from the OneDrive/Grow integration.
WHAT TO EXPECT
Here are some key things you can expect from the OneDrive integration.
- Size Limits: 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 files up to 50 MB.
- 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. Note: JSON and XML files can be used but that file format, usually in not going to be structured in a way that converts nicely to a table. So converting JSON to a CSV is usually preferred. Your Data Consultant can help you know what to do here.
- 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.
Instead of having set endpoints that you can pull from, OneDrive lets you pull in the files you have hosted on OneDrive. This can be useful if you have exported files from platforms that may not yet have an integration with Grow. Whenever the OneDrive data files are updated, your metrics will automatically update to reflect the change.
Other questions about the OneDrive/Grow integration? Email us at firstname.lastname@example.org or chat in on the site.