Compare CSV response to CSV data file

One of the endpoints on a service Iā€™m testing returns a load of data in CSV format. What would be the best way to compare that response to a CSV file I provide. I want to make sure that the files are exactly the same.

Can I do this using data files? Ordinarily I would just put my reference data in a variable an compare the response to it but its thousands of lines long.

Are you also using Newman?

Yes I use newman to run the tests when the service is deployed through Octopus

Hi Alex / Valentin - did you get any solution for this problem? I am also trying to compare CSV response to CSV data file but unable to proceed.