-
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':…
-
Use JSON Advanced Connector to POST to an API
Hi there, has anyone successfully got the JSON advanced connector to POST to an API, when using JSON data as parameters in a request body? I've got a call working in Postman ok, but when I transfer it to DOMO I get an error: "Domo is ready, but the credentials you entered are invalid. Verify your account credentials and…
-
Domo dependency (domo-java-sdk-all) issue
When I defined compile group: 'com.domo', name: 'domo-java-sdk-all', version: '0.4.0' in the gradle dependecy, it fails to load. Seems because bintray-domo is disabled. Is there any alternative repository?
-
How to change color and text size when using domo iframe?
Hi! I have been trying to change the color (the original color in the domo card is different) as well as the text size in the card (text size is much larger in domo dashboard). However I am not sure how to do this. Here is how the card looks in domo: Here is what it looks like as iframe: Any ideas on how I can make the…
-
Reddit connector solution
Hi All! We started using Reddit Ads and as of now Domo doesn't have a connector for Reddit Ads. Does anyone know a way, how to connect Reddit Ads Api to DOMO, would you be able to help me, please, or point which way I should look at... Thanks in advance to you all!
-
Domo connectors - Spotify Ads
Hi All! I know that Domo doesn't have any Spotify Ads connector. I found an article about how to build Spotify API, but not for Spotify Ads. I was wondering, did anybody deal with Spotify Ads, how did you manage to automate pulling the report? Even Spotify platform doesnt allow to pull report by breaking it down daily, i…
-
Domo API sample
Hi, I'm new to API and new to Domo. I've been reading on this https://developer.domo.com/docs/dataset-api-reference/dataset#Retrieve%20a%20DataSet. and the docs have this sample API endpoint https://api.domo.com/v1/datasets/08a061e2-12a2-4646-b4bc-20beddb403e3. but it shows {"status":401,"statusReason":"Internal Server…
-
Does Graphql endpoints work in Domo ?
Does Graphql endpoints work in Domo? If yes, which connector needs to be used for it ? Please explain in detail. Thanks for your help 😊
-
Api Documentation showing only 3 user roles, 5 available in the Admin page?
Hello everybody! I'm following this page: And I can read that there are three roles: Admin, privileged, participant. In the role part, it says: The role of the user created (available roles are: 'Admin', 'Privileged', 'Participant') However, when I access the admin settings in my account, I can see two other roles that are…
-
Delete User API
We need to remove more than 200 users in our instance and we want to do this in bulk. For that we thought on calling the User API via scripting so it could execute quickly. However, the API is returning an error 400 referring that the user owns datasets and therefore can't be deleted. We already have confirmed that the…
-
Importing data from Spyder (locally) to DOMO
Hello, I have a Python script created on spyder which I need to import into DOMO. Just wondering how would I be able to do that. I saw the documentation on API and creating custom connectors but no luck. Thank you in advance.