Extract From File

Node: extractFromFile · Full type: n8n-nodes-base.extractFromFile · Version: 1.1

Operations

csv

Parameter	Type	Default	Details
binaryPropertyName	string	"data"	required
options	collection	{}	keys: delimiter, encoding, enableBOM, relaxQuotes, headerRow, includeEmptyCells, ...

html

Parameter	Type	Default	Details
binaryPropertyName	string	"data"	required
options	collection	{}	keys: delimiter, encoding, enableBOM, relaxQuotes, headerRow, includeEmptyCells, ...

fromIcs

Parameter	Type	Default	Details
binaryPropertyName	string	"data"	required
destinationKey	string	"data"	required
options	collection	{}	keys: encoding, stripBOM, keepSource

fromJson

Parameter	Type	Default	Details
binaryPropertyName	string	"data"	required
destinationKey	string	"data"	required
options	collection	{}	keys: encoding, stripBOM, keepSource

ods

Parameter	Type	Default	Details
binaryPropertyName	string	"data"	required
options	collection	{}	keys: delimiter, encoding, enableBOM, relaxQuotes, headerRow, includeEmptyCells, ...

pdf

Parameter	Type	Default	Details
binaryPropertyName	string	"data"	required
options	collection	{}	keys: joinPages, keepSource, maxPages, password

rtf

Parameter	Type	Default	Details
binaryPropertyName	string	"data"	required
options	collection	{}	keys: delimiter, encoding, enableBOM, relaxQuotes, headerRow, includeEmptyCells, ...

text

Parameter	Type	Default	Details
binaryPropertyName	string	"data"	required
destinationKey	string	"data"	required
options	collection	{}	keys: encoding, stripBOM, keepSource

xml

Parameter	Type	Default	Details
binaryPropertyName	string	"data"	required
destinationKey	string	"data"	required
options	collection	{}	keys: encoding, stripBOM, keepSource

xls

Parameter	Type	Default	Details
binaryPropertyName	string	"data"	required
options	collection	{}	keys: delimiter, encoding, enableBOM, relaxQuotes, headerRow, includeEmptyCells, ...

xlsx

Parameter	Type	Default	Details
binaryPropertyName	string	"data"	required
options	collection	{}	keys: delimiter, encoding, enableBOM, relaxQuotes, headerRow, includeEmptyCells, ...

binaryToPropery

Parameter	Type	Default	Details
binaryPropertyName	string	"data"	required
destinationKey	string	"data"	required
options	collection	{}	keys: encoding, stripBOM, keepSource

Parameter Details

options children:

Parameter	Type	Default	Details
delimiter	string	","
encoding	options	"utf-8"	ascii, latin1, ucs-2, ucs2, utf-8, utf16le, utf8
enableBOM	boolean	false
relaxQuotes	boolean	false
headerRow	boolean	true
includeEmptyCells	boolean	false
maxRowCount	number	-1
range	string	""
rawData	boolean	false
readAsString	boolean	false
sheetName	string	"Sheet"
fromLine	number	0
skipRecordsWithErrors	fixedCollection	{...}	groups: value

Example

NODE "extractFromFile" AS "Extract From File" {
  operation: "csv",
  binaryPropertyName: {{ $json.binaryPropertyName }},
  destinationKey: {{ $json.destinationKey }}
}