Get TSV write CSV

Hello everyone.

I’m stuck on a problem that should have been simple, but in the end, it wasn’t, at least for me. I need to obtain information from an API, but only later did I realize that it returns tabular data (TSV). I’m trying to find a way to get this data and convert it to CSV. I’ve tried through node HTTP and other methods, but the result wasn’t what I expected. I got closer using Google Apps Script, but it still didn’t work out.

Does anyone have an idea of how I can get this data in plain text and change the \t \n to form a bi-dimensional table?

Thank you.

Hi @Roger_Lovato, welcome to the community :tada:

I quickly gave reading this TSV file using the Spreadsheet File node a go and it seemed to work fine for me.

In this example workflow I am first downloading it (using the HTTP Request node), then reading it (using the Spreadsheet File node) before writing it in a new CSV file (again using the Spreadsheet File node):

Is this what you were looking for?