SharePoint Online Endpoint - get_list_items - Read List Items | ZappySys | SSIS

EndPoint Read List Items

Contents

1 Name
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

get_list_items

Description

No description available

Parameters

Parameter

Label

Required

Options

Description

SiteId

Specify a site

ListId

YES

Specify a list id to search items for

Filter

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 [Read more..]

expand

Expand (Output Fields)

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

Name	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

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