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.
0
Comments
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 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
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
Nazim Akber Ali What have you tried and what isn't working correctly?
Please sign in to leave a comment.