SSIS Components for Microsoft SharePoint

Build 24.0.9060

AddListColumn

Adds a new column to the specified list.

Input

Name Type Description
List String The name of the list on the SharePoint server.
ColumnName String The name of the column to add.
DisplayName String The display name of the column to add.
DefaultValue String The default value of the column to add.
ColumnType String The data type of the column to add. The valid options are defined by the FieldTypes available in the SharePoint API: https://docs.microsoft.com/en-us/previous-versions/office/sharepoint-csom/ee540543(v=office.15). The allowed values areInteger, Text, Note, DateTime, Counter, Choice, Lookup, Boolean, Number, Currency, URL, Computed, Threading, Guid, MultiChoice, GridChoice, Calculated, File, Attachments, User, Recurrence, CrossProjectLink, ModStat, Error, ContentTypeId, PageSeparator, ThreadIndex, WorkflowStatus, AllDayEvent, WorkflowEventType, Geolocation, OutcomeChoice.

The default value is Text.

MaxLength String The values' maximum length of the column to add.
PrimaryKey String A Boolean value indicating whether the column should be primary key.
ReadOnly String A Boolean value indicating whether the column is read only.
Required String A Boolean value indicating whether the column is required.

Result Set Columns

Name Type Description
Success Boolean Indicates whether the operation was successful or not.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060