-
Creating a Stream
Hello! How can I create a new stream? Thank you in advance!
-
Can there be a filter in the Webform while in edit mode.
-
Unable to delete PDP policy in a dataset using API
Hi, I'm new to using APIs to interact with DOMO PDP policies, so I've follow instructions 1/ Create a client in 2/ Install pydomo Python package 3/ Run Python code from pydomo import Domo from pydomo.datasets import Policy, PolicyFilter, FilterOperator, PolicyType, Sorting domo =…
-
Can anyone walk me through the steps to upload a dataset via the API?
I'm running into a couple issues trying to get this to work. I think (but am not sure) that the dataset has to initially be created by the API. If that's the case it requires a schema file and I haven't gotten one to work correctly. Anyone have an example that I can use? Once that is done, if anyone has a working script…
-
MySQL DataFlow
I am having hard time in joining two tables using MySQL DataFlow (transform). SELECT a.Name, a.Id, a.state,b.Year,b.Gender from state a join national_names b on a.Name = b.Name anda.Year = b.Year
-
join two tables with date comparison in where clause MySQL
I have two tables that I need to join based on the date differences. Table a looks like this: ``` Date Partner Revenue 12/01/20 Cosmo 10 12/01/20 Esquire 5 ``` Table b looks like this: ``` Date Partner Revenue 12/01/20 Cosmo 10 12/01/20 Esquire 5 12/02/20 Cosmo 20 12/02/20 Esquire 25 ``` I need to grab everything from…
-
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…
-
Domo Search API?
Hi All, I'm working on a dynamic landing page and I am trying to make a 'universal search' within a Domo brick where users can type in whatever they are looking for and return back cards/dashboards that are relevant to their area of the business. I realize Domo already has a search, but I want to build off of that same…
-
Hi! Is it possible to pull the data from a card using DOMO API? Or even pull it as an image?
Basically, There are multiple card data I wanted to use and process through Python. While I can certainly recreate it as a dataset, it's certainly tedious as there are multiple cards. Is there a workaround for this?
-
Filter Request from Custom Domo App
Hi everyone, I am currently working on a custom Domo app using React, and I'm trying to develop an interactive filter app. I've researched the domo.js library and found that it mainly provides functionality for managing and operating datasets, users, groups, etc., in Domo. However, it doesn't seem to be suited for sending…
-
'None' response when calling Domo SDK to append data into dataset
I am trying to append data into a dataset I created using the API but I get this error: Failed to import data into Domo: 'NoneType' object is not subscriptable. The dataset is created successfully but then I get that error message when trying to append the data into it. After some troubleshooting I found that the 'None'…
-
[domo CLI] login issue in domo app CLI after performing npm start
Description When attempting to develop the custom Domo app locally and run the local server using npm start, an authentication error is returned, prompting the user to log in to Domo using domo login. After successfully logging in, attempting to use npm start again returns the same authentication error. However, it…
-
DomoPhoenix.CHART_TYPE.RADIAL - When minimum value is 0.
Building a gauge with DomoPhoenix.CHART_TYPE.RADIAL. It appears that when the minimum value is 0 it does not display on the gauge. If I set the minimum value to 0.01, it displays. Is there a way to force the gauge to show the minimum value when the value is 0?
-
Trigger a dataset update via python using a post call
I am currently successfully triggering a dataset update from Snowflake to Domo via python using the following code: import requests #list of dataset ids and stream ids for the Snowflake>Domo connections guids = { 'datasetID': 'StreamID', 'DatasetID2': 'StreamID2', } #Does the work of kicking off updates for all Domo…
-
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!
-
Brick with Ten Datasets Question
Hey all, In the template for the "Brick with Ten Datasets", is there more specific documentation on the queries used to pull summary info into the card? For example, the https://developer.domo.com/docs/dev-studio-guides/data-queries link is provided as documentation for the code snippet below but there isn't even a…
-
Can you pass variables into a CLI script file?
I want to be able to pass the token and domain for the connect command or the file name and dataset ID in the export-data command. It would make it more extensible rather than have a script file for absolutly everything. domoUtil.jar -script E:\DomoUtil\MyExport.script I know I can regenerate the file each time using…
-
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…
-
Is there a way to pull data from the body of an email
I have emails that are automatically sent to my inbox with data contained in the email (see screenshot below). Is there a way to scrub the body of the email and extract data from it and pull into Domo? For example, I'd like to pull the value corresponding to Portal User ID (Cookie) .
-
Use an existing dataflow as a template???
I'd like to automate the creation of a dataflow as a copy of another dataflow, then change the owner. The new owner would then change some of the input datasets, rename the output dataset and alter a few of the tiles within the dataflow. Looking to simplyfy the intake of hundreds of files from different sources with…
-
Dynamic Filtering based on user permissions
I am trying to write some PDP policies. An example use case of my problem is that, all the users in my application have access to school names. Some users have access to multiple schools, while others have access to 1-2 schools. The schools these users have access to are defined on my backend. My DOMO dashbaord has a…
-
Saving filters
We are embedding our dashboards within our products via an iFrame. The issue we are having is saving the filters that a user has applied to their dashboard. Is there a way to save this in some sort of json string so that we can reapply it when that user logs back in? Programmatic filtering seems to limit the overall…
-
using Regex with email connector
Can anyone help me with Regex for an email connector. I have an email with two separate xlsx files. I've noticed the email connector will automatically default to the first one and I'm having difficulty getting a connector to pull the other. I tried setting up a separate connector to pull a file if the Attachment name…
-
How do we use the AWS assume role functionality with the upload-s3 Domo CLI command?
We have set up an AWS Role and AWS Profile to connect to an AWS S3 bucket. If we are using the upload-s3 Domo CLI command, how should we use the AssumeRole profile to connect, instead of passing a static access key and secret in the command line (upload-s3)?
-
Unknown Domo Governance datasets run error
Hi all, I've recently started looking into collating the masses of beastmodes our company has used to push some of these calculations back to our data models - instead of creating them on the application level. As a result, I came across a few posts suggesting using the Domo Governance Datasets, which on first inspection…
-
LinkedIn V2 API Changed?
Hello, Does anyone know of any issues currently with the LinkedIn V2 API connector? My connection recently broke and when I try to rerun it for post data, the content field is blank (not showing the account's posts). I was curious if anyone else experienced issues with the V2 connector and if there's a fix I can implement.…
-
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…
-
error while running a hello-world application => domo dev command
Trying the very first domo hello-world application by following the tutorial. For some reason not able to run the domo dev command and getting error as "DesignId is required"
-
Clearing Documents in Bulk in AppDB admin
There is a customer that is wanting to know how to delete every document from a collection, as opposed to a single document.
-
DOMO Excel Plug-in Filters
Hi I like the excel plug-in - however, I noticed the filter piece where I wanted to say if Column A = "Flower" or "Tree" I want to pull the data into the query table. However, when I tried Column A = 'Flower' OR Column A = 'Tree' it doesn't work. I also tried using Column A is in ('Flower','Tree') it doesn't work…