...
...
...
...
...
...
...
...
...
On This Page
| Table of Contents |
|---|
...
| Panel | ||
|---|---|---|
| ||
Microsoft SharePoint supported versions:
|
Create Connection | User Interface
...
Creating a Connection
Expand the Manage section in the left navigation menu.
Click Connections.
Click 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.
...
Click Test connection to ensure DryvIQ can connect using the information entered.
You will see a green "
...
Connected” message on the bottom of the
...
modal when DryvIQ establishes connection.
...
(If
...
the connection fails, verify the information you entered.)
...
Click Done.
Add connection modal - for Microsoft SharePoint
...
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
...
Behavior when deleting items | Select the type of delete DryvIQ should perform when deleting items: Permanent or Soft. Soft delete is the default delete behavior; however, Permanent is the recommended behavior. A soft delete marks items as a deleted. You can still access them to restore or permanently delete the items. A permanent delete removes the items. This delete is not reversible. |
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 Use the Platform Comparison tool tool to see how your integration platforms may interact regarding features and limitations. For more information on SharePoint restrictions, see Microsoft’s official documentation.
| Info |
|---|
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 |
|---|---|
Other Features/Limitations | SharePoint 2013 | SharePoint 2016 | SharePoint 2019 |
|---|---|---|---|
2 GB | 2 GB | 15 GB | |
260 | 260 | 400 | |
128 | 128 | 260 | |
Invalid characters | | # { } % & \ ~ + / : * ? < > \\ “ | | # % \ \\ / : * ? < > “ | | \ \\ / : * ? < > " |
Restrictions |
|
|
|
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:
...
.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.
| Code Block |
|---|
GET {{url}}v1/connections/platforms/SharePoint/new |
...
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.
| Code Block |
|---|
{
"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.
| Code Block |
|---|
{
"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}"
}
} |