SharePoint Online Connector
Documentation
Version: 13
Documentation

EndPoint Read List Items


Name

get_list_items

Description

No description available

Parameters

Parameter Label Required Options Description
SiteId SiteId NO Specify a site
ListId ListId YES Specify a list id to search items for
Filter Filter NO
Option Value
None
Equal Search fields/SomeColumn eq 'SomeValue'
Substring Search substringof(fields/SomeField,'abc')
Starts With startswith(fields/SomeField, 'abc')
To filter data on a field, you will first need to index it: https://support.microsoft.com/en-us/office/add-an-index-to-a-list-or-library-column-f3f00554-b7dc-44d1-a2ed-d477eac463b0 [API Help..]
expand Expand (Output Fields) NO By default lookup fields are returned as (null). Select fields which you want to process (to speedup processing check only those fields which are (null) in the output)

Output Columns

Label DataType Length Raw Description
Id DT_WSTR 200 False
CreatedOn DT_DBTIMESTAMP 0 False
CreatedById DT_GUID 0 False
CreatedByDisplayName DT_WSTR 200 False
ModifiedOn DT_DBTIMESTAMP 0 False
LastModifiedId DT_GUID 0 False
LastModifiedDisplayName DT_WSTR 200 False
[DynamicColumn] DT_WSTR 2000 False [$parent.name$]
[DynamicColumn]LookupId DT_I4 0 False [$parent.name$] Id
[DynamicColumn]Label DT_WSTR 500 False [$parent.name$] Id
[DynamicColumn]TermGuid DT_WSTR 100 False Managed Meta [$parent.name$] TermGuid
[DynamicColumn]WssId DT_I4 0 False Managed Meta [$parent.name$] WssId

Input Columns

Label DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.