Change Update Method Using Pydomo

user059353

Created a dataset using Pydomo.

ds_update method does only a REPLACE.

Not sure how to change it to append.

Any help is appreciated. Thanks!

GrantSmith

.

user059353

@ElliotGitter @GrantSmith answered it correctly.

After you authenticate

domo = Domo(client_id, secret, api_host = api_host)

datasets = domo.datasets

csv_file_path = './yourfileaname.csv'

datasets.data_import_from_file(dataset['yourdatasetid'], csv_file_path)

The following link should help :https://github.com/domoinc/domo-python-sdk/blob/master/examples/dataset.py

amehdad

Hi @user059353, you could use ds_import:

ds_import(ds_id, df_up, update_method = "REPLACE")

where

ds_id: Data set id (from url in Domo).

df_up : Dataframe to upload.

update_method:Optional choose the appropriate updateMethod when importing data via the API. Available choices are either to APPEND or REPLACE.

user059353

Hi @amehdad.

The ds_import function is not available in the PyDomo module.

I get an error when I try to inspect the arguements.

>>> inspect.getfullargspec(Domo.ds_query)

FullArgSpec(args=['self', 'dataset_id', 'query', 'return_data'], varargs=None, varkw=None, defaults=(True,), kwonlyargs=[], kwonlydefaults=None, annotations={})

>>> inspect.getfullargspec(Domo.ds_import)

Traceback (most recent call last):

 File "<stdin>", line 1, in <module>

AttributeError: type object 'Domo' has no attribute 'ds_import'

amehdad

Definitely reach out to Support [support.domo.com] then to have them look at it as well (and escalate to Dev if need be).

ElliotGitter

This didn't work for me either (using python), did you ever figure this out? The only problem is, my ds_update is only appending now. Wish there was a clear function like the import noted above that worked.

GrantSmith

.

user059353

@ElliotGitter @GrantSmith answered it correctly.

After you authenticate

domo = Domo(client_id, secret, api_host = api_host)

datasets = domo.datasets

csv_file_path = './yourfileaname.csv'

datasets.data_import_from_file(dataset['yourdatasetid'], csv_file_path)

The following link should help :https://github.com/domoinc/domo-python-sdk/blob/master/examples/dataset.py

xywust2014

Unfortunately, ds_import and ds_rename functions are not available now.