-
PyDomo issue to upload data em update dataset
I'm having trouble to upload my data to Domo using the PyDomo API. I read some .xlsx files and aggregate this files in one dataframe with the code below: Then I try to update my dataset using this code: domo = Domo(cliente_id, secret, api_host='api.domo.com') dataset_up = domo.ds_update(dataset_id,df_final) However I keep…
-
Domo Jupyter - Account without "Allow Authorize users to access unencrypted credentials" not checked
A great feature to allow control over if an account can be accessed as plain text in Jupyter could use come improved clarity in the endpoints response. However because this feature is inside the "show advanced options" it's not necessarily obvious what's occurring here. An endpoint in the Python module domojupyter being…
-
Does Domo publish a list of new releases or version changes made to their APIs?
Does Domo publish a list of new releases or version changes made to their APIs? I am seeing a case where we are pulling from the data sources API but looks like the data type returned in the API call has changed, causing some things to break on our end. This is an API call to the endpoint: 'https://{our business domain…
-
Can I use Python libraries in Domo?
Hey everyone, I’d like to use scipy.optimize in Domo to perform optimization calculations (similar to Excel Solver). Since MagicETL has a Python Tile, is this where I should implement it? Thank you!
-
Do I have the right code in my Python Script?
Hi, Select Columns 2 has four columns, they are EFFDT, ACAD_PLAN, DESCR, and ACAD_CAREER. I wrote a Python script to filter the EFFDT column so that it only includes rows where the value is 'A'. However, when I try to join this dataset with another, I receive an error stating that the referenced column, which is the…
-
Can we import a custom package created in one Code Engine to another Code Engine?
I want to know if it is possible to create a local Python package in one Code Engine of Domo, then import and reuse it in another Code Engine. For example: Create functions or a custom package in a first Code Engine. Share this code with another Code Engine to avoid duplication. Is there a native way or alternative…
-
Solution Share: Using Python to Bulk Rename Columns and Convert Timestamps
Hey Domo Fam! Wanted to share a success story using Magic ETL + Python scripting to solve a problem. My first use of a python tile! Challenge I'm building a Company Dimension table using Hubspot company data...all connector reports have technical column names (over 450 columns) and all date fields (50+ columns) are a mix…
-
PyDomo - DS_Update to Append Data?
Hello all, I've written a script that ideally will create a datastream into Domo. At the moment though, I'm struggling to find a way to replace the update method of ds_update() from PyDomo. The default appears to be replacing the data, but I need to append the dataset. Does anyone have any experience with this? Any help…
-
Python NLTK Vader Lexicon not available
Hello, when attempting to import and use the vader module, I'm getting an error from nltk package saying I need to download 'vader_lexicon' This feels super basic so I'm sure I'm just doing something wrong. Any thoughts on what else to try?
-
Domo API to import files to domo
domo = Domo(client_id, client_secret,api_host=api_host) I want to add an additional argument here that is updatemethod=Append. I am not sure what the correct syntax for this would be. For extra context, I am currently reading files into python and essentially once I read these files in, I want to combine them and then…
-
Python Requests Library in Codeengine
Hello, I have started using the codeengine to create API calls to automate some of our tasks with systems outside of Domo. Python is my primary language and I have noticed that I have not been able to find documentation on making the calls with python. I know there is support for calls using JavaScript and I have been…
-
Using Email in Jupyter Workspace - Python Scripts
Hi All, I was trying to trigger and send emails from the Jupyter workspaces. I have the list of emails to whom I need to send and I also have the subject and body of the email ready, but I'm not able to connect to the DOMO Notifications Email which is being used by Card alerts and Workflows to send out emails. Is there any…
-
Support code engine packages in Connector Studio IDE
I recently had a requirement to fetch a file via API, but the file was encrypted. I wanted to create a connector the whole org could use that supported decryption for the source system, but the connector studio was so limited that I ended up using a Jupyter notebook to solve the issue. The problem is now everyone will need…
-
Errors when using domolibrary with client ID and secret
Background and setup: I created a client using developer.domo.com and gave it the "data" scope. I have a client ID and secret now. I have tested it using the PyDomo library and it has worked. However, my goal is to programmatically get and store dataflows as an off-Domo backup. Domolibrary was recommended in another…
-
Dataset reference in Python by identifier instead of name
To identify input dataset by identifier instead of name, very useful for working with Python modules, as right now you need to update the source code when changing a name.
-
What is the best way to integrate python into a Domo connector?
Is there a preferred way to integrate python into a Domo connector outside of using Jupyter Workspaces?
-
Is PyDomo appropriate for my data update work?
Hello. I've been reviewing different methods of updating data in Domo. I'm currently using Workbench, but am considering creating a completely hands-off setup using PyDomo. So, here's my scenario: We have a number of datasets that originate from ServiceNow. I put those through some local processing using Python scripts,…
-
Jupyter Workspace upsert data with composite keys
Hello! I've been investigating domojupyter.write_dataframe to upsert data. My dataset has a composite key, two Integer columns. My suggestion is to make UPSERT in Jupyter consitent with other DOMO ingestion methods, by updating the domojupyter package to allow for composite keys. ie ["ItineraryId", "ItineraryItemId"]…
-
With the domojupyter.write_dataframe can you pass a specific schema?
Hi All, Am trying to write a DataFrame to a dataset using the domojupyter.write_dataframe function. The df in question has a field that is a Boolean, when I run the script and then check the output dataset in the domo Data section, the field has been created as an Integer and the entire column is blank. Question is, can…
-
Jupyter Notebooks Python - Dates
Hi Domo Experts, I'm having issues writing back dates into a dataset from a pandas dataframe in Juptyer notebooks. I have a datetime column , which I've converted from a string using pandas.to_datetime. However, when I use domojuypiter.write_dataframe, they are converted back into string in the Domo dataset. My dataframe…
-
Domo Python SDK
I have been using the Python SDK to send csv data to Domo via API using the data_import_from_file and have done so successfully. However, I also need to send xlsx files to Domo, but have not been able to successfully do so using the same method. Is the method capable of sending xlsx data using this method?
-
Dataset not updating.
Can someone help me with this issue? I'm trying to pull the data from databricks (using python script) into domo dataset. First I'm trying to create the dataset for a single date using #domo.ds_create(df2,'datasetname') then I'm trying to update the same dataset daily. the below code worked till yesterday and its only…
-
Exception: Error retrieving a Domo API Access Token
I keep getting this error when i call Domo(domo_client_id, domo_client_secret, api_host='api.domo.com') Exception: Error retrieving a Domo API Access Token: {"status":401,"statusReason":"Unauthorized","path":"/oauth/token","toe":"######"}
-
How can I add to a dataset previously created using the DOMO Python SDK?
I am using the Python SDK to upload csv data to domo. I have been using the dataset.py methods and have been successful in getting my data to my domo domain. Although, everytime I upload a csv, it will create a new dataset. How can I make it so that my data is added to a previously created dataset?
-
How come I cant access Domo through the API?
It was working fine before, I get authorized but now my python script is giving me a 403 status ("Forbidden" error) when trying to retrieve a dataset out of Domo. Is there a rate limit I'm hitting? Quite confused. Any assistance is welcome.
-
Multiple outputs for Python modules
Python boxes in the Domo ETLs allowing multiple outputs.
-
More info in logs
It would be very useful if, when executing a Domo ETL, a log file was generated to see the details of potential failures in the process. Currently, if there is a failure in any of the Domo's own boxes, you see that the process has been interrupted in a part of the process but we don't see the details. Also, if the process…
-
Domo API to MS-SQL
I tried unsuccessfully to find an example of pulling a Domo dataset directly to MS-SQL via the API. So I created my own. I am not a python coder but my script works just fine. Does anyone have a version of this subroutine that does not require defining the column names (ie header)? #Retrieve dataset from Domo API def…
-
ValueError: The truth value ...
Hi Folks, I'm having an issue with a Python tile in Magic ETL , the code works on my machine (pycharm) but throws an error once in Domo (this happens often, what's the difference?) ValueError: The truth value of an array with more than one element is ambiguous. Use a.any() or a.al The goal is to produce a string value…