Retrieving a CSV separated with semicolon from URL

Ask a question
#1

Hello,

I’m trying to retrieve a CSV hosted online here.
It’s a government website and the CSV is separated with semicolon.

If I use the HTTP REQUEST module, it downloads but can’t read it because of the semicolon.
If I download to my computer and reupload it using the USE CSV module, I can select the delimiter and read it.

What can I do to automate the process, am I missing something?

Thanks a lot
Joachim

#2

Hi @Joachim_Brindeau - Happy to help! Our API Import can only parse CSV data that uses commas as the delimiter at this time.

One workaround that we’ve seen people mention for a similar use case was to use Dropbox to pull in that CSV.

Let us know if you have any questions!