Discover more about the File Reader component and how to use it on the Digibee Integration Platform.
File Reader reads a local file and converts it into a JSON structure that can be manipulated inside the pipeline. The component supports the reading of multi-line text files or binary files.
Take a look at the configuration options for the component. Parameters supported by Double Braces expressions are marked with (DB).
File Name (DB)
File name or full file path (i.e. tmp/processed/file.txt) of the local file.
data.csv
String
Charset
Name of the characters code for the file reading.
UTF-8
String
Check File Size
If the option is activated, the specified Maximum File Size is checked.
False
Boolean
Binary File
If the option is activated, the file is considered binary and the reading consists of a string with BASE64 representation of the file content; otherwise, the file is read as text.
False
Boolean
Maximum File Size
Specifies the maximum size allowed (in bytes); if the file size is greater than the informed value, then a reading error will be thrown.
1048576
Long
Read As A Single String
If the option is activated, the text file will be read as a single string; otherwise, the text file will be read as an array of strings in which each item represents a line from the file.
False
Boolean
Fail On Error
If the option is activated, the execution of the pipeline with error will be interrupted; otherwise, the pipeline execution proceeds, but the result will show a false value for the "success" property.
False
Boolean
The text files are read line by line. A structure is formed at the component output, with all the read lines:
{
"data" : [
"line 1",
"line 2",
...
],
"fileName": "",
"lineCount": 0
}data: has a JSON array of converted lines.
filename: name of the file use as source for the component.
lineCount: amount of line read from the file.
If the Read As A Single String parameter is activated, then the returned structure will contain all the lines from the file read in one unique string:
Notice that, in this case, the lines reading includes one or more line break characters. Generally, if the file is created in Unix-based systems, only the line break with \n will be returned. On the other hand, if the file is created in Windows-based systems, the line break with \r\n will be returned.
For text files to be read, it’s important to set the charset with the same value that was used during the creation of the file. If an incompatible characters set is used, the file might be read and misinterpreted. That takes to imprecisions with special characters, such as accented letters and others.
Binary files can't have their content naturally expressed in properties inside JSON messages, once many binary characters aren't "printable". That way, the content of binary files is transformed into a base64 string:
Notice that, in the example above, the "data" property isn't presented as an array, but as a single base64 string.
The manipulation of files inside a pipeline is made in a protected way. All the files are accessed through one temporary directory only, that is created at each pipeline execution.
Was this helpful?
Was this helpful?
{
"data" : [
"line 1\r\nline2\r\nline n\r\n"
],
"fileName": "",
"lineCount": 1
}{
"data" : "VGhpcyBpcyBhIHRlc3QuCg==",
"fileName": "",
"lineCount": 0
}