URL download CSV file

💬 Queries and Resources
2

Hello @claycurtis44,

Retool's browser environment doesn't directly allow you to intercept and process a downloaded CSV file from a URL in the way you might expect. Instead, you need to fetch the file's content as text and then parse it.

1. Using a REST API Resource:

  • Create a REST API Resource:
    • In your Retool app, go to "Resources" and create a new "REST API" resource.
    • Set the "Base URL" to the base URL of your file download URL (if applicable)

2. Set Up a Query:

  • Create a new query using the resource you just created.
  • Method: Choose GET.
  • In the URL field, input your CSV URL.

3.Parse the CSV:

  • To convert the CSV response to JSON format for the table, you can use a JavaScript transformer.

4.Displaying the Data in a Table

3 Likes