-
How to use query-data command of domo CLI
Hello all. When using the domoCLI query-data command, there are --query and --queryfile command options. I would like to know how to write a JSON-formatted query that can be used for each. For example, what if you want to retrieve only the "Name" field from the following dataset. [Example data set] ID Name Address 1 John…
-
Commiting data before update in dataflow
Hi, i would like to know if there is a way to commit data before getting update in dataflow. We have use kafka to push records to dataset from file. with kafka we can set up how many records we expect so before pushing to dataset we can confirm the number of records in the file and commit it . Now we would like to avoid…
-
CSV File download in a custom app via anchor tag not working for Chrome 83.x version
CSV File download is not working in custom app for Chrome 83.x version. I was using the download via creating an anchor with download attribute and which was working fine before. But after upgrading the Chrome to new version it is not working. Kindly, provide any information on alternate way where we can download files…
-
BigQuery connector
Hi. I have connected BigQuery to DOMO using an access key in JSON format. It connected successfully, however, it only sees one project and not the other two. I have created an access key under the main Project 'A'. In this project, lives other sub-projects -> datasets -> tables. DOMO only allows me to work with the first…
-
Unable to use DOMO CLI (App Dev Studio)
I am unable to use domo from the command line: $ domo -bash: domo: command not found This is after installing ryuu multiple times both in local projects and globally: $ npm install -g ryuu npm WARN deprecated opn@6.0.0: The package has been renamed to `open` npm WARN deprecated request@2.88.2: request has been deprecated,…
-
Tutorial: build your own connector against petfinder API
Building Custom Connectors in Domo. * Read the KB article in developer.domo.com then click Build Now and authenticate Upload Icons * I found images using google searches, then resized them using resizeimage.net to the appropriate dimensions. User Authentication * take note of the Configure Authentication KB article…
-
Error in Activity Log API
There seems to be an issue with the Activity Log API when setting an end time in the request. When there's no start or end time, I get a response. For example: curl -v -H Authorization:'bearer <token>' "https://api.domo.com/v1/audit?limit=5&offset=0" This works and gives the 5 most recent log events, in descending time…
-
Accessing DataSource details through API
Hello, I would like to access the metadata of a datasource through some programatila way. I want to go through our BI developpers SQL queries, which they are executin against our on prem database. So I need to have access to the datasources/settings/details/query part. Thank you P
-
Is there a way to view all of my filters being applied to a table column?
Is there a way to view all of my filters being applied to a table column? I currently have 30 filters applied, but it only shows me 20 of them selected and 'and 10 more...'
-
Guidance on creating a data table using APIs
Hi, We are exploring the opportunity to create our own app via the APIs documented here (https://developer.domo.com/docs/dev-studio/dev-studio-overview). We currently have a mega table with 6 filters in story/embed mode deployed through a PDP-enabled dataset (10M records). We are considering an app so that we can display…
-
Help with Microsoft Graph Customer Connector
I'm having trouble getting an access token when calling microsoft graph through the custom connector builder. I can successfully connect using postman, but not the connector builder unless I input the token and code directly into the authentication script. Trying the following config: //This logging is here for testing!…
-
How we can limit the number of rows in api call
Hi, I am trying to access data of dataset using api and fetched the data using below api. https://api.domo.com/v1/datasets/{DATASET_ID}/data But it provide all the data, How we can limit the number of rows in api call? Please provide us the link if have any.
-
Domo library for python?
Hi All, Is there a way to use domo library with python? Thanks Hiba
-
"failed to receive handshake, SSL/TLS connection failed" error
Hi, While I am trying to install "install_github(repo="domoinc-r/DomoR")" in R or running below script in R getting erroe "Error in curl::curl_fetch_memory(url, handle = handle) : schannel: failed to receive handshake, SSL/TLS connection failed" library("devtools") library("DomoR") DomoR::init("gsk","2*******6") c <-…
-
join two dataset on two columns sql domo
I am using MySQL I have two tables that I want to join on both columns. My data looks like the following: The first table represents 2019 Revenue ``` Week Name 2019 Revenue 1 Paul 576356 1 Nick 246564 2 Sam 426547265 ``` And the other table represents 2020 Revenue ``` Week Name 2020 Revenue 1 Paul 554 1 Nick 200 2 Sam 400…
-
Filter Data Using Domo API for Python
Hi, I am currently trying to pull data from Domo Dataset into a csv using the python API. I am able to pull the complete dataset but would like to filter the data based on certain conditions. Can anyone help with me with. This is the code that i have got to pull the Data from the Dataset. import logging from pydomo import…
-
Can we upload single excel file with multiple sheet into DOMO and use it?
Hi Dojo, I have many small small data set in excel which is in 12 sheet in single excel file. Can I upload single excel file with 12 sheet of data and use it in domo to create a report or I'll have to create 12 separate data source into DOMO? Thanks Suman
-
Group data by week
Hi. I have a dataset with three columns. Date, Revenue, Advertiser. I need to group the revenue so that it shows weekly. I expect the data looks something like the following: ``` Date Advertiser Revenue Week 1 abc 123 Week 2 abd 124 ``` I tried SQL but seems like I have a syntax error. Any help would be greatly…
-
Error uploading assets via domo publish
Hi , Getting error while uploading to existing card via domo publish command Design can be found at https://pg-azure.domo.com/assetlibrary?designId=7ff12cbf-e2fc-4353-bb5c-93837234d762 X Error uploading assets error Command failed with exit code 1. P.S. This works when connected to Office network but not working when…
-
How are folks using the COVID-19 Datasets?
In the Virtual User Group meetings, we have discussed these datasets. In our chats on that page, some have posted what they have done. I thought it would be good to break it off and centralize that content in its own thread. @DaniBoy - Would you mind porting @Godiepi and @trafalger posts over to here? For those of you who…
-
Slack and DOMO integration
Has anyone built an API call or a connector between slack and DOMO?
-
Domo alerts to Slack using Tray.io
Good afternoon. We submitted a case to Domo Support but also wanted to post here since they'd previously advised other customers had found a work around using Zapier and various automation applications related to this request, though it's unclear if they were trying to have the alert as detailed as we're looking to do: We…
-
Do Story Dashboards function with Publication Groups?
I've looked around the dojo and kb for this, but haven't found an outright answer. Our company uses publication groups for distributing domo to our audiences. We are interested in the "design dashboard" or story dashboard feature, but want to confirm that it will work with publication groups. Testing is a bit tricky for us…
-
How can I create an anchor so that I can create links within a dashboard
I want to build a small Navigation menu at the top of my dashboard and then have links in that menu that link to different sections within the same dashboard. So, how can I create anchors at the individual sections on my dashboard and then create links to those anchors within my navigtion menu? Something like this...The…
-
Dataset query case-insensitive value
Hi Dojo, I have followed the documentation on https://developer.domo.com/docs/dataset-api-reference/dataset#Query%20a%20DataSet to query dataset. However i can't find how to make a query with case-insensitive value, could you please help me solve this problem.
-
Find/Search a file in DoMo Dataflows
HI All, I have hundreds of dataflows developed in DoMo ETL where i need to find all dataflows where file 'xyz' is used as input. Is there any option available in DoMo to find/search required file?
-
AppDB Error Handling
Good day to all. Developing an app using the serverless technology, I've encountered a minor roadblock. My dataset needs to have an ID column to use it as TransactionID, that is, on every submit I make to the database, it will work as an auto increment index on those fields (1 to N). Next call to the DOM and eventual…
-
Open custom app on new tab or redirect to card from a page
Hi Dojo, How can I implement my custom app card to be seen as a card created within Domo (has a header with the card name, clicking on any part of the body opens the card)? For example, the card for my custom app doesn't display the card name at a page level, only when I go into the card. To go into my custom app card I…
-
Display array values
Hi, I have been able to create a query that receives a parmeter so it filters the data on a given choice, and I'm able to send that into the console with a table view. How can I do so in HTML to display my data? I appreciate any help with this.
-
Need roles and responsibilities
HI All, Can anyone please share Domo developers and magic ETL roles and responsibilities to put in resume ? Thanks, Raghunath.T