-
Domo Workbench 5: Unable to Query Provider Types
Hello folks, We use Quickbooks Desktop 22 (queue eye roll) and use Domo WB to connect to the network files and send data over to Domo. I have been seeing this error alot lately. Has anyone ever specifically ran into this type of error and if so what did you do to resolve it? [INFO] [3532:12] 2023-05-18 00:03:30,774 -…
-
Workbench Weird Issues
Hello community, Has anyone encountered the inability to restart/stop the Domo workbench service? Even via command line as administrator on a Windows 2019 Server? Everytime I run the command or try to stop/restart via the GUI in task bar I get a message saying I cannot do it. I checked the workbench logs today and saw…
-
Update Domo Magic ETLs via API/DomoCLI
Howdy, experts, Is there a way to programmatically edit a Magic ETL? I am willing and able to use Python SDK or the DomoCli Jar tool. If there is a way, is there any documentation out there?
-
Considering Domo Everywhere
Hello, Community, Please pardon me being so naive to this topic in advance. We have been using Domo for about 4 years now and we have about 120 user licenses in Domo. Recently, discussions have been brought up to share data to a bigger user base, but without exceeding Domo licenses. I ran upon Domo Everywhere and had a few…
-
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…
-
Best Practice: ETLs Vs SQL ETLs
We are trying to rebuild a tool Domo Tech built for us called Domo Stacker. Its main purpose is to aggregate many datasets together. Our current datasets are 250+ recursive ETLs that output a dataset that is growing (think: historical + appended new data) for four buckets of categorized data (four separate outputs when…
-
Facebook Ratings Connection
Hello, community, I hope you all are doing well. I wanted to reach out to see if anyone here has successfully connected to Facebook Page Rating data in Domo using the connector? If the connector was not how you went about it, what route did you take? I feel like I have played with both the standard and advanced Facebook…
-
Null Values Beastmode
Good evening, Community, I am creating an app that will be pulling data down from Domo and I seem to be running into some issues with some beast mode logic. The beast mode (Open Rate): COUNT(CASE WHEN `activityName` = 'Open Email' THEN `activityDate` END) / COUNT(CASE WHEN `activityName` = 'Send Email' THEN `activityDate`…
-
Data Flow help
Hello, Experts, I am humbly reaching out for some help. I have a vendor sending a snapshot of a database table every day and not sending me diffs. I am trying to determine the diffs. The connector type is SFTP CSV. The file they send daily is overwritten daily. I currently have the data connector appending the data from…
-
Convert DATETIME (UTC) to specific timezone
Hello, Domosapiens! I have an interesting quandry. I have a data flow (using MagicETL - should I be using something else?) that I am trying to build and convert a date that my MySQL data connector is bringing over. The datetime column comes from an orders table and is called posted_date and it brings the data over as UTC…
-
Improve Dataflow Efficiency
Hello, Domosapiens, I currently have a data flow that is taking 14 min or greater to run. The design is as such: MySQL connector that first runs once to pull in all historical data (7.8M rows). Ex full historical pull query: select * from table; change dataset settings to merge method by changing the query to select * from…
-
New to Domo Developer
Hello, Experts, Excuse me for being naive. I am a python developer and I am looking for a way to integrate data from an API that was built in the 16th century (sarcasm). The API allows for GET/POST/UPDATE/DELETE via RESTful API libraries but the responses come back as XML (hence 16th century). How the data is structured is…
-
Domo Query API - Row limit?
Hello, Experts, Is there a limit to the # of rows you can pull down from a Domo dataset using the Domo Query Dataset method? https://developer.domo.com/docs/dataset-api-reference/dataset#Query%20a%20DataSet I have built a https request using python and then leveraging writing that response to a python pandas data frame.…
-
Date Calculations - minutes and seconds
Hi, Experts, I am working on trying to find out how to calculate the time difference between dates. Here is what I am after: I would like to see the difference lets pick two dates start (created_date) - end (posted_date). I would like the output to show the time in minutes:seconds or minutes.seconds of the lapse between…
-
Convert a UTC timezone to Local Time
Hello, Experts, I am looking for guidance on how to properly convert time that comes in as UTC format from our MySQL server. I have converted it in the output within the MySQL code to be YYYY-DD-MM for the correct timezone but I want to keep the datetime feel to have HH:MM:SS. Is this possible? If so, how? Thanks in…
-
Help with recursive dataflow
Hello, Experts, I am looking at creating a data flow that will constantly update data from a dataset while keeping a historical dataset in play. For this scenario lets call: * Historical Dataset (MySQL connector) - Dataset A * Update Dataset (MySQL connector) - Dataset B If you could, please let me know if I am on the…
-
Weird Sorting Issue - Total Sales
Hi, Experts, I created a domo card in table view for some top-level KPIs. I am running into an issue when I sort by Total Sales (calculated field/beast mode) by ascending you get the column sorted by 0 to the bottom. When you sort by descending it sorts by blanks. Thoughts or help would be greatly appreciated.
-
MongoDB Connection to WB (local)
Hello, Experts, I am trying to connect MongoDB living on a host machine on our network with WorkBench. I went through the steps advised by the MongoDB doc site saying I need to install a MongoDB ODBC driver (v1.2). Installed that and got it configured. I have installed MongoDB Compass (client tool) and have successfully…
-
Merging new and legacy datasets
Hello, Experts! I am reaching out in hopes that I get some guidance on the best approach for building out an ETL. Our company is undergoing a point of sale transition and things are going well. We currently have legacy data in one dataset and new data flowing into Domo separately. My CEO is wanting to see week by week…
-
New Pivot Table: Showing highest number per row
Good Afternoon, Experts! I am enjoying the new pivot table in Analyzer view. I am creating a card where you will be able to show week over week period of sales data listing out all the stores in my data set (see table 1.1). What I am trying to do is: * For the given week, have a condition to look for the best week ever for…
-
Week over Week Metrics - Multiple Stores to Show
Hello, Experts, I have a use case where I am looking to build a card for week over week showing in table format a list of stores in one column and total sales in another column for the given X # of weeks. Based on my reading, it looks like I will have to build a new transform to be able to accomplish this. Can you confirm…
-
Division - Beast Mode - Exceptions
Experts, So I have a division formula that we built in a beast mode. Some of my data on the bottom part of the divisor comes up as 0. So what I did to account for that is to do a NULLIF. However, when you divide by NULL Domo freaks out when you are trying to present this in a card. What ways would you recommend to…
-
DataFlow - Quickbooks - Picking up Edits
Good Morning, Experts! I wanted to resurrect a question I had asked previously. The question encompassed a dataflow that was built. In the data flow, the data flow is bringing in inputs from 4 separate Stacker jobs that aggregate data from dataflows from various Quickbooks (QB) jobs (Accounts, Vendors, Class and GL). In…
-
Domo WorkBench v5 - DataSet Type Question - Quickbooks
Hello, Experts! So, I have an interesting thing that has been occurring lately since upgrading to WB v5. When creating new jobs in WB for Quickbooks, you would be able to select Transport type: Local File Provider; Reader Type QuickBooks; and DataSet Type Quickbooks. However, the only option that pops up is Workbench…
-
Quickbooks Enterprise - ETL Transaction Pickup Issue
The nuts and bolt of the issue is our Quickbooks ETL logic is not picking up edits made by end users. We are wanting to pick up the latest transaction. We validate or process on the date and transaction number field. So say there is transaction number (TN) 123 on 1/29 and TN 124 on 1/30. If the user edits then edits 123 it…
-
Merging Legacy and New POS Dataset
Hello, Experts! I am reaching out in hopes that I get some guidance on the best approach for building out an ETL. Our company is undergoing a point of sale transition and things are going well. We currently have legacy data in one dataset and new data flowing into Domo separately. My CEO is wanting to see week by week…