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.
Please sign in to leave a comment.