Is there a way to read files in exploratory collaboration server hosted in house?
Yes, you can use ‘API - CSV Data’ option.