Pull CSV from download URL

Ask a question
1

Hi, I am new to Parabola and have a situation where the CSV I want to get is linked in a URL on a Government site. The URL stays the same, but the CSV is updated periodically. So rather than needing to download a new file using the URL each time and editing my flow, I wonder if there is a way to Pull the CSV directly from the URL by just running the flow. This way I can be sure that I am getting the latest CSV running in the flow.

The URL is: http://hearingservices.gov.au/hsoViewWEB/file/partially-subsidised-schedule.xlsx

Thank you in advance

2

Hey Christo!

Normally, you would use a Pull from an API step and it would pull the latest version of CSV each time!

In this case, that URL downloads an Excel file - a .xlsx file - which our Pull from an API step cannot parse.

Is there an option for this URL to pull an actual CSV file?

Best,
Brian

3

Hi Brian,

Thank you for the quick response.
Unfortunately only xlsx, which works when I upload the file directly and PDF.

I am now seeing if there is something that I can do with Integromat.

1 Like
4

Hello, we also need it to be excel, by any chance is this now supported?

5

Hi @lala_lala – we don’t yet support Excel files from a URL, though agreed it could be a really powerful feature! Can you add it to feature requests when you have a chance?: https://community.parabola.io/c/feature-requests

Our product team uses that list to help figure out what to build next. This Excel file use case isn’t currently in the works, so a feature request would help it get prioritized.

Currently our step Pull from an API reads JSON, CSV, and XML data types. If it’s possible to make CSV data available through the URL, you can import this data by using Pull from API.

1 Like