👷Files (WIP)

Do NOT use this connector currently. Please instead use the file browser on the bottom left. We are in the process of making changes for data retention and stability purposes.

The Files connector can read files, write certain files and list contents of a folder.

Read a file

The readFile function is a cumulative function of the others, currently supporting .csv, .xlsx, .txt, .pdf and .xml file types. Simply insert the path relative to the root folder into the input box. Parameters can be added in object format parameter: value. For possible parameters of each file type see below.

Read a .csv file

To read a character separated values-file use the readCsv function and insert the path into the input box. Parameters can be added in object format in the second box.

Parameter	Default	Description
delimiter	,	Delimiter used for separating columns. Use "auto" if delimiter is unknown in advance. Use an array to give a list of potential delimiters e.g. [", " "|", "$"].
noheader	false	Indicating csv data has no header row and first row is data row.
checkColumn	false	Check whether column number of a row is the same as headers. If column number mismatched headers number, an error of "mismatched_column" will be emitted.
checkType	false	Turns on and off type interpretation
quote	"	If a column contains delimiter, it is able to use quote character to surround the column content. e.g. "hello, world" won't be split into two columns while parsing. Set to "off" will ignore all quotes.
trim	true	Indicate if parser trim off spaces surrounding column content. e.g. " content " will be trimmed to "content".
ignoreEmpty	false	Ignore the empty value in CSV columns. If a column value is not given, set this to true to skip them.
includeColumns		This parameter instructs the parser to include only those columns as specified by the regular expression. Example: /(name|age)/ will parse and include columns whose header contains "name" or "age"
ignoreColumns		This parameter instructs the parser to ignore columns as specified by the regular expression. Example: /(name|age)/ will ignore columns whose header contains "name" or "age"

See https://www.npmjs.com/package/csvtojson#parameters for more parameter options.

Write a .csv file

You can write .csv files with the writeCsv function. Simply insert or link some JSON string in the first input box and specify a path and filename for the file to be saved to.

Read an Excel sheet (.xlsx)

Use the readXlsx function to ingest Excel files.

Output Example:

{
    sheet1: [{
        A: 'data of cell A1',
        B: 'data of cell B1',
        C: 'data of cell C1'
    },
    {
        A: 'data of cell A2',
        B: 'data of cell B2',
        C: 'data of cell C2'
    }],
    sheet2: [{
        A: 'data of cell A1',
        B: 'data of cell B1',
        C: 'data of cell C1'
    }]
}

Parameter	Example	Description
header	{rows: 1}	This is the number of rows that will be skipped and will not be present in the resulting object. Counting from top to bottom.
sheets	['sheet2']	Only get the data from a specific sheet.
columnToKey	static example: { A: 'id', B: 'firstName' } dynamic example: { '*': '{{columnHeader}}' }	Name columns in the output. It is possible to use a value from the sheet with e.g. '{{A1}}' or {{columnHeader}}, which will follow the header parameter settings. To dynamically name every column, use '*'.
range	'A2:B3'	Defines the range from which to include data.

It is also possible to nest most parameters for different options per sheet. See https://www.npmjs.com/package/convert-excel-to-json#config-per-sheet

Read a Word file (.docx)

Read a PowerPoint file (.pptx)

Read an HTML file (.html & .htm)

Read a text file (.txt)

Read a markdown file (.md)

Read a PDF file

Read a .xml file

To read extended markup language files use the readXml function.

Move a file

Copy a file

Delete a file

Create a new folder

Delete a folder

Browse a directory