Delete

Operation name

Delete

Function overview

Deletes the specified files in FTP server.

Data model

The data model of this component is XML 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
Destination	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.
Path	Required	-	Specify paths. Each row can be operated with the following buttons: Up Moves the selected row upward by one row. Down Moves the selected row downward by one row. Add Adds a row. Delete Deletes the row.
Path/Remote path	Required	Available	Enter a file path or a directory path of FTP server.	Wildcards ("" and "?") can be used in file names. Example /upload/.csv It corresponds to the file with the csv extension which exists directly under the /upload directory. Example /upload/sales_data??.xls It corresponds to the file with the xls extension, starting with "sales_data" followed by two characters, which exists directly under the /upload directory. Case-sensitive.

Item name

Required/Optional

Use of variables

Description

Remarks

Destination

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.

Path

Required

Specify paths.

Each row can be operated with the following buttons:

Up: Moves the selected row upward by one row.
Down: Moves the selected row downward by one row.
Add: Adds a row.
Delete: Deletes the row.

Path/Remote path

Required

Available

Enter a file path or a directory path of FTP server.

Wildcards ("*" and "?") can be used in file names.
- Example
  
  /upload/*.csv
  
  It corresponds to the file with the csv extension which exists directly under the /upload directory.
- Example
  
  /upload/sales_data??.xls
  
  It corresponds to the file with the xls extension, starting with "sales_data" followed by two characters, which exists directly under the /upload directory.
Case-sensitive.

Delete settings

Item name	Required/Optional	Use of variables	Description	Remarks
Directory option	Required	Not available	Select how to handle directories when deleting data. Ignore (Default) Ignore directories and don't delete. Further, the directory information won't be included in the result list. Recursive Delete files/directories under the specified directory recursively.

Item name

Required/Optional

Use of variables

Description

Remarks

Directory option

Required

Not available

Select how to handle directories when deleting data.

Ignore

(Default)

Ignore directories and don't delete. Further, the directory information won't be included in the result list.

Recursive

Delete files/directories under the specified directory recursively.

Comment

Item name	Required/Optional	Use of variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this connector.

Schemas

Input schema

None.

Output schema

<?xml version="1.0"?>
<ftpserver name="" port="" user="">
  <pathnames>
    <pathname date="" filetype="" local="" remote="" size="" status="" type=""/>
  </pathnames>
</ftpserver>

Element name	Attribute name	Description
ftpserver	-
	name	Outputs the host name of the connected FTP server.
	port	Outputs the port number of the connected FTP server.
	user	Outputs the user name used when connecting to FTP server.
pathnames	-
pathname	-	Appears once for each file/directory to be deleted.
	date	Always outputs empty data.
	filetype	Outputs the file type of the file/directory to be deleted. File File Directory Directory
	local	Always outputs empty data.
	remote	Outputs the absolute path in the FTP server of the file/directory to be deleted.
	size	Outputs the file size of the file to be deleted. The unit is byte. Note It's empty data in the case of directory.
	status	Outputs the deletion status. Deleted The file has been deleted from FTP server. NG The file hasn't been deleted due to an error.
	type	Always outputs empty data.

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
count	The number of files/directories to be deleted is stored.	The default value is null. The sum of "directory_count" and "file_count".
directory_count	The number of directories to be deleted is stored.	The default value is null.
file_count	The number of files to be deleted is stored.	The default value is null.
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. The format of the error type is as follows. Example: java.io.FileNotFoundException
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 FTP connector