SharePoint Online

Provides the ability to view and insert items in a SharePoint Online List.

Revision History

1.0.0.1 Initial Release
1.2.0.1 Added support for file downloads
1.2.1.0 Added support for filtering on the ListXml through a Query

Properties

Connection

Type: Connection Input

SiteUrl
Type: String
The full URL to the SharePoint Site. E.g. https://companyname.sharepoint.com.

Username
Type: String
The username of a user with rights to the List that will be accessed.

Password
Type: Password
The password for the username specified above.

Action

Type: List Input
Provides the action to perform against the List.

ViewList - Retrieves the content of the specified List as an XML Document
DownloadFileAsBinary - Downloads the specified file as Binary
DownloadFileAsText - Downloads the specified file as Text
InsertList - Inserts the items specified in ListXml into the SharePoint Online List
DeleteList - Deletes the specified list.

ListName

Type: String Input
Provides the name of the List.

ListXml

Type: Xml InputOutput
When Action is ViewList, returns an XML representation of the List. When Action is InsertList, provide an XML representation of the new items to insert into the List.

Query

Type: Xml Input
Returns the contents as XML in the ListXml Property, based on the specified filter fields and values. When the Action is ViewList,, the Query Property is optional, if left blank, it will return all contents as XML in the ListXml Property.
For more information on using the Query schema, visit Microsoft Query schema.

See Example Below:

<View>
	<ViewFields/>
	<Query>
		<Where>
			<Eq>
				<FieldRef Name="Title"/>
				<Value Type="Text">Item Title</Value>
			</Eq>
		</Where>
	</Query>
</View>

FileName

Type: String Input
Provides the name of the File via relative file path, e.g. /sites/DevTeam/Shared Documents/test_random_string.py.

FileContents

Type: Binary OR MultiLineText InputOutput
When Action is DownloadFileAsBinary or DownloadFileAsText, returns the contents of the specified file.

Remarks

Use this Node to perform retrieve and insert operations against a named SharePoint Online list.

When Action is set to ViewList, a large number of meta data fields will be returned. It is not necessary to specify these fields when performing an insert by setting Action to InsertList. For insert operations, simply provide the fields that you explicitly want to set.

Troubleshooting
The sign-in name or password does not match one in the Microsoft account system.

Try switching off 2 Factor authentication on the account if it is enabled.

Examples

See Sample Workflow for examples.