Get File/Folder List

Operation Name

Function overview

Gets file / folder list on Google Drive.

Data Model

XML type.

Properties

For information about using variables, refer to "variables".

Basic settings

Item name	Required/Optional	Use of Variables	Description	Remarks
Name	Required	Not available	Enter the name on the script canvas.

Required settings

Item name	Required/Optional	Use of Variables	Description	Remarks
Destination	Required	Not available	Select Global Resources. [Add]: Adds new global resource. [Edit list]: Global resource settings can be managed from "Edit Resource list".
Folder path	Required	Available	Enter a Google Drive folder path.	Google Drive folder path needs to be an absolute path. Constrained Characters of DataSpider File System cannot be used, except for the path separator "/".
Recursive processing	Optional	Not available	For a specified folder, select whether to get the file/folder recursively. [Checked]: If the specified folder contains folders, then gets the file/folder recursively. [Not Checked]: (default) Gets a list of the specified folder only.

Property Action

Item name	Description	Remarks
Update folder path list	Gets folder path in the specified destination and sets to [Folder path].	If [Destination] is specified/edited, or add/edit of folder is performed on Google Drive, the edition can be reflected using this property action.

Comment

Item name	Required/Optional	Use of Variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this adapter. The description will be reflected in the specifications.

Schema

Input Schema

None.

Output Schema

<?xml version="1.0"?>
<server>
  <files>
    <file etag="" name="" remotepath="" size="" status="" type="" updated="" />
  </files>
</server>

Element name	Attribute name	Description	Remarks
server	-
files	-
file	-	Appears in each gotten file / folder.
	etag	Outputs the ETag of the retrieved file/folder.	Output when file / folder information is successfully obtained. ETag values may be updated without notice.
	name	Output the name of the retrieved file/folder.	If status is "ErrorRemoteFolderNotFound" then the value is blank.
	remotepath	Output the file path on Google Drive of the deleted file/folder.
	size	Outputs the size of the file/folder retrieved. The unit is byte.	Output when file / folder information is successfully obtained. Outputs "0" in case of folder. Always outputs "0" for Google format files (such as spreadsheets, presentations, documents, forms).
	status	Outputs the status of the acquired file/folder. Exist: Status that file / folder exists. ErrorRemoteFolderNotFound: The status that specified [Folder path] is not on the Google Drive, or file is specified. Error: The status that because an error occurred file / folder information could not be got.
	type	Output the classification of gotten files / folders. File: File Folder: Folder
	updated	Output the last updated date of the retrieved file/folder.	Output when file / folder information is successfully obtained. Output by the format of [xmlfw.daterenderingformat] inside system property. If it has not been set, the default format will be "yyyy-MM-dd'T'HH:mm:ss.SSSZZ" is printed on.Example :2007-10-16T13: 15:22.738 +0900 Time zone is the time zone of DataSpiderServer.

Loading schema in Mapper

Schema is loaded automatically.

See "Edit Schema"for any details .

Mass Data Processing

Mass data processing is not supported.

PSP Usage

PSP is not supported.

Available component variables

Component variable name	Description	Remarks
count	Return the number which is the total number of the gotten folder number and file number.	The value defaults to null. The sum of' 'folder_count' and 'file_count'.
folder_count	Returns the number of retrieved folder.	The value defaults to null.
file_count	Returns the number of retrieved file.	The value defaults to null.
message_category	Stores the category to which corresponding message code belongs to, when an error occurs.	The value defaults to null.
message_code	Stores its corresponding message code of occurred error.	The value defaults to null.
message_level	Stores the severity of the corresponding message code of the occurred error.	The value defaults to null.
error_type	Stores the type of the occurred error.	The value defaults to null. Error is represented in the format depicted below. Example:java.io.FileNotFoundException The message may vary depending on DataSpider Servista version.
error_message	Stores the error message for the occurred error.	The value defaults to null. The message may vary depending on DataSpider Servista version.
error_trace	Stores stack trace of the occurred error.	The value defaults to null. The message may vary depending on DataSpider Servista version or the client application used.

Specification Limits

On Google Drive, files/folders with the same name are available, but this adapter does not support them.

Only the files/folders located under "My Drive" can be accessed.

Main exceptions

Exception name	Causes	Solution
ResourceNotFoundException Resource definition could not be found.Name: []	[Destination] is not specified.	Please specify [Destination].
ResourceNotFoundException Resource definition could not be found.Name: [<name of Global Resources>]	Resource definition selected in [Destination] is not found.	Please check the global resource specified in [Destination].
InvalidPropertyConfigurationException <Property name> is not specified.	[<Property name>] is not specified.	Specify the [<Property name>].

Notes

HTTPS is used in the communication between Google Drive and this adapter.

If an error unrelated to the connection (error which is not described in "main exception") occurs when executing, set "Error" to status attribute of file element at the file / folder in which error occurs, then output as result data and continue the further process.

If the free space on Google Drive is running out, the files/folders will not be listed successfully.
In that case, increase free space of Google Drive.