-
Javascript field name has spaces
I have tried back ticks, brackets, everything I can think of The script below works correctly and provides the results that I expect, but I really need to put Account Level 9 in the var where Specifically Account Level 9 = Administrative expense but when I add the field I get nothing. I can see the record in the output…
-
DomoR vs DomoSDK?
I have been handed an r script that has is using an accessToken to connect to domo and extract a dataset using a dataset ID. My end goal is to translate this to Python, as I have an existing pipeline in python that needs this dataset. Initially using the naive approach I tried to connect to Domo using pyDomo but was…
-
OKTA - DOMO API Setup
Hello, I am running into an issue with setting up a Domo API connector in OKTA, looking to create some workflows to add and remove users to my account. When I go to setup the connector in OKTA it is asking for the following pieces of information, I have more than half of the information but I am getting an error when I…
-
PyDomo - DS_Update to Append Data?
Hello all, I've written a script that ideally will create a datastream into Domo. At the moment though, I'm struggling to find a way to replace the update method of ds_update() from PyDomo. The default appears to be replacing the data, but I need to append the dataset. Does anyone have any experience with this? Any help…
-
Details about, and alternatives to, the DataSet query API
I gave the datasets/query/execute v1 API a try today, and have a few questions: * What idiom of SQL is this using? It took me some time to get the name escaping done in a way that Domo tolerated. * Is there any dedicated documentation on the system, other than the sparse details I've found at…
-
Dynamically Updating Dataset from DDX Brick
Greetings DOMO Dojo, I am currently trying to overwrite an existing dataset from inside a DDX application. I have currently setup the new data that I would like to replace the existing dataset with in CSV format. I have tried to accomplish it using this: var q =…
-
Is their API 'Rate limits' information shared for DOMO apis? If not, what are the rate limits set?
Couldn't find the allowed limits/quota of consuming DOMO apis over a specific period of time in the documentation.
-
How can I use domo.onFiltersUpdate to stop App refresh while still getting filtered data?
We have a Custom App on a dashboard with multiple filter cards. We like how the app responds to changes in the filters, but we would prefer it not have to refresh. I found domo.onFiltersUpdate and see that the filter data is passed into the function for use in the event handler, but it's unclear how the filter data can be…
-
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?
-
Power BI Writeback-Getting error when pushing dataset that has floating decimal datatype to Power BI
When trying to push data that has floating decimal as data type(I even altered the column to integer) from Domo to Power BI using the writeback connector, it throws 400 bad request error. If I remove those columns, it runs successfully. Has anyone encountered this issue?
-
Network Access from MagicETL?
Am I correct in surmising that whatever environment runs Domo's MagicETLs restricts internet connectivity? I've got a few Jupyter workspaces that a colleague has set up to do various things with our data--mostly normal/conventional stuff, but he's also doing a few things that require network access, like sending emails,…
-
How to Find Dataset ID for DomoStats People Dataset?
Hello, We want to access the DomoStats People data set via the Domo API. What is the Dataset ID? Is there a way for me to find it myself? Thank you Rob
-
API Accounts
Hi all, Can I please have some help with understanding what grants on roles allow the following: 1. Creation of client ID and secret for API connectors - is this only the "Manage all access tokens" grant or also the "Manage all accounts" grant? 2. Usage of API account - does this require the "Create dataset account"…
-
Error creating query using python and pydomo
Hello, When attempting to query a dataset with a simple query query = {"sql": "SELECT * FROM table"} I get this exception Exception: Error creating query: {"status":400,"statusReason":"Bad Request","message":"Cannot deserialize instance of `java.lang.String` out of START_OBJECT token" Using domo.ds_meta and domo.ds_get…
-
Using Python API to Update Already Created Datasets
Hi Everyone, I am trying to find a way to upload information from a python script into a domo dataset weekly. I am finding that you can't update an existing dataset with this method, only create a new one and update that newly created one. Has anyone found a workaround for this? In the documentation it appears this is…
-
Change Update Method Using Pydomo
Created a dataset using Pydomo. ds_update method does only a REPLACE. Not sure how to change it to append. Any help is appreciated. Thanks!
-
pydomo export_dataset - exporting Domo dataset with millions of rows failing
I have the below that exports a dataset to a string, I'm trying to export a dataset with 257 million rows but I don't see any logs as to why it fails It just fails! When I try the below with a smaller dataset (250k rows) I'm able to export, is there a way to programmatically break out the dataset into chunks? domo =…