Skip to content

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.
CSVOptions for delimiter, character encoding and header row.
JSONL, Parquet, AvroRead according to the file's structure.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inAuthentication, The list of streams to sync
DeveloperAirbyte (community), run inside DataxLand
LicenseELv2
Technical docsConnector 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.

MetricDefinitionUnit
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
Cost of goods soldQuantity 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 marginNet 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 costCurrency
Booked revenueGeneral 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 expensesDebit 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. 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. 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. 3

    Define streams

    Add streams with a name, path pattern and format, then click Test connection.

  4. 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

All data sources →

Connect Microsoft SharePoint and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes