-
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…
-
Relative date range filtering using JSON no code with API only supporting timestamp format
Hello, I'd like to use our partner API within Domo with JSON no code connector The connexion works fine until I set up a relative date range filtering of 7 days (which is allowed by the API with startDate and endDate parameters). The API documentation specifies that date parameters should follow this timestamp format :…
-
Facebook Ads Advanced Connector Error - "You are calling a deprecated version of the Ads API. "
I have facebook ad level data and Facebook campaign level data being pulled in daily - today it didn't run automatically and is running the error: "DOMO is ready but Facebook returned an error: (#2635) You are calling a deprecated version of the Ads API. Please update to the latest version: v13.0." What do I need to do to…
-
Error retrieving a Domo API Access Token
I was running a python script that connects to Domo using my client id and secret and it was running fine till about an hour ago when I started getting an error message: File "/.virtualenvs/strat/lib/python3.8/site-packages/pydomo/Transport.py", line 87, in _renew_access_token raise Exception("Error retrieving a Domo API…
-
Dataset created through API is endlessly 'Storing'
Hello, I have been trying out the Streaming API. I successfully created and loaded data into a dataset using a small number of records. I re-ran the process multiple times, and because the stream is set to 'append', each time the number of records increased by the correct number. However, when I ran the process uploading…
-
Batch Last Run Columns with API Updates
Is it possible to configure the Dataset to automatically add a "BATCH_LAST_RUN" column when updated via the API rather than doing it manually within the API program before the update is made? Thanks, Will
-
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…
-
OneCloud - DOMO REST API
I am trying to configure a connection between the application OneCloud and DOMO. OneCloud has a built in DOMO connector but the connection is still not working. It only asks for client ID and client secret. I have seen a ton of posts about a token but I can't figure out how to get one or if I need one. Any help would be…
-
Domo to Google Data Studio?
Hello! Has anyone created a personalized connector to connect Domo & Google Data Studio? Right now I am pulling Domo datasets into Google Sheets and then into GDS. I would love to take out the middleman, but am unsure how to improve this process. Any ideas? Thanks :)
-
Increase timeout time to connect to API - JSON No Code Connector
I'm looking to connect to an API using the JSON No Code connector, the api takes about 40-80 seconds to generate the data. Is there a way that I can increase the timeout time in order to pull the data through?
-
API and download large dataset
Hello -- I need to extract data from a 20M row dataset. I can download smaller datasets, but when I try to download a large dataset, I get a timeout. Can I apply a filter (like date) to the download request for the larger dataset? Thank you
-
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…
-
Json No Code Connector - Question.
Hello Everyone, I am using Json No Code Connector to pull the data in the Replace mode. I would like to only replace data which is changed at the backend and not the whole data. Is there a way we can do this in Connector settings ? Or any other way ? Thanks,
-
Unsupported post request. Object with ID 'act_20017474'
Hi guys We have been using the Facebook API for months now with no issue and a few weeks ago it just returned the below error. It has returned this error every day for the past few weeks. Has anyone come across this issue and found a solution? "Facebook returned an error: Unsupported post request. Object with ID…
-
Question about IP address whitelist
Just curious, but could Domo be using a different IP address than what is whitelisted for a database I am trying to connect to via the SQL server connector in Domo? Giving a test run today trying to connect I had my public IP address whitelisted for access with no success. It gave the same error, but now I'm scratching my…
-
Character Limit- API in Domo ?
Hi Guys, Does Domo have a character limit, for bringing in data through an API? Thanks
-
Is there an API for viewing and manipulating DataSet tags?
Hi, we would like to do something via the API where we search for DataSets with specific tags and also add and remove tags for DataSets. I have been reading through the docs for the DataSet API but I couldn't find any info for how to do this (or if it's even possible). I also skimmed through the other topics in the API…
-
Any way to obtain a "last login" parameter for Users via the API?
Trying to obtain something like this from a GET request to the API to send out some inactivity emails with a Python app of ours. Didn't see any parameters like this in the API documentation. Any help would be appreciated. Thanks!
-
Go to next page in List of Users?
I'm using Python and I'm able to get the first 500 users (which is the max according to the docs) but then how do I get the following 500, etc.. we have thousands! This is what I have so far: import requests import json url = 'https://api.domo.com/v1/users?limit=500' headers = {'Content-type': 'application/json', 'Accept':…