how to convert csv data in rest api to the table format in view in data virtualization studio

[Varun Vyas]

Hello,

We are calling an external REST web service which has been defined as a data source, and which returns a large string (fragment below) of CSV data, including column headers. What is the most efficient way to split this into a tabular result set.

we have done sourcing data through rest api when the data was on json or xml format by using XSD and then XSLTxformation but not sure what we need to do when the rest api gives data in csv.

i tried using file delimited in-built adapter as well but that didn't work either.

screenshot for that is attached as well.