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

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.

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.

-Anirudh

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.

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

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