SetConnect

SharePointInfo

WebServices::SharePointInfo

Description

Retrieve lists, view or item information from SharePoint and store it in a recordset (handle).

Options

SharePoint Webservices Base URL

The base URL of the SharePoint webservice. This URL is used to create the URL's for the "Copy", "Lists" and "Views" webservices which are used by the plugin.

Example:
http://servername/{sitename}

Row Limit

The maximum number of rows that can be retrieved.

Option

Get Lists Collection
Retrieves all lists from the server
Get Views Collection
Retrieves all views from the specified list from the server
Get ItemsCollection
Retrieves all items from the specified list and view from the server.

Note: if you don't know the view name use "All Documents"
Get Managed Metadata
Retrieves "CustomProperties" from Taxonomy data.

Credentials

The credentials to use for the connection with the SharePoint server.

Default
Uses the credentials as they are set for the current security context (logon user)
Login
manually supply the network credentials (username, password, Domain)
Online
use sharepoint online login verification

Recordset Output Configuration

Handle Name
The name of the (new) recordset (handle) to which the data will be saved
Table Name

Optional table name. If a table name is specified the result will be stored in recordset "Handle Name" using "Table Name" for the name.

This way the recordset can later be queried using "QueryDatabase - Query Recordset" and the table name to use in QueryDatabase is "Table Name"

Viewfields

The viewfields/columns that must be included in the query.

Include Mandatory Columns

When checked, the mandatory columns will automatically be included in the query.

Group Name

Group name from which to retrieve the CustomProperties.

TermSet Name

TermSet name from which to retrieve the CustomProperties.

Property Name

List of custom property names to retrieve.

Documentation

Release notes