Search…
FTP
Functions and settings available for the FTP endpoint

Functions

The following list of functions are available in the FTP system:

getFiles

postFiles

Functions lists are expanding weekly, this list was accurate at the date of publishing.

Settings

The following settings below are optional for FTP type integrations.

array_key

tbc.

array_merging

Used when combining multiple events together in the destination functions. This settings allows the specification of a top level key that will be merged together.
  • Type: Text
  • Required: No
  • Default: N/A
Applicable functions:
  • PostFiles
Example:
array_merging = "products"

edi_format

edi_line_identifier
edi_group_terminator
edi_force_multiples
edi_multi_line

event_grouping

tbc

file_far

Ability to find and replace in a file after its generation. This feature can be helpful if the use of protected key names is required.
  • Type: Text
  • Required: No
  • Default: N/A
Applicable functions:
  • PostFiles
Example:
file_far = "find_first|replace_first,find_second|replace_second"

filename_format

Defines the output file naming convention
  • Type: Text
  • Required: No
  • Default: ##DATETIME##.##EXTENSION##
Applicable functions:
  • PostFiles
Example:
filename_format = "Payout_Report_##DATETIME##.xml"
Dynamic field values:
Setting
Output
Example
##JOBID##
Injects the current job id used in the data stream by HighCohesion.
1b503450-89ea-11ea-903e-6ef3fac04b7e
##DATETIME##
Injects the current date and time in the format: YYYY-MM-DD-HH-mm-SS
2020-06-01-11-00-00
##DATETIMEEXACT##
Injects the current date and time with milliseconds in the format: YYYY-MM-DD-HH-mm-SS-zzz
2020-06-01-11-00-00-000
##DATETIMEFORMAT__XXX__##
Inject a custom date time format. Where __XXX__ is replaced with the required formatting. Example being: ##DATETIMEFORMAT__Ymd__##
​
See: https://www.php.net/manual/en/function.date.php for PHP formatting examples.
20200601
##TIMESTAMP##
Injects the current Unix timestamp.
1588149986
##EXTENSION##
Injects the extension as per the formatting setting.
xml
##INCREMENT##
Injects an incremented number based on the stream ID. Checks the HighCohesion internal increment pointer for the stream in use. Each time that the stream is triggered the pointer will increment by one.
42
##PK__XXX__##
Injects the value of a specified payload key where XXX is replaced with a payload key. For example ##PK__order_number__##
GB101231

formatting

Defines the input or output file formatting.
  • Type: List
  • Required: No
  • Default: xml
Applicable functions:
  • GetFiles
  • PostFiles
Example:
formatting = "csv"
List values:
Setting
Output
xml
XML file formatter
json
JSON file formatter
csv
CSV file formatter
xls
XLS file formatter

group_on

Allows the grouping of lines from an input file based on a specific column.
  • Type: Text
  • Required: No
  • Default: N/A
  • Relative to: CSV and XLS file imports.
Applicable functions:
  • GetFiles
Example: The example below would group lines of a CSV file together based on the order_number column. The is helpful when receiving CSV files from systems such as warehouse management systems that can send multiple lines in one file.
group_on = "order_number"

increment_in_file

Ability to inject the data stream increment reference into the payload_out data, before file generation. For example if the destination needs unique file number reference in the file. The value should be the path to add the increment to in the output data.
  • Type: Text
  • Required: No
  • Default: false
Applicable functions:
  • PostFiles
Example:
increment_in_file = "header.reference.number"

index_array

Allows the breaking up in to individual events based on a key that should be present in the input file data.
  • Type: Text
  • Required: No
  • Default: N/A
  • Relative to: XML file imports.
Applicable functions:
  • GetFiles
Example: ...
index_array = "Products"

line_index_array

remote_path

Allows definition of the remote path. Use this setting to instruct the data stream where to look for files on the remote location.
  • Type: Text
  • Required: No
  • Default: /
Applicable functions:
  • GetFiles
  • PostFiles
Example:
remote_path = "/orders/uk_website/"

root_element

Allows the specification of the root XML element.
  • Type: Text
  • Required: No
  • Default: data
  • Relative to: XML file exports.
Applicable functions:
  • PostFiles
Example:
root_element = "Orders"

skip_incrementer

tbc.

skip_path_check

Defines if the system should skip the remote path check. This is especially helpful for some sFTP destinations where the remote list functionality is not available.
  • Type: Boolean
  • Required: No
  • Default: false
Applicable functions:
  • PostFiles
Example:
skip_path_check = true