Official |[SharePoint] Get file path list

Operation name

Get file path list

Function overview

Obtains the file path list of files specified on SharePoint.

Data model

The data model of this component is table model type.

Properties

= Remarks =

For details on use of variables, refer to Variables.

Basic settings

Item name	Required/Optional	Use of variables	Description	Remarks
Name	Required	Not available	Enter a name that is used on the script canvas.

Required settings

Item name	Required/Optional	Use of variables	Description	Remarks
connection	Required	Not available	Select a connection resource. Add A new connection resource can be added. Edit list Connection resource settings can be edited in > HULFT INTEGRATE > Connections.
authentication connection	Required	Not available	Select an Auth resource to use for authentication.	An Auth connection is required to use this operation.
library name	Required	Available	Enter the document library name of the download source. When folder path is not entered, the file path list is obtained based on the library name. When recursive search is selected, the file path list is recursively obtained based on the library.
recursive search	Required	Not available	Select whether to execute a recursive search when Search folder paths is performed. In addition, select whether to search the specified folder recursively when the file path list is obtained.
folder path	Optional	Available	Enter the folder path to obtain the file path list for.

Property actions

Item name	Required/Optional	Use of variables	Description	Remarks
Connection test	Optional	Not available	You can connect to SharePoint Online using connection information and authentication connection information.	This can be used when connection and authentication connection are specified.
Search library name	Optional	Not available	You can obtain a document library name on the SharePoint site and set it in library name.	This can be used when connection and authentication connection are specified.
Search folder paths	Optional	Not available	You can obtain a folder path in the library with the specified library name and set it in folder path.	This can be used when connection, authentication connection, and library name are specified.

Schemas

Input schema

None.

Output schema

<?xml version="1.0" encoding="UTF-8" ?>
<table>
<row>
<column>file_path</column>
<column>file_name</column>
<column>file_last_modified_at</column>
</row>
<row>
…
</row>
</table>
</pre>

Element name	Label	Description
row	-	Repeats for the number of retrieved file paths.
column	file_path	The file path after the site portion is output.
column	file_name	The file name is output.
column	file_last_modified_at	Updated date information for the file is output.

Loading schema in Mapper

The schema is loaded automatically.

= Remarks =

For details, refer to Edit Schema.

Mass data processing

Mass data processing isn't supported.

Transaction

Transaction isn't supported.

Parallel Stream Processing

PSP isn't supported.

Available component variables

Component variable name	Description	Remarks
message_category	When an error occurs, the category of the message code corresponding to the error is stored.	The default value is null.
message_code	When an error occurs, the code of the message code corresponding to the error is stored.	The default value is null.
message_level	When an error occurs, the severity of the message code corresponding to the error is stored.	The default value is null.
error_type	When an error occurs, the error type is stored.	The default value is null.
error_message	When an error occurs, the error message is stored.	The default value is null.
error_trace	When an error occurs, the trace information for the error is stored.	The default value is null.

Message codes, exception messages, and limitations

Connector	Message code	Exception message	Limitations
Messages and limitations of the SharePoint connector