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

1.0.0.1 Initial Release
1.2.0.1 Added support for file downloads

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.

Provides the action to perform against the List.

Type: List Input

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.

Type: String Input
Provides the name of the List.

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.

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

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

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.

See https://flowgear.me/s/8ripTWV for examples.