SSIS Components for Microsoft SharePoint

Build 25.0.9434

FolderOption

Specifies how the provider displays folders and files in query results when using the SOAP schema.

Possible Values

FilesOnly, FilesAndFolders, RecursiveAll

Data Type

string

Default Value

"RecursiveAll"

Remarks

The FolderOption property determines how files and folders are displayed in query results for Microsoft SharePoint lists and libraries when using the SOAP schema. The available options include:

  • FilesOnly — Returns only files from the specified list or library, excluding folders.
  • FilesAndFolders — Returns both files and folders from the specified list.
  • RecursiveAll — Returns all files from the specified list and all subfolders.

This property is useful for controlling the scope of query results when working with lists and libraries that contain nested folder structures.

Performance Considerations

Selecting a recursive option such as RecursiveAll can increase query execution time and result set size, especially in lists with deep folder hierarchies. Using FilesOnly or FilesAndFolders may improve performance by reducing the scope of results and lowering data retrieval overhead.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434