On This Page

1 Overview
2 Create Connection | User Interface
3 Features and Limitations
- 3.1 Files and Folders
  - 3.1.1 Check Out
  - 3.1.2 Date Preservation
  - 3.1.3 Enterprise Keywords
  - 3.1.4 File Extensions
  - 3.1.5 Invalid Characters and Spaces
  - 3.1.6 Okta
  - 3.1.7 Restricted File/Folder Names
  - 3.1.8 URLs
  - 3.1.9 Versioning
4 Create Connection | REST API
- 4.1 Create a Basic Connection
5 SharePoint Connection | API Job Configuration Examples
6 SharePoint Connection Notes

Overview

DryvIQ connections to SharePoint 2013, 2016, and 2019 on-premise platforms can be made by using any valid SharePoint user account with applicable permissions to access content. There are several ways to transfer content, this document outlines each of those situations and how to configure them.

Microsoft SharePoint supported versions:

2013
2016
2019

Create Connection | User Interface

Select Connections > Add connection.
Select Microsoft SharePoint as the platform on the Add connection modal.
Enter the connection information. Reference the table below for details about each field.
Select Test connection to ensure DryvIQ can connect using the information entered.
You will see a "Connection test succeeded" message on the Add connection modal when DryvIQ establishes connection. (If you don't see this message, verify the information you entered.)
Select Done.

Add connection modal - Microsoft SharePoint

Field	Description	Required

Field	Description	Required
Display As	Enter the display name for the connection. If you will be creating multiple connections, ensure the name readily identifies the connection. The name displays in the application, and you can use it to search for the connection and filter lists. If you do not add a display name, the connection will automatically be named using the SharePoint URL. For example, Microsoft SharePoint (http://sharepoint.url.com/). If it will be useful for you to reference the connection by account, you should use the default name.	Optional
URL	Enter the URL for SharePoint including the site collection where the target document library exists.	Required
User Name	Enter the SharePoint username. It can coincide with the Active Directory Universal Principal Name (UPN).	Required
Password	Enter the password for the username added in the previous field.	Required
SSO Provider	Only Active Directory Federation Services (ADFS) is supported as an SSO provider for SharePoint at this time.	Optional
SSO URL	Enter the URL of the configured SSO provider.	Optional
Authentication type	Select the authentication method the server uses: Basic, Forms, or NTLM. You can select the Detect automatically option to have DryvIQ automatically detect the authentication type when testing the connection. This is the default selection.	Optional

Connection Test Succeeded

Features and Limitations

Platforms all have unique features and limitations. DryvIQ’s transfer engine manages these differences between platforms and allows you to configure actions based on Job Policies and Behaviors. Utilize the Platform Comparison tool to see how your integration platforms may interact regarding features and limitations. For more information on SharePoint restrictions, see Microsoft’s official documentation.

Features and limitations may vary between SharePoint versions. Refer to Microsoft's official documentation for your specific version of SharePoint for a full list of supported features and limitations.

Files and Folders

Below is list of SharePoint’s supported and unsupported features as well as additional file/folder restrictions.

Supported Features	Unsupported Features

Supported Features	Unsupported Features
Version preservation	Mirror lock ownership
Timestamp preservation
Author/Owner preservation
File lock propagation
Restricted types
Account map
Group map
Permission preservation
User impersonation
Metadata map
Tags map

Other Features/Limitations	SharePoint 2013	SharePoint 2016	SharePoint 2019

Other Features/Limitations	SharePoint 2013	SharePoint 2016	SharePoint 2019
File size maximum	2 GB	2 GB	15 GB
Path length maximum	260	260	400
Segment path length	128	128	260
Invalid characters (See Invalid Characters and Spaces below)	\| # { } % & \ ~ + / : * ? < > \\ “	\| # % \ \\ / : * ? < > “	\| \ \\ / : * ? < > "
Restrictions (See Invalid Characters and Spaces below)	Consecutive periods Leading tildes Leading periods Trailing periods before extension Trailing periods after extension Leading whitespace Trailing whitespace before extension Trailing whitespace after extension Non-printable	Leading tildes without an extension Trailing periods after extension Leading whitespace Trailing whitespace after extension Non-printable	Trailing periods after extension Leading whitespace Trailing whitespace after extension Non-printable

Check Out

DryvIQ does not support Libraries that have Require Check-out enabled.

Date Preservation

Date preservation works with SharePoint if you are using author-preservation.

Enterprise Keywords

SharePoint doesn't allow duplicate Enterprise Keywords. The longest string allowed in an Enterprise Keyword is 255 characters.

File Extensions

SharePoint restricts certain file extensions in different versions. Click here for the complete list.

Invalid Characters and Spaces

DryvIQ verifies file and folder names to identify unsupported characters based on the platform. It then replaces invalid characters with an underscore (_) so the files and folders can be transferred.

The logic includes leading and trailing spaces in file and folder names. DryvIQ replaces the space rather than trimming it because trimming the space could cause duplicate file names. Adding the underscore ensures the name remains unique.

Okta

DryvIQ does not support Okta with SharePoint.

Restricted File/Folder Names

The following are restricted file and folder names:

_vti_test
_w
_t

The following are restricted folder names:

Test_files

Folder names cannot end with the following:

.files	_elemei
_files	_ficheiros
_Dateien	_arquivos
_fichiers	_dosyalar
_bestanden	_datoteke
_file	_fitxers
_archivos	_failid
_filer	_fails
_tiedostot	_bylos
_pliki	_fajlovi
_soubory	_fitxategiak

URLs

The transformation of URLs into SharePoint can sometimes increase the overall URL length, which can cause either 400 or 414 URL failures. (Spaces are the primary way this can happen.) DryvIQ recommends you remove the spaces or shrink the URL length to resolve this error.

Versioning

Versioning is supported if versioning is enabled on the library.

SharePoint 2019 supports version deletes.

Create Connection | REST API

Create a Basic Connection

Create a basic SharePoint connection at the following endpoint.

GET {{url}}v1/connections/platforms/SharePoint/new

Create a Connection with Applicable Authorization Type

Verify your instance support forms. In rare instances, there can be a misconfiguration with SharePoint that can falsely report that Forms are supported. If you are experiencing connection issues with SharePoint, you may need to configure for ntlm authentication for the auth_type parameter.

{
  "name": "SharePoint 2016",
  "platform": {
    "id": "sharepoint"
  },
  "auth": {
    "uri":"http://url.com",
    "username":"USER",
    "password":"PASSWORD",
    "auth_type":"ntlm"    
  }
}

SharePoint Connection | API Job Configuration Examples

The example below shows a simple job for a SharePoint connection created as standard user without impersonation.

{
    "name":"Simple Job",
    "kind": "transfer",
    "transfer": {
      "transfer_type": "copy",
        "source": {
            "connection": { "id": "{{SharePoint_Connection_sourceID}}" },
            "target": {
                "path": "/sourceDocumentLibrary"
            }
        },
        "destination": {
            "connection": { "id": "{{Box_Connection_destinationID}}" },
            "target": {
                "path": "/destinationFolder"
            }
        },
        "simulation_mode": false
    },
    "schedule": {
        "mode": "manual"
    },
    "stop_policy": {
        "on_success": 5,
        "on_failure": 5,
        "on_execute": 25
    },
    "category": {
      "name": "Report {Name}"
    }
}

SharePoint Connection Notes

Transfer Timeouts Exceptions | Batch Mode

DryvIQ Migrate

Microsoft SharePoint