SharePoint Online Connector
Documentation
Version: 14
Documentation
Home » API Integration Hub » SharePoint Online Connector » EndPoints > Read List Item (By ID)

EndPoint Read List Item (By ID)

Name

get_list_item

Description

No description available

Parameters

Parameter Label Required Options Description
ListId ListId YES Specify a list id to search items for
ListItemId ListItemId YES Specify a list item id (Record ID)
SiteId SiteId NO Specify a site
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 Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_WSTR nvarchar(200) 200 False
CreatedOn DT_DBTIMESTAMP datetime False
CreatedById DT_GUID uniqueidentifier False
CreatedByDisplayName DT_WSTR nvarchar(200) 200 False
ModifiedOn DT_DBTIMESTAMP datetime False
LastModifiedId DT_GUID uniqueidentifier False
LastModifiedDisplayName DT_WSTR nvarchar(200) 200 False
[Dynamic Column] DT_WSTR nvarchar(2000) 2000 False [Dynamic Column]
[Dynamic Column]LookupId DT_I4 int False [Dynamic Column] Id
[Dynamic Column]Label DT_WSTR nvarchar(500) 500 False [Dynamic Column] Id
[Dynamic Column]TermGuid DT_WSTR nvarchar(100) 100 False Managed Meta [Dynamic Column] TermGuid
[Dynamic Column]WssId DT_I4 int False Managed Meta [Dynamic Column] WssId

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.