-
Domo instance API - Method Not Allowed
We want to interact with our Domo instance via scripting namely for triggering a Magic ETL or MySQL dataflow. We noticed that there is a way to interact with the API for our Domo instance by using first an authentication method. However, when we tried to use that method (either in Python scripting or in Postman) it returns…
-
Workbench - Preview Schema Data Type Error
We have been trying Workbench in different computers including the main server where we will upload data to our Domo instance. In this example, we are uploading data from a CSV file which have different data types (STRING, DATETIME, DECIMAL) and, in general, in all computers the Workbench maps the schema correctly during…
-
Text message when domo workbench job fails
Hello, Does anyone have any ideas on if its possible to receive a text message on my phone when a workbench job fails? I get emails when jobs fail, but I don't keep Outlook notifications on my phone because my phone would just ding all day long. Too many times on a Monday morning I've discovered a job has been failing…
-
Workbench
Training on workbench
-
Workbench - Different jobs ID when importing
We are moving from one on-premise server to another on-premise server and we need to set the same Domo Workbench jobs in the new on-premise server. We exported the jobs to a local backup file in the old server, then we copy the file to the new server and then we imported the jobs from the file to Domo Workbench. Everything…
-
Domo Workbench broken Quickbooks 2019 2020 Python ODBC alternative
I have created a Gihub repository with a Python workaround to dump QB reports to a CSV via QODBC. I am sharing this freely and would like to collaborate with others to have this option in case Domo Workbench is not working as is currently the case for Quickbooks 2019+: NOTE: I just started this project last night due to an…
-
Workbench Monitor will not open
I am trying to restart the workbench service because I have encountered the same issue as this post and I saw the solution. But for some reason when I click on Workbench Monitor, I get the icon on the bottom right in the menu but when I hover over the icon to right click, it disappears. Has anyone encountered this before?…
-
Append with removing rows of data
I am wondering if there is way to setup the following scenario. I have an append that runs in the morning and all the new data gets added properly, however, there are situations where some of the source data is no longer needed for example if I started with 110 rows of data yesterday and throughout the day 10 were removed,…
-
Is there any way to schedule file uploads to Domo apart from Workbench?
So just as the question states, I am a new user in the planning stage and I am trying to figure out if Workbench is the solution I have to upload my .xls files to Domo. Is it possible to access Files saved on Microsoft Sharepoint or Teams for example?
-
Dashboard embed codes and the API
A quick two-in-one question about the API and making dashboards embeddable. Is it possible to use the API to see the embed code for a dashboard? Is it possible to change a dashboard from "Embed options = OFF" to "Embed options = Public" using the API? Many thanks!
-
Dataset Upsert
I have been reading up on this and noticed that I in fact do NOT have the Upsert column enabled therefore according to the document I need to contact customer support. My question is, will I need to do this for every single current dataset and all future ones as well? Or is this a "flip the switch" kind of deal and it will…
-
Questions about "Embed Dashboard" = "Public"
Folks, My colleague and I are working on a single Domo account; he builds the dashboards in Domo and I embed them in our private portal for customers. We just noticed today that for the exact same dashboards, when he and both click on the "Embed Dashboard" option, and look at the state of the "Embed options" dropdown, he…
-
Run Workbench Job from another computer or script where workbench does not reside
I am trying to see if there is a way I can run a workbench job from a computer in which workbench is not installed. I have some SQL queries that run overnight or a specific times throughout the day and I would like to have a script that triggers the run of the workbench job. Is there some sort of API endpoint I can call or…
-
Workbench Replacement Variable not saving
I've created a handful of Workbench jobs over the past few months, but every time I do, I seem to have to struggle for about an hour each time to get the replacement variables working with the 'Append' update method. This typically includes trying every imaginable order of operations, deleting and recreating the job…
-
Workbench Installation Fail
Does anyone know what this installation fail means?
-
Can Just One Workbench Be Used On One Domain?
Does anyone know more about having multiple users working on Workbench at the same time? The FAQ page states that it is "All Workbench jobs are saved in the cloud and tied to a specific login", but I'm not sure what this means. https://domohelp.domo.com/hc/en-us/articles/360043437373-Workbench-5-FAQs From what we have…
-
How to Do a Silent Install of DOMO Workbench
Hi, I am trying to install DOMO Workbench through chef scripts. I couldn't find any documentation on it. Does anyone know how to do a silent install of DOMO Workbench? Also are there any documentations on how to configure DOMO Workbench programmatically? Thank you for your help!
-
Using WorkBench to Connect Azure AD to DOMO?
Hi! I am relatively new to creating connections in DOMO, but one thing I would love to be able to do is make a report of all computers that are showing in our Azure AD so that we can see information on our users and what computers they have joined to Azure AD. This would also help us see non-compliant assets or unencrypted…
-
How to cancel/stop/suspend ALL workbench jobs temporarily
I've submitted to Domo Support this morning, but thought I'd check with the Dojo to see if anyone has a solution. I have about 60 workbench jobs that appear to be stuck this morning and are showing as "running". They seem to be stacked up in queue and are not getting anywhere. This traffic jam is growing as scheduled jobs…
-
Overwriting an Existing DataSet with Workbench
In our team, we have a couple of engineers developing in Workbench on different PCs. When I exported a job from one Workbench, imported it to another Workbench on a different PC and ran it, another DataSet with the same name was created. Is there anything I can do to overwrite and update the existing DataSet?
-
Workbench File Updates
IS there a way in Workbench where files can be updated automatically into DOMO without having to change the filename? So for example, I frequently download csv files into a directory, these files have different filenames. Can Workbench identify the latest file in this directory and update it?
-
Workbench | Multiple Accounts in One DOMO Instance
Hi, Is it possible to create multiple accounts to use in Workbench in one instance? This is because we have different permission/rights based on our roles. For example, scenario: We are using one server to upload on premise data - for security and refresh schedule. User 1 has workbench rights and can upload sales data.…
-
Issues after updating to Workbench 5.1
Hello, I recently upgraded to Domo Workbench 5.1. All jobs ran successfully during the first two days of the upgrade, but I am getting the following error. I already restarted the server where domo workbench is located and that worked for about two hours, but the issue came back. Any tips or suggestions.
-
How do I use workbench to Writeback to MS SQL?
Any help would be appreciated
-
Delete User API
We need to remove more than 200 users in our instance and we want to do this in bulk. For that we thought on calling the User API via scripting so it could execute quickly. However, the API is returning an error 400 referring that the user owns datasets and therefore can't be deleted. We already have confirmed that the…
-
Should I really be using UPSERT KEY just to APPEND data?
I have a huge dataset I've uploaded through Workbench. I now want to run a daily APPEND of new data only. I don't see a way to define an "APPEND" key, just an "UPSERT" key. My data won't really change, so I really only need inserts of any records where the defined ID is not already in Domo. My append query looks for a…
-
Workbench 5.1 SDK creates DLL but WB only loads DWP file
Hello, I am hoping WB 5.1 solves the crashes issues I encountered trying to create a transform plugin. However, when I build my plugin in Visual Studio it creates a dll. When I tried to add the plugin into WB 5.1 it will only load a dwp file. Am I missing something simple? Thanks,
-
In Workbench what does "DataSet Type" change?
I have Workbench jobs uploading Microsoft SQL Server tables to Domo. For "DataSet Type", I accepted the default of "Workbench ODBC". After setting up my jobs, I noticed there is a "Microsoft SQL Server" dataset type. What's the difference? In Domo, the icon changes if I upload as a "Microsoft SQL Server" dataset type. If I…
-
Dataset not showing up in Dataset Picker in Workbench 5
We have a user trying to update a dataset in Workbench 5. There was a JSON job file that was left. When we open the JSON file, it is pointing at a different dataset. The dataset we are trying to update does not show up in the Dataset Picker list. The dataset type is excel.
-
How to Connect to a MySQL database using Workbench?
Hi Team, I wanted to know how to connect My SQL database using Workbench. I don't know anything about this process. so detailed steps or screenshots would be helpful to me. Thank you so much in advance.