Hi I have a CSV from a supplier that can be accessed via a URL. What do I use to pull that in? the CSV integration just seems to pull from the Local Computer. Thanks

Hi @JASON_MARTIN , To pull in an external service’s CSV via a URL, you’d use the step Pull from an API and enter it as the API Endpoint URL. The URL would need to be the one where if it is clicked, it automatically downloads the CSV file. [Screen Shot 2020-09-09 at 12.38.09 PM]

Thanks, Adeline. This fails but due to the data I think, although the CSV in question imports into Airtable without issue. I’m not in control of the source, is there anything I can to pull and clean the data? [image] Cheers

@JASON_MARTIN ah, I see. The import step Pull from an API has a strict way of parsing the response by running with default settings and erring out any non-standard CSV formatting. It is on our radar to make this step more flexible in what CSV response formats it can parse. Unfortunately today though…

Thanks, they don’t have an API. They have XML if that’s an option?

Hey @JASON_MARTIN1 , the XML option just might work! Have you given that a try in the Pull from an API step?

Sorry, just got back on this. I have an issue with the XML not returning any data. If I paste into the browser it downloads the file but if I pull it using the API module there is no data? How can I see what is going on? Cheers

Hi @JASON_MARTIN , if in the step Pull from an API an XML isn’t working as the API Endpoint URL to bring in data, then it likely isn’t a content type we support. If it is a content type like application/xml or text/xml then it will work, but if it is like application/octet-stream then it won’t. It u…

Hi Jason, I have used PHP to create middleware that tweaks data so it will work with Parabola. If this is something you need to do on a regular basis, I might be able to help. It sounds like your csv file needs a little formatting done before it can be used, can you post an example of the first f…

Hi Thomas, Thanks for the reply. I’m not sure what is going on. The file looks OK but it 's just returning nothing when I use the API to pull the file directly from the endpoint. I have attached a few records from the beginning of the file. “Code”,“Title”,“Price”,“Available Stock”,“Stock Expected…

I ended up using Integromat to grab the csv, and then convert it to a Google Sheet. Parabola then works very nicely. Don’t think it is the same issue as you are facing, but it “should” work.

Pull from a CSV URL

Ask a question

Adam_R October 25, 2021, 8:01pm 13

Hey @Thinus_Enslin – we can continue this conversation in the new post on this topic!

Topic		Replies	Views
Pull CSV from download URL Ask a question Building-Flows	4	743	November 11, 2020
Extract nested csv file from a GET API call. Parabola<>Bubble Ask a question Using-APIs	3	509	July 22, 2021
Pull in a file through a CSV link from Bubble Ask a question	10	1697	November 1, 2021
API Import (CSV Delimiter)/Automatic CSV Pulling Ask a question	3	1075	April 17, 2020
Retrieving a CSV separated with semicolon from URL Ask a question Building-Flows	3	670	February 23, 2023

Pull from a CSV URL

Related topics