-
'None' response when calling Domo SDK to append data into dataset
I am trying to append data into a dataset I created using the API but I get this error: Failed to import data into Domo: 'NoneType' object is not subscriptable. The dataset is created successfully but then I get that error message when trying to append the data into it. After some troubleshooting I found that the 'None'…
-
Adding a Python Function or Google Translation into the Magic ETL
Hi, I am currently pulling Datas of Twitter's feed of specific words from the twitter connector on DOMO. As most of the tweets are in Japanese, i was wondering if there a function/calculated field i could use to translate those japanese tweets on the Magic ETL. Do guide me on the process if it is possible. Thank you!
-
NEW Domo Data Science Resources Guide (help w/ Jupyter, scripting tiles, data science tiles, AutoML)
Hi all, I'm a data scientist at Domo on the Data Science Professional Services Team. We have a NEW Domo Data Science Resources Guide. The guide includes a list of all the help resources Domo has created related to data science products (Jupyter Workspaces, Magic ETL R/Python scripting tiles, Magic ETL data science tiles, &…
-
Is it possible to make a HTTP request using the Python Script tile of Magic ETL?
We would like to use data of a dataset in the body of a POST request and we were wondering if the Python Script tile in Magic ETL would work for that. We have analyzed but it does not seem to have libraries for that. We have this solution to export the dataset and make the request in a Python script in a Virtual Machine…
-
write_dataframe fails to write output of pd.pivot_table having Nulls
Domo python tile fails to write the pivoted dataframe with pd.pivot_table if it has nulls while converting - even if you add 'fill_value=np.nan'. See below: The pivot function works perfectly fine - it does generate the df, however, when you try to write it, it fails - see below if I write the unpivoted df, it works fine…
-
Can we get more packages added to Python Scripting tiles?
I could really use pandas-datareader in an ETL. I know it's available in Jupyter Workspace, but its availability in a Magic ETL would be convenient for me.
-
R and Python for determing dataframe equality in ETL
Greetings Domo Community, I have currently been refactoring Magic ETL tiles and have been attempting to use Python and R scripts to test for equality before finalizing the refactored tile components. Using both approaches with Python and R I have had significant difficulties in completing this task, which I will outline…
-
Daily Dataset Update via Python fails on first run each day
I am using the Domo Dimensions Calendar as an input to a Python script that updates an dataset of the next 365 days as columns |2023-01-27 | 2023-01-28 | 2023-01-29 | 2023-01-30 | ........ | 2024-01-27 So, when the script runs tomorrow the first column will be 2023-01-28, and so on. It works, to a point. The first daily…
-
Using Python API to Update Already Created Datasets
Hi Everyone, I am trying to find a way to upload information from a python script into a domo dataset weekly. I am finding that you can't update an existing dataset with this method, only create a new one and update that newly created one. Has anyone found a workaround for this? In the documentation it appears this is…
-
pydomo export_dataset - exporting Domo dataset with millions of rows failing
I have the below that exports a dataset to a string, I'm trying to export a dataset with 257 million rows but I don't see any logs as to why it fails It just fails! When I try the below with a smaller dataset (250k rows) I'm able to export, is there a way to programmatically break out the dataset into chunks? domo =…
-
Uploading Domo user photos via Python?
I've been experimenting with the Python package Pydomo and have found great success implementing it in our org. I have now automated how we update user's department, title, and even manager using Python. Now comes the hardest part: updating a user's photo. I have access to everyone's photo via Workday, and I want to be…
-
Import CSV File via Python (Domo API)
Hello, community, I am currently writing a python app that will allow me to import CSV data (per the requirements of the developer.domo.com API reference). When uploading the CSV file via the python SDK and/or using PUT command, I get a 400 error. Error: Error uploading DataSet: {"status":400,"statusReason":"Bad…
-
pydomo CreateUserRequest attributes
I gather the CreateUserRequest() class in the pydomo SDK only accepts three attributes: name, email, role. That's a surprising and very restrictive limitation considering the API seems to work with every attribute of user profiles. It would be great to update this to work with more or all attributes, in particular:…
-
pydomo ds_query - api limit for large dataset broken out into many queries
Is there documentation on how many queries can be made, and what the API rate limit is? I have an extremely large dataset and I have to break it out into like 100 hundred queries but after the 10th query is run it breaks.