How to use CSV stream on a stored public file

Hi there,

I have a table ImportFiles. This as a attachment field (file) with an CSV file stored in it. I want to use CSV stream to iterate over the CSV file to import the CSV records in another table ImportLines.

My FunctionStack is as follows

• Get ImportFile Record (varSelectedImportFile)

• Create variable: fileURL (varSelectedImportFile.file.path

• Create File Resource (varFileResource)

  • Filename: Test.csv

    FileData: fileURL

• Get File ResourceData (varFileResourceData)

  • from : varFileResource

• CSV Stream (varStream)

  • varFileResource.data

• Fo Each Loop varStream as varItem

  • Stop en Debug varItem

For some reason the CSV stream is empty. As a test I added a fileResource input variable. When I use that the CSV Stream works like a charm.

So my question. How can I transform the import file that is stored in

• Table: Importfile

• Field (attachment): file

To a usable fileResource to be used in the CSV stream?

Thanks for the help