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

Scott Murray

• May 29, 2021 03:57

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

• 

  Anirudh Sundaram Senior Integration Engineer

  • June 01, 2021 19:27

  

  

  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

  0
• 

  Scott Murray

  • June 01, 2021 23:36

  

  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.

  1
• 

  Nazim Akber Ali

  • September 11, 2023 08:41

  

  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

  0
• 

  Steve Klett Strategic Partner

  • September 11, 2023 22:00

  

  

  

  

  

  

  Nazim Akber Ali What have you tried and what isn't working correctly?

  0

Please sign in to leave a comment.