SharePoint - Search files in SharePoint library action (batch)

This action searches for files in a folder you specify in a SharePoint library.

Input

FieldDescription
Site nameProvide the name of the SharePoint site to which you plan to connect. If left blank, Workato connects to your default home site, as specified in your connection settings. The site name is located in the URL of the site page. For example, if the URL is https://company-name.sharepoint.com/sites/product, the site name is product.

If you plan to connect to a different site, you can provide the absolute URL to override the base URL. For example, if the input is https://company-name.sharepoint.com/teams/product, Workato connects to the provided input.

Alternatively, you can provide the absolute URL to connect to a different site. For example, entering https://company-name.sharepoint.com/teams/product connects Workato to the specified site directly.
File search methodThe method to use to search files. Defaults to Search by file name, which searches using the exact file name. Alternatively, you can select Regular search.
FolderThe folder to search for the files.
File nameThe name of the file for which you plan to search.
Search textThe text to search for in the file content or metadata. This field is only available when you search using Regular search.
AuthorThe author of the file. This field is only available when you search using Regular search.
Last Modified TimeThe last modified time of the file. This field is only available when you search using Regular search.
File sizeThe size of the file. This field is only available when you search using Regular search.

Output

The output datatree contains the details of the files that match the search criteria.

FieldDescription
IDThe unique identifier of the file.
NameThe name of the file.
Server relative URLThe server-relative URL of the file.
ExistsIndicates if the file exists in the library.
TypeThe type or file extension of the file.
Edit linkURL for editing the file.
Check in commentComments associated with the file check-in.
Check out typeThe type of check-out (for example, online or offline).
Content tagThe tag associated with the content of the file.
Customized page statusIndicates if the file's page is customized.
E tagThe entity tag (ETag) for the file's version.
IRM enabledThe information Rights Management (IRM) status.
LengthThe size or length of the file.
LevelThe security level of the file.
Major versionThe major version number of the file.
Minor versionThe minor version number of the file.
Linking URIThe URI linking to the file.
Linking URLThe URL linking to the file.
Time createdThe date and time the file was created.
Time last modifiedThe date and time the file was last modified.
TitleThe title or display name of the file.
UI versionThe user Interface (UI) version of the file.
UI version labelThe label for the UI version of the file.
Unique IDThe unique identifier of the file.
List sizeThe size of the SharePoint list containing the file.
List indexThe index position of the file within the SharePoint list.

Last updated: