Upload and read CSV files in Dynamics 365 for operations

To quickly reuse the code here it goes

class RGReadSample
{
///
/// Runs the class with the specified arguments.
///
/// The specified arguments.
public static void main(Args _args)
{
AsciiStreamIo                                   file;
Array                                           fileLines;
FileUploadTemporaryStorageResult                fileUpload;
fileUpload = File::GetFileFromUser() as FileUploadTemporaryStorageResult;
file = AsciiStreamIo::constructForRead(fileUpload.openResult());
if (file)
{
if (file.status())
{
throw error(“@SYS52680”);
}
file.inFieldDelimiter(‘,’);
file.inRecordDelimiter(‘\r\n’);
}
container record;
while (!file.status())
{
record = file.read();
if (conLen(record))
{
info(strFmt(“%1 – %2”,conPeek(record,1),conPeek(record,2)));
}
}
info(“done”);
}
}

Leave Comment

Your email address will not be published. Required fields are marked *