SharePoint - Create List

Declaration

<AMSHAREPOINT ACTIVITY="create_list" SITE="text" 
VERSION="text (options)" AUTHTYPE="text (options)" 
USERNAME="text" PASSWORD="text (encrypted)" DOMAIN="text" 
LIST="text" ENABLEATTACHMENTS="YES/NO" ENABLEVERSIONING="YES/NO">
<COLUMNCONSTRUCT SCHEMAXML="text" ADDTODEFAULTVIEW="True/False" />
<COLUMNCONSTRUCT ADDTODEFAULTVIEW="True/False" /></AMSHAREPOINT>

Description: Creates a new SharePoint list. A list is a container in a SharePoint site that stores list items. A list has a customizable schema that is composed of one or more fields.

Practical Usage

Creates a new list in which to add items. A Microsoft Windows SharePoint Services site can include a variety of lists — from contacts and calendars to announcements and issue-tracking lists. To add items to a list, use the Add list item activity.

Connection Parameters

Property

Type

Required

Default

Markup

Description

Connection

---

---

---

---

Indicates where this activity's SharePoint credentials should originate from. This is a visual parameter used only during design-time, thus, contains no properties or markups. The available options are:

  • Host - Specifies that a custom set of credentials will be entered for this activity. This option is normally selected if only a single SharePoint activity is required to complete the task.

  • Session - Specifies that credentials should derive from a session created in a previous Create session step. This allows several activities to be linked to a specific session, eliminating redundancy. Multiple sessions can exist within a single task, allowing several SharePoint operations to be automated simultaneously.

Session

Text

Yes if Connection set to Session

SharePoint

Session1

SESSION="mySession1"

The name of the session to associate with this activity. This parameter is active only if the Connection parameter above is set to Session. If the Connection parameter is set to Host, this parameter is ignored and the remainder of the parameters specified below becomes active.

Version

Text (options)

Yes if Connection set to Host

SharePoint 2010

  1. VERSION="sharepointonline"

  2. VERSION="sharepoint2010"

  3. VERSION="sharepoint2007"

The SharePoint version to associate with this activity. The available options are:

  • SharePoint Online - A cloud-based service, hosted by Microsoft as an alternative to installing and deploying SharePoint Server on premises.

  • SharePoint 2010 and newer (default) - SharePoint version 2010 or newer - includes SharePoint Foundation 2010/2013 and SharePoint Server 2010/2013.

  • SharePoint 2007 and older - SharePoint version 2007 or older - includes Windows SharePoint Services (WSS) v3 edition and Microsoft Office SharePoint Server 2007 (MOSS 2007) edition.

NOTE:  Some SharePoint activities are only supported in SharePoint 2010 or newer.

Site

Text

Yes if Connection set to Host

(Empty)

SITE="http://myServer/tech"

The SharePoint site to access. A SharePoint site is a collection of pages, site templates, lists, and libraries configured for the purpose of achieving an express goal.

Authentication type

Text (options)

No

Default

  1. AUTHTYPE="form"

  2. AUTHTYPE="anonymous"

  3. AUTHTYPE="basic"

  4. AUTHTYPE="digest"

  5. AUTHTYPE="ntlm"

The method of authentication to utilize. Authentication types vary depending on the SharePoint version. Different parameters become active depending on which authentication method is selected. Below lists available authentication methods and their compatibility.

  • Default (default) - Compatible withSharePoint 2010 or newer.

  • Basic - Compatible with  all SharePoint versions.

  • Form - Compatible withSharePoint 2010 or newer.

  • Anonymous - Compatible withSharePoint 2010 or newer.

  • Digest - Compatible with  SharePoint 2007 or older.

  • Proprietary - Compatible with  SharePoint 2007 or older.

  • None - Compatible with  SharePoint 2007 or older.

  • NTLM - Compatible with  SharePoint 2007 or older.

Username

Text

Yes

(Empty)

USERNAME="theUserName"

A valid SharePoint username. This parameter may or may not be active depending on which option is selected under the Authentication type parameter.

Password

Text

Yes

(Empty)

PASSWORD="encryptedText"

A valid SharePoint password to authenticate the username entered above. This parameter may or may not be active depending on which option is selected under the Authentication type parameter.

Domain

Text

Yes

(Empty)

DOMAIN="myServer"

The domain that the user belongs to. This parameter may or may not be active depending on which option is selected under the Authentication type parameter.

Certificate

Text

No

(Empty)

CERTIFICATE="C:\Temp\file.cer"

The (DER encoded) certificate to use for SharePoint authentication. This parameter may or may not be active depending on which option is selected under the Authentication type parameter.

Ignore invalid certificate

Yes/No

No

No

IGNOREINVALIDCERTIFICATE="yes"

If set to YES, specifies that invalid server certificates that are detected will be automatically ignored. Set to NO by default.

Timeout (seconds)

Number

No

600

TIMEOUT="500"

The total number of seconds allowed to connect to the SharePoint server before a timeout error is generated. The default value is 600 seconds.

Proxy type

Text (options)

No

Default

  1. PROXYTYPE="none"

  2. PROXYTYPE="http"

The type of proxy required for SharePoint connections that pass through a proxy server. The available options are:

  • System default (default) - Points to the default proxy used by the system.

  • None - No proxy authentication required.

  • HTTP - Proxytype is HTTP.

Use authentication

---

---

---

---

If enabled, specifies that proxy authentication is required, enabling authentication-based parameters (disabled by default). This is a design-time parameter, therefore, contains no properties or markups. It is active only if the Proxy type parameter is set to HTTP.

Proxy server

Text

No

(Empty)

PROXYSERVER="proxy.host.com"

The host name (server.domain.com) or IP address (xxx.xxx.xxx.xxx) of the proxy server. This parameter is available only if the Proxy type parameter is set to HTTP.

Proxy username

Text

No

(Empty)

PROXYUSERNAME=username

The proxy username to authenticate with. This parameter is available only if the Use Authentication parameter is enabled.

Proxy password

Text

No

(Empty)

PROXYPASSWORD="encrypted"

The proxy password to authenticate with. This parameter is available only if the Use Authentication parameter is enabled.

Proxy port

Number

No

808

PROXYPORT="8080"

The port that should be used to connect to the proxy server. This parameter is available only if the Proxy type parameter is set to HTTP. The default value is 808.

List Parameters

Property

Type

Required

Default

Markup

Description

Title

Text

Yes

(Empty)

TITLE="group_title"

The title of the list to create.

Description

Text

No

(Empty)

DESC="group_description"

A user defined description of the list to create.

Template Type

Text (options)

No

GenericList

TEMPLATETYPE="DiscussionBoard"

Specifies a list template. Click the drop-down arrow and select from a list of available templates.

Quick Launch

Text (options)

No

DefaultValue

QUICKLAUNCH="NO"

Specifies whether the list should be a quick launch item. The available options are:

  • Yes

  • No

  • DefaultValue

Add Column(s)

You can add columns to sites and lists, and reference them in content types. A column represents an attribute or piece of metadata that the user wants to manage for the items in the list or content type to which they added the column. To add a new row of columns, select the Click here to add new row link.

Schema XML

Text

No

(Empty)

SCHEMAXML="column2"

The name of the column to add.

Default View

True/False

No

No

ADDTODEFAULTVIEW="False"

If set to TRUE, specifies that the column should be set as the default view. The default value is FALSE.

Enable Attachments

Yes/No

No

No

ENABLEATTACHMENTS="yes"

If set to YES, specifies that list item attachments are enabled for the list. This parameter is set to NO by default.

Enable Versioning

Yes/No

No

No

ENABLEVERSIONING="yes"

If set to YES. specifies that historical versions of list items and documents can be created in the list. This parameter is set to NO by default.

Enable Folder Creation

Yes/No

No

No

ENABLEFOLDER="yes"

If set to YES, specifies that new list folders can be added to the list. This parameter is set to NO by default.

Description tab - A custom description can be provided on the Description tab to convey additional information or share special notes about a task step.

Error Causes tab - Specify how this step should behave upon the occurrence of an error. (Refer to Task Builder > Error Causes Tab for details.)

On Error tab - Specify what AWE should do if this step encounters an error as defined on the Error Causes tab. (Refer to Task Builder > On Error Tab for details.)

Example

The sample AML code below can be copied and pasted directly into the Steps panel of the Task Builder.

Description: Create SharePoint list "List_Title" of type "Meetings". Session is "SharePointSession1".

NOTE: This sample must be modified to fit your SharePoint credentials.
<AMSHAREPOINT ACTIVITY="create_list" LIST="List_Title" 
DESC="Meetings" TEMPLATETYPE="Meetings" 
QUICKLAUNCH="On" ENABLEATTACHMENTS="yes" ENABLEFOLDER="yes" 
ENABLEVERSIONING="yes" PROVIDER="session_based">
<ColumnConstruct SchemaXml="column1" AddToDefaultView="True" />
<ColumnConstruct SchemaXml="column2" AddToDefaultView="False" />
</AMSHAREPOINT>