-
Domo Simple API - Insert null value using json
It seems Simple API does not accept null value in json format. How can I insert null in a column using API? I tried "" and it works but this recognizes the column as string, if I need a int column or date column, this approach it's not what I'm looking for. Thanks!
-
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?…
-
Export metadata on connector datasets
We need to export metadata for all datasets that use certain connectors. Specifically, we have created a large number of datasets using postgresql and bigquery connectors. We need to export (1) the query used for each dataset, (2) the dataset id for each dataset, and (3) the name of each dataset. I know it is possible to…
-
Add embed token as query parameter to the iframe src
When intergating with Domo Everywhere, creating a iframe is one of the main pain points. This should not be the case. In an ideal world, the iframe would look like this: <iframe src="https://public.domo.com/embed/pages/:embedId"> </iframe>However, as we need to pass the embed token as well. Insted of doing it via Forms and…
-
Is it possible to get a dataset id using a dataset name?
The API docs show it's easy enough to get metadata on a dataset using the https://api.domo.com/v1/datasets/{DATASET_ID} command, and you can get a full list of datasets using https://api.domo.com/v1/datasets which includes a full list of dataset names too But the second API call is quite slow due to the number of datasets…
-
Twitter cannot authenticate
Hi! I've got an issue with the Twitter authentication since 03/30/2023. It says: "Domo is ready, but Twitter returned Could not authenticate you." When I tried to re-connect the credential, I got only a blank popup window, and nothing happened. If I tried to create a new credential, I got the same blank window. I checked,…
-
data/v1 endpoint - Filter on columns and values with spaces in their names
Is it possible to filter results on the data/v1 endpoint with columns or values that have spaces in their names? I've tried every combination imaginable to get results for a column named Spend Category, but continuously get this 400 error. Filtering results with columns and values that don't have spaces works as expected.…
-
Facebook Advanced Ads Connector - Choosing Specific Insights vs All
Currently in the Facebook Advanced Ads connector, there is no way to select specific insights you want your report broken out by. There are 60+ insights from video views, add to cart, add to wishlist, purchases, etc. but in my case I would like to only select <5 insights. If the report doesn't need to pull all the insights…
-
Extended DataSet information on DOMOStats
Can we get DOMOStats to include some of the additional information available on cards like in the API or CLI? While DOMOStats is great, there are some key funcionalities it lacks that are already available through the API and CLI and that would be a huge help when it comes to managing the instance. Some of the top of mind…
-
Javascript field name has spaces
I have tried back ticks, brackets, everything I can think of The script below works correctly and provides the results that I expect, but I really need to put Account Level 9 in the var where Specifically Account Level 9 = Administrative expense but when I add the field I get nothing. I can see the record in the output…
-
DomoR vs DomoSDK?
I have been handed an r script that has is using an accessToken to connect to domo and extract a dataset using a dataset ID. My end goal is to translate this to Python, as I have an existing pipeline in python that needs this dataset. Initially using the naive approach I tried to connect to Domo using pyDomo but was…
-
OKTA - DOMO API Setup
Hello, I am running into an issue with setting up a Domo API connector in OKTA, looking to create some workflows to add and remove users to my account. When I go to setup the connector in OKTA it is asking for the following pieces of information, I have more than half of the information but I am getting an error when I…
-
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…
-
Details about, and alternatives to, the DataSet query API
I gave the datasets/query/execute v1 API a try today, and have a few questions: * What idiom of SQL is this using? It took me some time to get the name escaping done in a way that Domo tolerated. * Is there any dedicated documentation on the system, other than the sparse details I've found at…