-
DataSet query and connection information
I'm trying to retrieve information about a dataset, such as the underlying connection and query. The specific dataset I want info on is a SQL Server Connection based dataset. How would I go about getting the query and connection used by a dataset? I looked at the DataSet API (https://api.domo.com/v1/datasets/{dataset_id}).…
-
Request for Assistance with Custom Add-on Development for Excel-DOMO Integration
Dear DOMO Developer Forum Team, I am Daniel, and I am currently leading a project at my company to develop a custom add-on for Excel, aimed at enhancing our analysts' interaction with DOMO. While we appreciate the existing DOMO Excel add-in, our specific needs require additional features, particularly in the area of data…
-
Using Domo with an Integration Platform for Automated Action
I'm a big believer in BI being much more than simply connecting up all your data and creating read-only dashboards. More and more of our projects should be focused on process automation and integration. These types of projects have a meaningful impact on the business and can help quantify the value of a BI team. Made a…
-
Sync to DataSet
I downloaded the public "Form and Dataset Brick" ddx brick, developed by domo, and was wondering if anybody knew how to make it so that, when clicked, the "SyncButton" populated the ddx brick with data from a dataset?
-
Receiving unable to connect unless we disable Xframe options check
We are receiving a cross origin access error while embeding domo as an iframe into our portal. As a work around If we disable the xframe options check then it is working as expected How can we fix this ?
-
Pydomo: Error with 'ds_get'
I am trying to read a domo dataset in Python through pydomo. I got an error about encoding. My data contains name/address which may have special characters. I manually downloaded the data to csv and read it in with read_csv and had the same issue initially. However, if I include 'encoding='latin1' in 'read_csv' parameter…
-
DOMO Card Variable access via API
I created a DOMO Variable to filter metrics by period-to-date values across several Cards. These Cards are embedded and displayed together within our product's UI on the landing page (no filters shown). The variable functions as expected within DOMO. How am I able to call this variable through the API as I would a regular…
-
Is there any way to get Embed Id programmatically using DOMO APIs ?
As part of our requirement we need to display all dashboards present in DOMO as list of Iframe options in our organization UI and based on user selection we display the selected dashboard. For this we are looking if there is an API which can return dashboard embed id ?
-
Is there any way to get Embed Id programmatically?
I integrate with DOMO using java SDK and REST API, and I can get dashboard id or card id without any problems. But then I need to embed them on our site. But I see that the iframe for embed that will only use the dashboard/card id mark as deprecated, and now it is necessary to use the iframe with the Embed Id. Please tell…
-
DOMO API to grab snapshot
Hello All, I am looking for DOMO API to grab snapshot of the dashboards which I will be using in python to automate. Can someone help?
-
DDX: Getting Data in DDX form
Hi, I'm trying to bring in data in a DDX form, from a Domo dataset column using domo.get api using the following code. But I keep getting [object Promise] as a response. All I'm trying to do is getting the distinct value of column "Version" and populate in one of the DDX form input. The value in this column is same for all…
-
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?
-
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":"######"}
-
No Access issue on API Tokens
I have generated client secret and ID using my admin access domo account. But when I try to access the embedded dashboard with programmatic filtering in PHP Laravel, I am getting the following error, "You don't have access to any role/module. Please contact your company admin." I want to get an embedded dashboard with some…
-
What are all the reserved words in creating a new dataset?
We are using the Stream API to create datasets. This is all dynamic so we have no idea what the data is going to be or what the columns in the source data are called. What we found is that if the source data has a column named 'row_number' the call to create a new stream dataset will fail but with no message or…
-
Is it possible to achieve last 30, 60, 90 days from the current date
When I am trying to achieve last 30, 60, 90 days from the current date, it is displaying as (0- 30 days), (31-60 days) and (61-90 days) in the data when filtered, but the requirement was (0-30 days), (0-60 days) and (0-90 days). Calculation: For date range Iam using this calculation Date range: DATEDIFF(CURDATE(),(`Date`))…
-
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?
-
What does the CONTAINS operand do in pfilters?
Can someone please explain to me how the CONTAINS operand works in pfilters? I had thought it was like a SQL "LIKE" comparator, but that doesn't seem to be correct.
-
Color rules in Domo Phoenix
Hi all, I am using the DDX Phoenix Scatter Plots App and wanted to apply some color rules like you do in a regular card in Analyzer. I was looking at the documentation but it is only shown how to change the color palette, not how to apply color rules (ex: if Metric < 1 then red else green). Do you have any suggestion?…
-
How to Connect NSS APIs to DOMO
Most of the Security Apps have secure API with OAuth2 and i having issues with connecting with DOMO JSON connector apps as they take SFTP server and the API are using NSS. Can you tell me a way i can connect these API to DOMO
-
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.
-
How to append data to an existing dataset using the API?
Currently update dataset API replaces the existing data with the new data. Is there a way to just append the data instead of replacing?
-
Is it possible to use an Excel macro to execute the Domo plugin?
I have a Domo plugin in Excel to connect to our Domo instance and pull data to refresh an Excel document that generates a Pivot table since there are limitations in Domo that prevent us from displaying the data in that particular format. I can use the plugin without any problems, but I cannot automate it using an Excel…
-
Regression Line - Hover/Label Text
Hello, I wonder how %_slope is being calculated by Domo within the Hover or Label Text fields in the Regression Line Chart Properties. When I tried to calculate the numbers within the last 3 months, the result is consistent with Domo's calculation of slope (%_slope). However, I couldn't figure out why Domo's calculation of…
-
Does the API's dataset/export method work?
I'm building a PHP client library for Domo, and I'm currently having trouble with one of the endpoints. Specifically: API Docs: Endpoint: /v1/datasets/{dataset_id}/data Method: GET According to the documentation, if I call that endpoint with the GUID of a dataset, it should return CSV content to me in the response body.…
-
What API do I need to pull data from a website?
Is it possible to pull event history and container information from a railroad website?
-
upload-snowflake prevent indexing
Hello, when I use the upload-snowflake command, is there a way to tell Domo not to index? When I load data from Snowflake to Domo, I load based on partitions. Since I load data in this way, I'm thinking that I don't need indexing. Or maybe I'm wrong? Thanks!
-
Can't embed new dashboards, has API changed?
Hi, we recently made a new dashboard(potentially a few months ago) and are trying to embed it using the same form technique as suggested by domo. This currently works with our year or so old dashboard, but upon changing to the new embed ID (no other changes, same access code flow, etc. etc.) we get: GET…
-
Connecting to domo.js in React app not working
Hello all, I am a first time domo app dev trying to create a React app. I used the Quickstart instructions for creating a React app using the template and everything seemed to be setup correctly . When I try to use 'domo.get()' or 'domo.env..', I get a 'domo not defined' error in my application. I am logging into my DOMO…
-
Metadata through API
Hi! Is it possible to retrieve dataset column description and tags through the API (or PyDomo or rdomo)? Thanks, Carlos