CSV component allows you to read and manipulate CSV files.
Changelog
15 versions
v2.0.7
Latest
- AddRow/AddRows: Refactored for safer async behavior: fixed error propagation, added null-checks, wrapped lock.extend() in try/catch, added a destroyed flag to avoid race conditions, improved empty-file handling, and introduced periodic lock-extension when less than 40s remain. Additional fixes include preventing double resolution in getRows, ensuring pipeline errors propagate in loadFile, correcting the close handler and using formatRow() in editCSV, renaming shadowed variables in updateRows, and making addColumn accept index 0. Added new escapeCell() method implementing RFC 4180-compliant CSV escaping to prevent CSV injection.
v2.0.6
- Lower maxWait for quota to 60 seconds to avoid unnecessary timeouts. Affects AddRow component.
v2.0.5
- Fixed an issue with the AddRow component that could result in an error when the input row was an array.
v2.0.4
- Fixed an issue when loading a CSV file could throw 'Maximum call stack size exceeded' error.
v2.0.3
- (breaking change) Fixed incorrect error message when using Filters or Values in these components: AddRow, UpdateRows, DeleteRows, GetCell, GetRow, GetRows. You will need to re-enter the values for these fields again.
- CreateCSV: make the `initialContent` required to prevent run-time exception.
- Added a warning for the AddRows component when all the added rows are empty.
- Optimized the performance of the AddRows component.
- Updated description of some components to make them more informative.
- Fixed an issue with GetCell that could result in an error when no rows are found using a filter.
- Fixed an issue when CSV processor could throw a Lock error.
v1.3.2
- AddRows: use the textarea for rows input, improve error handling, add maximum execution time (60minutes).
v1.3.0
- Added a new component 'AddRows' that allows you to append multiple rows to the end of a CSV file.
v1.2.5
- Added lock mechanism to avoid race condition in 'AddRow' component.
v1.2.4
- Fix issue with CSV module on Appmixer 5.0.0 and higher.
v1.2.3
- Improve lock handling in the CSVProcessor.
v1.2.2
- Fix CSVProcessor editCSV.
v1.2.1
- Provide parseNumbers and parseBooleans options when loading CSV files.
v1.1.1
- CSVProcessor uses new context.replaceFileStream function.
v1.1.0
- FileId inputs changed from 'text' to 'filepicker'. Requires Appmixer 4.4.4 or higher.
v1.0.0
- Initial version
Authentication
| Type | Details |
|---|---|
| Other | — |
Actions
13
Get Cell
Find the first row that matches the provided filter and return the row value under the specified column.