uploading data to a dataset - Domo Developer API
I am pretty new to Domo Developer. I would like to use a python script to daily upload data to a dataset. Here is my script.
def append_data_to_dataset(dataset_id, dataframe, access_token):
"""
Append a pandas DataFrame to a Domo dataset.
headers = { 'Authorization': f'Bearer {access_token}', 'Content-Type': 'text/csv' } url = f'https://api.domo.com/v1/datasets/{dataset_id}/data/append' # Convert DataFrame to CSV format (without index and header) csv_data = dataframe.to_csv(index=False, header=False) try: response = requests.put(url, headers=headers, data=csv_data) response.raise_for_status() except requests.exceptions.RequestException as e: print(f"An error occurred while appending data: {e}")
Creating the token has worked fine, creating a dataset as well. However, when I try to append data to the dataset I am getting a 404. Anyone can help with this problem?
Best Answer
-
The append endpoint doesn’t exist hence the 404 try using data?updateMethod=APPEND
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
404 means you’re trying to access something that doesn’t exist. Does your UTL correctly include the proper dataset id?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Yes, it does. Here is the error:
Failed to append data. Status code: 404Response body: {"status":404,"statusReason":"Not Found","path":"/v1/datasets/65ed1f73-c0c7-498d-8c91-75bc445f229a/data/append","toe":"H4JO5HQ84R-BH64P-3O5VA"}
0 -
The append endpoint doesn’t exist hence the 404 try using data?updateMethod=APPEND
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 388 Distribute
- 111 Domo Everywhere
- 271 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 9 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive