Overview
These public interfaces are used in SharePoint components. They are provided for implementing advanced functionality in your scripts. In order for you to use these interfaces in your project, you have to reference CozyRoc.SSISPlus.dll and CozyRoc.SharePoint.dll libraries. Also include CozyRoc.SharePoint, CozyRoc.SharePoint.Lists and CozyRoc.SharePoint.Views namespaces.
IConnection / ISharePointConnection
When you call SharePoint Connection Manager AcquireConnection method, it returns object implementing IConnection interface. This is the interface used for interaction with SharePoint service.
Methods
Connects to SharePoint service.
Closes the connection to SharePoint service. Use always after you finish working with the service.
Returns true if connected to the service.
Get specific SharePoint web service. You have to connect first before use. The method has one parameter, which can be one of the options listed in the following table.
| Value | Result Service |
|---|---|
| 0 | Lists Service |
| 1 | Views Service |
Returns SharePoint Online token cookie.
Properties
Specify deployment type. This property has the options listed in the following table.
| Value | Description |
|---|---|
| 0 | Connect to on-premise SharePoint server. |
| 1 | Connect to SharePoint Online service. |
Specify the name or IP address of the SharePoint server.
Specify user name to access the SharePoint service.
Specify user password to access the SharePoint service.
Specify the number of seconds before timing out session connect. The default value of this property is 100 seconds.
Specify if all clients should use the same connection. This property has the options listed in the following table.
| Value | Description |
|---|---|
| True | All clients use same connection (default). |
| False | Every client uses different connection. |
Specify the name or IP address of the proxy server.
Specify the port number on the proxy server to use for the connection.
Specify user name to access the proxy server.
Specify password to access the proxy server.
Knowledge Base
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.