Custom Integrator column Total
I created a Custom Integrator - API Type. I want to calculate the total amount and do some validation while uploading XLS file.
How do we determine the End of File during upload.Once it has finished parsing through all the rows I have to total the amount column in spreadsheet and make sure total is greater than 0. If greater than 0 then only commit all the rows else rollback.
Thanks