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
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 View, returns an XML representation of the List. When Action is Insert,provide an XML representation of the new items to insert into the List.
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 View, 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 Insert. For insert operations, simply provide the fields that you explicitly want to set.
This Node must be run at a DropPoint.
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.