Does anyone know how to read the first line of a CSV?
I have tried the readcsvlogpaging() function but it only works for files that are in the logs directory, and the readexcelsheetpaging() function does not work for CSV documents.
Any ideas?
Thanks!
Discussion posts and replies are publicly visible
A CSV file is really just text (just in a particular format). I think you might be able to leverage a rule that reads the contents of a text file - i'll look around and see if I remember the one I was thinking of.
I have also tried the readtextfromfile() function but the file is very large and I get the following error: The Memory Circuit Breaker prevented this evaluation from completing due to insufficient resources. Is there any way to limit this reading?
Oof -- How large is the CSV? Where is it coming from, and do you have any alternatives?
They are files of about 100MB that we load automatically from a repository, and to verify the correct structure of these I need to keep the "headers" to validate them.
Hey, vgarcmon. Have you tried to change the BatchSize parameter? It is one of the most common unnattended recomendations, because documentation doesn´t recommend setting this paremeter to -1, which means "extract all the registers at once".
I am not aware of any way to read csv directly within the Appian. It has to be loaded into DB first and then retrieve from the same.