-
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 =…
-
External Trigger to begin Dataset Import
Today for datasets we only have a scheduling mechanism to update a dataset. It would be nice if there was an API or webhook we could trigger externally that as soon as data is available, to have Domo to pull in the fresh data. This idea has been talked about before but the discussion was closed. I wanted to add my voice…
-
pydomo ds_query - api limit for large dataset broken out into many queries
Is there documentation on how many queries can be made, and what the API rate limit is? I have an extremely large dataset and I have to break it out into like 100 hundred queries but after the 10th query is run it breaks.
-
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…
-
Reach Data (LinkedIn Ads)
Hi All, I recently Swap approximateUniqueImpression column with averageDailyReachMetrics_approximateReach in my dataflow diagram. Even though the dataflow is running completely fine without error, it's the LinkedIn API is causing an error and making dataset update unsuccessful. Error: Domo is ready, but LinkedIn Ads…
-
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…
-
Increase Zendesk connector row limit
Currently, the Zendesk connector is limited to 1000 rows, it would be great if we could select a time frame and pull more than 1000 rows!
-
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…