-
Append with UpsertKey Columns Set to True
I am appending data to a Domo dataset and it works great. But, there are duplicates. So, I created an identical Domo dataset and then modified the schema so that upsertKey is set to true on two of my columns. When I try to upload my file to this new dataset configured with upsert key columns, I get an error saying to few…
-
How to append Doc cards with XLS data?
I have several Doc cards with XLS data inside them. I'm trying to find a way to combine these Doc cards' data by just appending them. Is there a way to do this in Domo, or perhaps even a third-party system?
-
Can I update a dataset on DOMO without having to load the entire dataset?
Right now I have a dataset in DOMO with a certain number of columns. If I append to that dataset using datasets.data_import with a dataframe that has an additional column the data upload is rejected. I want it to accept the import and add an additional column in the dataset in domo Currently the way I do this is by…
-
Issues With Triggering Campaigns App With An Alert
I've been following along with https://domohelp.domo.com/hc/en-us/articles/1500000316201-Triggering-a-Campaign-from-a-Domo-DataSet-Alert#2.2. I am currently at the point of testing the POST to the API in the WebHook and I am getting the Error: { "status": 400, "error": "Bad Request", "path": "/api/v1/campaigns/bae/start" }…
-
Beast Mode to Fix Revenue per Item at the first entry (so compare the rest)?
Imagine the following: Item Revenue (Vs 1st Entry) A 100 0 B 80 -20 C 60 -40 Any ideas on how to write a beast mode that first fixes the first entry of the rows to a constant value for all rows (then writing a companion beast mode of the variance row by row is trivial)? I've tried to SUM(SUM(Rev)) OVER (PARTITION BY Item)…
-
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…
-
PROPER Function in Views
Attempting to add a Calculated Column to a View and am unable to find the PROPER function. Is this function supported in Views or is there another function available that produces the same outcome?
-
Brand Kit Color Select
Hi, The new brand kit feature color creator doesn't seem to work as intended. When you put in the hex code and save, the color code changes just slightly. For example, if I create a new Hue and enter #66A4CD, after saving, the code changes to #69A4CB
-
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…
-
Can you stream Salesforce data in real-time?
Hi Domo Community, Can you stream data from Salesforce into Domo in real-time? We recently switched to Domo for dashboarding and reporting. Our call center relies on Domo dashboards to set in-person appointments. The issue is that by default data can only be sent to Domo every 15 minutes. (Note: Our previous tool allowed…
-
PYDOMO SCRIPTS DEPLOYMENT
Is there a way I can deploy my automation using PYDOMO in DOMO Magic ETL or a workflow within DOMO? I wrote this using jupyter IDE.
-
How can we download list of beast mode made on particular Dataset ?
Like I can see the list of all beast mode on a particular dataset on beast mode manager .But I want to download them also as per the particular dataset . Suggest me some way if there is any .
-
When I click on Edit View domo goes blank and I can't edit. What is happening?
This is something that happens somewhat frequently with different aspects of Domo. Has happened with views, ETLs, beast modes, and cards. At this point, we are starting to transfer dashboards to Power BI. We're paying extra for a personal support team from Domo, and they take forever to respond, and when they do they give…
-
Error retrieving a Domo API Access Token
I was running a python script that connects to Domo using my client id and secret and it was running fine till about an hour ago when I started getting an error message: File "/.virtualenvs/strat/lib/python3.8/site-packages/pydomo/Transport.py", line 87, in _renew_access_token raise Exception("Error retrieving a Domo API…
-
Scatter graph marker color.
Hey, I'm currently trying to change the color of the marker between set ranges (1-12)(12-26)(26+). Does anyone have any advice on doing this in the DDX scatter graph? Thanks
-
Batch Last Run Columns with API Updates
Is it possible to configure the Dataset to automatically add a "BATCH_LAST_RUN" column when updated via the API rather than doing it manually within the API program before the update is made? Thanks, Will
-
Can you use domo.navigate() on a card that redirects user based on user ID?
I am trying to build out a dynamic dashboard that contains cards that act as buttons. Right now I have this "dynamic dashboard" built out for each user and redirecting them based on the URL that is linked to that card. What I want is a a single dashboard that is shared among all my licensed users, built out with a ddx that…
-
Upload S3 file that contains a header
Hello! I have CVS files in S3. I am able to upload them using the upload-s3 Domo CLI command. However, my files have a header, and it seems the upload-s3 command does not have a option to ignore the header. For instance, there is no -h --header flag. Is this true? Is there no way to skip the header for in a file coming…
-
Can we achieve a drill down and filter interaction at the same time in dashboard.
[Scenario: we have a Chart which has a drill down granularity and when we click on the chart it will drill through to next chart, but it not filtering other charts, Is there any options to achieve this.] The user wants the dashboard to be interactive if we click the drill-down bar chart.
-
Workbench Job to DOMO stuck on "Connecting"
I have a workbench job that has been in the "connecting" state on the DOMO side for over 4 days. Is there anyway to kill it? The job on the workbench side has already been stopped.
-
generate page and cards programatically
Hi would it be possible to save a card template using the CLI and then using that template to create a page with that card in it? I want to generate a lot of pages programmatically with some sort of card template. Like 1000 versions of the same page with a different data set for each page.
-
rdomo How to append data
I'm trying to append data to a data set (created via rdomo) using the rdomo package. I've tried with the ds_update function but it looks like it's replacing the data. Is there any other function I can use?
-
Domo Embed & Custom Apps
Hi there, Is it possible to embed a custom app? Is this done by adding it to a dashboard which is then embedded? Use-case: Salesperson logging into our corporate website to see their sales figures filtered down to them via Programmatic Filtering. Or being able to add/modify customer notes listed in the App. Thanks for your…
-
API and download large dataset
Hello -- I need to extract data from a 20M row dataset. I can download smaller datasets, but when I try to download a large dataset, I get a timeout. Can I apply a filter (like date) to the download request for the larger dataset? Thank you
-
API DataSet export using RestSharp.RestClient
Folks, I have a valid client ID and Client Secret, and I can export the data I want using Postman. But I need to do this thru C# code in Linqpad, and it fails every time. (The .Dump() method below is their clever variation on Console.WriteLine().) RestClient dataClient = new RestClient("https://api.domo.com"); RestRequest…
-
Dategrain combined with aggregation
As I can read here: https://developer.domo.com/docs/dev-studio-references/data-api#aggregations "DATEGRAIN Perform a groupby with predefined date grains. By default, numerical columns are summed and unique entries of non-numerical columns are counted. Can be combined with an aggregation to override this default behavior."…
-
Domo Embed & Custom Apps
Hi there, Is it possible to embed a custom App or a custom app that is on a dashboard? Use-case: Custom app embedded on our corporate website for our sales team that shows each member's sales filtered via Programmatic Filtering. I want to be sure they can still interact with the App. Thanks for your help!
-
Where can i find the Comments logs
when you update a card there is an option "Save and Comment" this comments are stored some where?, need to keep track of the update comments, is there a log or dataset that i can use for this matter? Thansk in advance to all
-
Is there an API for viewing and manipulating DataSet tags?
Hi, we would like to do something via the API where we search for DataSets with specific tags and also add and remove tags for DataSets. I have been reading through the docs for the DataSet API but I couldn't find any info for how to do this (or if it's even possible). I also skimmed through the other topics in the API…
-
DDX Bricks vs. regular old custom apps
I am ready to jump into custom apps but I wonder if I should just wait for the DDX Bricks? From what I have read in the limited information available the DDX Bricks could be a simpler way to create custom visualizations without having the complexities of the existing custom apps?