HTTP GET API call returns CSV data - how can I process in flow?

Integrator.io
, , , ,
1

Hi all,

I have a lookup HTTP GET API call against an RFID system that returns data in a raw csv format. I haven't been able to find a way to process or convert this mid-flow.

I thought perhaps I could use a file lookup and send the blob to an FTP export and then reimport to get it to JSON - but no luck there as there's no json structure present with the blob details.

I also tried setting up a JS transform or preSave but because the data format isn't JSON the script can't process.

Appreciate you reading through, Can anyone suggest an approach to this one ?

You can see the csv response format (and error) in the preview of the Integrator lookup step.

5301043caa20740200000001-a9857b04af394383b1be4f9cda2f217c.png
5301043caa20740200000001-a9857b04af394383b1be4f9cda2f217c.png1241×1253 284 KB

2

Hi Scott,

On the HTTP lookup step, under the "Non-standard API response patterns" section, you can set "Override success media type" to "CSV" and configure the CSV parser as needed.

5301043caa20740200000001-2be9c5cf19f946b8b1dbe7936c8817b7.png
5301043caa20740200000001-2be9c5cf19f946b8b1dbe7936c8817b7.png847×545 19.1 KB

-Anirudh

3

Thanks Anirudh, I didn't think to look past the 'export type' that is very helpful !

That is looking much better, really appreciate your help !

Cheers,

Scott.

4

Hi,

This post is very old but I have similar kind of requirement where I need to get CSV content from http url. Can anyone share complete steps to get csv data using HTTP URL in loop section? Help would be appreciated

5

@nazimakberali What have you tried and what isn't working correctly?