-
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."…
-
Trying to use SSMS to connect to Domo Server via Domo ODBC Driver
I have configured the Domo ODBC driver and setup a DSN. I'm trying to establish a connection to the Domo Server so I can query multiple tables via SSMS. My understanding is that this needs to be done through a linked server. However, I have not been successful getting the linked server to work. Has anybody been able to…
-
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?
-
Export card data using Python, PyDomo
Good afternoon, I would like to download card data in csv directly from python using PyDomo, would it be possible? The function I was trying to use is domo.page_get_collections But I didn't have much success, could someone explain to me how I can export this data from the card to python? I want to send to aws automatically
-
Go to next page in List of Users?
I'm using Python and I'm able to get the first 500 users (which is the max according to the docs) but then how do I get the following 500, etc.. we have thousands! This is what I have so far: import requests import json url = 'https://api.domo.com/v1/users?limit=500' headers = {'Content-type': 'application/json', 'Accept':…
-
window.addEventListener("message") does not trigger when card is clicked
Hi experts, I have successfully built and ran the sample. My card is loaded. Now I want to watch the event of card clicking and get out the selected data. With the help of Domo, the event of message will be just work when card is clicked, or filter is changed, but nothing happened. I also tried to change column&value of…
-
Domo dependency (domo-java-sdk-all) issue
When I defined compile group: 'com.domo', name: 'domo-java-sdk-all', version: '0.4.0' in the gradle dependecy, it fails to load. Seems because bintray-domo is disabled. Is there any alternative repository?
-
Getting Current User Profile Data
I'm currently working on a custom application that allows users to submit data. We would like to be able to capture a field from their Domo profile in order to apply PDP when showing the data that they have submitted. Is there a way that we can capture current user data from Domo when the user is viewing the card?
-
Api fails for filters
Hello folks, need help over domo programmatic filters. While calling api it's gives us a error https://public.domo.com/embed/pages/my embed ids /stack?parts=metadata,datasources,drillPathURNs,domoapp,slicers,dateInfo&includeV4PageLayouts=false But i have no idea for what case is happen error logged `{ "status": 404,…
-
use fields from different tables group by date to calculate percentage
Hi, I am trying to calculate a percentage using two fields from two different tables in SQL Magic Transformation. Table a looks like this: Date All Revenue 09/01/21 100 09/02/21 200 Table b looks like this: Date HDM Revenue 09/01/21 90 09/02/21 170 I need to build a table that would calculate the percentage of HDM Revenue,…