Files and storage
Connect Microsoft SharePoint to DataxLand
The Microsoft SharePoint connector reads files in SharePoint or OneDrive for Business document libraries (CSV, JSONL, Parquet, Avro) by path pattern, and combines the matching files into tables in the workspace warehouse. Businesses on Microsoft 365 often keep exports from accounting and sales on SharePoint; connect once and new files are read on a schedule. Si proposes a mapping from a masked data sample to the standard model, for example booked revenue, cost of goods sold and booked expenses.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with Microsoft SharePoint
- Refresh dashboards automatically from the regular exports your accounting software drops on SharePoint.
- Combine internal order files with marketplace and ad data.
- Grant read access by folder instead of emailing files around.
What data you get
Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.
| Stream (table) | Contents |
|---|---|
| (stream you name) | Each stream has a name, a path pattern (glob) and a format; all files matching the pattern are combined into one table. |
| CSV | Options for delimiter, character encoding and header row. |
| JSONL, Parquet, Avro | Read according to the file's structure. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | Authentication, The list of streams to sync |
| Developer | Airbyte (community), run inside DataxLand |
| License | ELv2 |
| Technical docs | Connector documentation ↗ |
Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.
Metrics computed from this source
Real definitions from the analytics packs; dashboards and Si share them.
| Metric | Definition | Unit |
|---|---|---|
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
| Cost of goods sold | Quantity times unit cost on the order date (half-open validity interval). SKUs without a cost count as 0; see COGS coverage. Returned lines do not reverse their COGS. | Currency |
| Contribution margin | Net revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return cost | Currency |
| Booked revenue | General ledger revenue: credit postings minus debit postings on revenue accounts (account 511), net of revenue deductions (account 521). Excludes financial income and other income. | Currency |
| Selling and administrative expenses | Debit postings minus credit postings on selling expense (account 641) and general administrative expense (account 642) accounts; under Circular 133 these are accounts 6421, 6422. | Currency |
Connect Microsoft SharePoint in 4 steps
- 1
Register an app
In Microsoft Entra ID, register an app with file read permissions and get the Tenant ID, Client ID and Client Secret (plus a refresh token or user principal name, depending on the authentication method).
- 2
Add the SharePoint source
In the workspace choose Add source, find Microsoft SharePoint, choose the authentication method, and enter the credentials, Site URL and Folder Path.
- 3
Define streams
Add streams with a name, path pattern and format, then click Test connection.
- 4
Review and build
Si proposes a mapping to the standard model; you approve, then build.
Limits and caveats
- A Microsoft 365 admin must grant permissions to the app; DataxLand does not run the Microsoft sign-in.
- The metrics on this page are examples; the actual metrics depend on what your files contain.
- Each refresh reads only new or recently modified files.
- A community Airbyte connector (ELv2) run inside DataxLand; requires the Starter plan or above.
Frequently asked questions
Can it read Excel files on SharePoint?
This page covers CSV, JSONL, Parquet and Avro only; for .xlsx, use DataxLand's Excel source or also save a CSV copy.
Are my app credentials safe?
The client secret is encrypted when saved and never shown again; limit the app's permissions to the sites you need.
Does it change files on SharePoint?
No. The connector is read-only.
Dashboard templates that use this source
Connect Microsoft SharePoint and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes