Pull from a CSV URL

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.

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, this step won’t be able to pull in the data from that source if in an unusual CSV format. Could you check to see if the external service’s API is able to send the data in a JSON format type?

2 Likes

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?

1 Like

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 unfortunately sounds like the latter is occurring for your specific XML.