-
Checking the status of a job in the command line
Hi Everyone, Is there a way to check the status of a workbench job from the command line without combing the log files? We use A LOT of automated scripting to route files both before and after they are uploaded into Domo and I'd like to be able to make sure we don't accidentally move a file while it is currently in the…
-
Finding the "Growth Rate" of a metric in Beastmode
We are currently building a dashboard where looking at change over time is critical - ideally how we'd like to accomplish this is by measuring the growth rate, or change in the metrics over the period set by the analyzer. Is it possible to calculate this in a beastmode while still retaining the ability to change the…
-
Creating Workbench Jobs on Other Instances
Hi Everyone, We are setting up our workbench(s) to run unattended on multiple AWS instances but are having trouble coming up with a good way to update the jobs available to each instance - for example, although they are all logged into the same "account" only the jobs specifically imported/created on that machine are…
-
pydomo - dataset export json.decoder.JSONDecodeError
Hey Everyone, I've been using the new PyDomo libarary in python 3.x and it has been working great... until I try to export a dataset at which point I get: File "C:\Users\UserName\Python35\lib\json\decoder.py", line 357, in raw_decode raise JSONDecodeError("Expecting value", s, err.value) from None…
-
Hide Series from the Legend when Null
Hey Everyone, I'm working with a symbol/stacked bar chart which shows 2 metrics. In order to show both the average (as a symbol), and the individual bars broken out by series I've had to calculate each series independently. There are a fixed number of series however this means that even when a series is null it still shows…
-
Applying PDP and Publication Groups
We are using publication groups to give external users access to their, and only their, data. Since Publication groups can't be accessed via the current API endpoints we also thought to programatically define PDP to guarantee a second layer of protection against people seeing data they shouldn't. We tested this and it…
-
Remove \N when exporting as CSV
I've noticed when exporting datasets as csv all null fields are filled with \N. Is there anyway to remove this by default?
-
Stream API Security
I'm looking to utilize the Stream API to bypass workbench for our data uploads however the data I'm uploading is very sensitive (ePHI). Looking at the API documentation it is making requests over HTTP, how would I ensure the data is sent over HTTPS and/or ensuring encryption in transit? Thanks,
-
What is automatically updated when renaming a dataset?
Hi Everyone, We are currently in the process of renaming all of our datasets and dataflows using a new and improved naming convention. About halfway through I had the prophetic thought of "this dataset is referenced in x many dataflows, I sure hope those all update..." luckily, since the flows have run without issue I…
-
How do I pull all excel files in a particular folder into a dataset?
Hi Everyone, Brand new Domo user here, so I apologize if this question is pretty basic. We have ~300+ clients upload an excel file each week using out Citix Sharefile file drop folder, which we then route into a folder based on which client it came from. We'd like to set up a dataset that pulls in all files in a particular…
-
Workbench Resource Requirements
Hi Everyone, 2 questions about Workbench: * Is running a job in workbench (specifically one pulling from an FTP connection) more CPU or Memory intensive? * Can you run multiple instances of workbench all under the same user credentials at the same time? We are planning on running workbench on EC2 instances in auto scaling…
-
In workbench is there a way to alter the "DataSet Job Id"?
We'd like to use the command line to queue jobs automatically but ideally would like to change the job ID to make the commands a little easier. Alternatively, if there was a way to queue jobs by the job name as opposed to the ID that would work as well.