Parse a force-download file as a CSV

Hello,

I retrieve from a previous step (thanks to a webhook) a third-part CSV URL that has headers of type stream/octet.

That kind of URL, if we open it from a browser, it forces download, and then I have a proper CSV file on my desktop.

If I put this in an HTTP Request step, I can only have binary as a “data” result and therefore, I can’t parse it.

Do you have any idea of what I could do to handle this and parse the CSV that is behind?

Thanks

Hi @Romain_BOYER did you try the toString function?

4 Likes

I just tested it and it seems much better in my test, I don’t have binary any more and see something I can handle ; I’ll go forward tomorrow with that and tell you back. Thanks for the great insight!

3 Likes