SharePoint
SharePoint connections give you access to the files stored in your organization’s SharePoint sites.
Source Setup
Etleap uses OAuth to authenticate with SharePoint.
The connection setup page will forward you to Microsoft to authenticate and authorize the Etleap application. Etleap will ask for the Sites.Read.All, User.Read and offline_access Microsoft Graph permissions .
Permissions
When you authenticate with SharePoint, Etleap inherits the file access permissions of the authenticated user. This means Etleap can only access the sites, document libraries and files that the authenticated user has permission to read.
You may also use a service account with limited access to authenticate. This account requires read access to the files you want Etleap to access and nothing else.
None of the permissions above require administrator consent by default, but your tenant’s policy may still require an administrator to approve them.
What Data is Available?
The file picker’s root contains the sites you can access. Open a site to see its document libraries, and open a library to browse its folders and files. There are two ways to choose what a pipeline ingests:
- Match by pattern: pick a folder and a filename regex for the file names you want.
- Select files: pick individual files, or pick a folder to ingest everything under it, including files added later.
Your selection must be inside a document library. A site on its own, or the list of sites, cannot be ingested.
Etleap can ingest .csv, .tsv, .json, .jsonl, .xls and .xlsx files from SharePoint, a subset of the File Types Etleap supports. Files of any other type don’t appear in the file picker.
Key Considerations
- A pipeline covers a single site and document library. Individually selected files must all come from the same library.
- A selected folder and its subfolders can contain at most 50,000 items.
- Etleap identifies files by their display-name path, so renaming a site or a document library will break the pipeline.
- Etleap can’t tell apart two sites, or two libraries within a site, that share a display name.
- Sites with a
/in their name don’t appear in the file picker.
How Data is Updated
SharePoint pipelines always use Update Mode, so the Update Method options aren’t offered. The first extraction reads every file in the selection, and each later extraction reads only the files that changed since the previous one. Etleap re-reads a changed file in full and updates its rows in place.
Etleap supplies the primary key itself, so you don’t have to choose one. Every row gets three columns identifying where it came from, and _file and _line together are the key.
| Column | Description |
|---|---|
_file | The full path of the file, e.g. /Marketing/Documents/2026/orders.csv. |
_line | The line number within the file, starting at 1. |
_modified | The file’s last modification time. |
Deleted Data
Etleap doesn’t capture deletes, so rows that no longer exist in the source stay in the destination. Deleting a file leaves its rows behind, and shortening a file leaves the rows past its new end behind. Because rows are keyed by _file and _line, removing a row from the middle of a file shifts the rows below it up by one line, which leaves the file’s last row in the destination twice.
To avoid potential data integrity issues that result from changing file sizes, we recommend refreshing your pipeline(s) if a file that it ingests gets updated with removed rows or an altered row order.