SharePoint Online Connector
SharePoint Online Connector Help
Version 10
ZappySys Logo File Version: v10
Supported Engine: 9

EndPoint Read List Items (Dynamic Columns)


Name

get_list_items_dynamic

Description

Use this endpoint if you face issue with NULl values in some columns. This endpoint scans metadata from few sample rows and decides datatypes. Use this if other endpoing showing null values for Complex datatypes (e.g. Lookup, Location, Person)

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
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Input Columns

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