OneDrive Connector

Documentation

Version: 5

Documentation

Home » API Integration Hub » OneDrive Connector » EndPoints > List Excel Files

EndPoint List Excel Files

Contents

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

Name

list_excel_files

Description

No description available

Parameters

Parameter	Label	Required	Options	Description
DriveId	DriveId	YES		Specify a drive

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
id	`DT_WSTR`	`nvarchar(500)`	500	False
name	`DT_WSTR`	`nvarchar(150)`	150	False
size	`DT_I8`	`bigint`		False
createdDateTime	`DT_DBTIMESTAMP`	`datetime`		False
lastModifiedDateTime	`DT_DBTIMESTAMP`	`datetime`		False
webUrl	`DT_WSTR`	`nvarchar(1500)`	1500	False
createdBy_user_email	`DT_WSTR`	`nvarchar(150)`	150	False
createdBy_user_displayName	`DT_WSTR`	`nvarchar(100)`	100	False
lastModifiedBy_user_email	`DT_WSTR`	`nvarchar(150)`	150	False
lastModifiedBy_user_displayName	`DT_WSTR`	`nvarchar(150)`	150	False
parentReference_driveId	`DT_WSTR`	`nvarchar(400)`	400	False
parentReference_driveType	`DT_WSTR`	`nvarchar(100)`	100	False
parentReference_id	`DT_WSTR`	`nvarchar(200)`	200	False
fileSystemInfo_createdDateTime	`DT_DBTIMESTAMP`	`datetime`		False
fileSystemInfo_lastModifiedDateTime	`DT_DBTIMESTAMP`	`datetime`		False
folder_childCount	`DT_I8`	`bigint`		False
file_mimeType	`DT_WSTR`	`nvarchar(300)`	300	False
shared_scope	`DT_WSTR`	`nvarchar(100)`	100	False

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.