-
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 =…
-
Export card to Excel using API
I have a card containing numerous beastmodes and I can export to Excel through the UI and maintain the look of the card as well as all the filters. Is it possible to do this same action through the API? From the documentation I only see the option to query datasets, which we have done extensively, but I would want to query…
-
Is there a way to retrieve or export cards data to csv using Domo API?
I have a page created with a number of cards. Is it possible to retrieve card data or export to a csv using the API? I know API allows to export datasets to csv, but I can't find a way to do the same for cards. If not possible, is there any workaround to set it up in Domo so I can only retrieve card data with the API and…
-
Facebook - Missing dates
Hi guys, Im wondering has anyone noticed missing dates in the Facebook Ads Advanced Connector updates in the past few weeks. The report date value i have been using is UpdatedTime. I have actioned a full REPLACE daily but it still seems to be happening. Domo have told me it is on Facebooks end but it is notoriously…
-
CMiC
Hi Guys! Has anyone worked on getting data into Domo from the CMiC ERP system? I am looking for ideas on how to get that data and possibly what connectors or APIs I should be looking to use. Thank you ^_^
-
Issues With Triggering Campaigns App With An Alert
I've been following along with https://domohelp.domo.com/hc/en-us/articles/1500000316201-Triggering-a-Campaign-from-a-Domo-DataSet-Alert#2.2. I am currently at the point of testing the POST to the API in the WebHook and I am getting the Error: { "status": 400, "error": "Bad Request", "path": "/api/v1/campaigns/bae/start" }…
-
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…