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.