CSV Store Manipulator

The CSV Store manipulator is used to store CSV records into ImpulseSync storage. This is useful for using a CSV to store data for jobs to retrieve and use.

File Support

This only supports CSV files.

Demonstration Video

Properties

Property	Purpose	Required
columnIndex	A comma separated list of column indexes (0 based) to use as the store key for storing the row.	True
binaryFieldId	Id of the field to get the binary from. If not provided, the binary will be taken from the first field of type binary.	False
deliminator	The deliminator value to use when combining colums for each row into a string value.	False (defaults to ,)
skipFirstRow	Determines if the first row of the CSV should be skipped, i.e., if the CSV has a header	False
storeKey	A liquid template value to prepended to the selected column index value for the store key.	False
storeAsArray	Determines if the record should be stored as an array of field values. Rather than a deliminated string.	False

Specifics

Each row/record of the CSV will be stored into ImpulseSync storage. The store key is based on the columnIndex values chosen and the storeKey.

If more than one column index is provided, each value will be appended to the key. Allowing for multiple column values to be concatenated.