uploading data to a dataset - Domo Developer API

mroker · February 11

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?

GrantSmith · February 12

The append endpoint doesn’t exist hence the 404 try using data?updateMethod=APPEND

GrantSmith · February 12

404 means you’re trying to access something that doesn’t exist. Does your UTL correctly include the proper dataset id?

mroker · February 12

Screenshot 2024-02-11 at 11.59.55 PM.png

Yes, it does. Here is the error:

Failed to append data. Status code: 404

Response body: {"status":404,"statusReason":"Not Found","path":"/v1/datasets/65ed1f73-c0c7-498d-8c91-75bc445f229a/data/append","toe":"H4JO5HQ84R-BH64P-3O5VA"}

GrantSmith · February 12

The append endpoint doesn’t exist hence the 404 try using data?updateMethod=APPEND

mroker · February 12

uploading data to a dataset - Domo Developer API

Best Answer

Answers

Categories