For working with uploads, keep in mind that:
- File has to be < 200 MB
- Column names in the table can’t start with a special character or digits.
- Private uploads require a Premium subscription.
- If you upload to an existing table name, it will delete the old data and overwite it with your new data. Appends are only supported for the
/create,/insertendpoints. - To delete an upload table, you must go to
user settings (dune.com) -> data -> delete.
Upload via google sheet
To automate the upload of a Google Sheet’s contents to Dune via API, use the following Google Apps Script:- Open your Google Sheet
- Navigate to Extensions → Apps Script
- Replace the script with the code above
- Save and run uploadToDune
- (Optional) For easier execution, you can assign this script to a button in your Google Sheet:
- Click “Insert” in the Google Sheets menu
- Select “Drawing”
- Create a button shape and add text like “Upload to Dune”
- Click “Save and Close”
- Right-click the button and select “Assign script”
- Enter “uploadToDune” as the function name
- Clicking the button will now upload your active sheet’s data to Dune!
Headers
API Key for accessing this service
Body
application/json
The data to be uploaded in CSV format.
Example:
"DATE,DGS10,\n2023-12-04,4.28,\n2023-12-05,4.18,\n2023-12-06,4.12,\n2023-12-07,4.14,\n2023-12-08,4.23,\n2023-12-11,4.23"
Description of the upload.
Example:
"10 year daily interest rates, sourced from https://fred.stlouisfed.org/series/DGS10"
The name of the table to store the data.
Example:
"ten_year_us_interest_rates"
Indicates if the upload is private.
Example:
false