-
Clearing Documents in Bulk in AppDB admin
There is a customer that is wanting to know how to delete every document from a collection, as opposed to a single document.
-
DOMO Excel Plug-in Filters
Hi I like the excel plug-in - however, I noticed the filter piece where I wanted to say if Column A = "Flower" or "Tree" I want to pull the data into the query table. However, when I tried Column A = 'Flower' OR Column A = 'Tree' it doesn't work. I also tried using Column A is in ('Flower','Tree') it doesn't work…
-
USPS API / Domo App? Need to Track Package Status Updates In Domo
Hello, I'm not a developer, but trying to help my company locate any existing infrastructure that might help us parse out USPS package tracking info so that we can join that to our orders with tracking numbers. This is their webtool info but it's way over my head.…
-
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 query not working
I was trying to use the domo.ds_query function and extract data between start_date and end_date. It gives me the following error. I don't know what is the reason behind this. It seems that when the start_date and end_date range is small, there is no error. However, when the start_date and end_date range is large, it shows…
-
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…
-
Can ddx cards automatically filter with normal cards when using page filters?
I am currently making a dashboard and needed a custom image to be used to display a value based on an ID, can ddx cards filter with the rest of the dashboard? Thanks ! :)
-
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…
-
APIs for sharing dataset with users
I am creating a dataset and adding pdp using APIs And now I need to share the dataset with the users programmatically are there any APIs for sharing datasets with users?
-
After applying PDP, the dataset is not visible to the user added in PDP
I have created a dataset and added PDP for a user but the user is not able to see the dataset. when clicking on the impact button it is showing the following pop-up Dataset created through apis
-
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.
-
Is there a way we can access the content of the "cards" entity via APIs?
By 'content' I am referring to the images, pdfs or any documents we attach in the creation of a card. Is there a way to access this material? I cannot find any endpoints in domo's documentation as well. Neither could I find any listing api for instance wide available cards. However, I did give a shot at using this api for…
-
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
-
Card Description Errors When Using CLI Restore-Card Function
Hello all, Curious if anyone else has had this issue and how they resolved it. After restoring a card through the Java CLI tool we're finding that the restored card's Description has been changed in negative ways. For example, at the page level (while hovering your mouse over the Card Title) we 1) lose the Card Title…
-
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"…
-
How to include nested folders in S3 advanced connector
Hello. I am trying to set up the connector that would fetch the data daily from S3 bucket. I am working on an advanced s3 connector as it seems to have a more intuitive way to grab the data. My S3 schema looks like this: `s3://adtech-third-party-data/AmazonA9/2021/09/` In DOMO settings credentials, I put…
-
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…
-
domo.ds_rename not found
I think this function is very helpful. However, it seems that this function has been removed. I would like to automatically rename the dataset name in Python and feeding the dataset to DOMO. Thanks!
-
Has anyone had success in reporting on the notes object in Salesforce?
I am trying to see if I can report on the notes object in Salesforce. Notes can be associated with other objects, like leads, accounts, and opportunities. We have reporting on almost all other objects currently, but can't seem to get to notes, figured I would check with the community. Thanks,
-
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!
-
Bulk updating of trigger frequency with PyDomo
Hi! Please advise if it is possible to write a code in PyDomo that would en masse change the trigger frequency of a long list of datasets/dataflows? Many thanks in advance!
-
Javascript API Requests Continue to Result in 401 Errors
I've been working on creating an app within React JavaScript and am looking to import data through an API request to DOMO dataset. I've tried to use XML HTTP Requests, Fetch requests, and jQuery Ajax requests as well, utilizing my dataset's id and passing in my log in and/or client credentials to the request. Despite these…
-
SSH postgres
I have a bastion server within my AWS VPC with access to our postgres database. I have confirmed that I can SSH from my office (with public IP whitelisted) into the E2C server and then connect to the database. When I try to set up the DOMO connector with the same credentials and settings it is giving me this error: "Failed…
-
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 =…
-
Exception: Error retrieving a Domo API Access Token: "status":401,"Unauthorized","path":"/oauth/toke
Hello, I'm using Python SDK to create a new DataSet in Domo. I use client id and secret, but getting the error above. If I do cURL-I get the access-token, all works good .If I use access-token in the script- I get this: ConnectionError: HTTPSConnectionPool(host='api_host', port=443): Max retries exceeded with url:…
-
Writeback connector error: An error occurred during processing: Script contains an error on line 1
Hello, We have created a new writeback connector and tested it in the new connector page. On that page everything works as expected. The next step is to Submit For Publishing. Then, once submitted we can self-publish to test it (this process is backwards IMHO). The problem is, when I try to test the self-published version…
-
Export Dash as PDF from button in UI
We're using DOMO Embed API and we have a client who would like us to create a report rather than a dashboard. They have requested functionality which would allow them to simply click a button built into our UI that would export the content. We plan to build the report out just as if it was a dashboard embed however, the…
-
with pydomo using DataSetClient data_export() to export dataset to string
dataset = DataSetClient() include_csv_header = True datasets_parent = dataset.data_export(dataset_id, include_csv_header) # datasets_parent = self.pydomo.datasets.data_export(dataset_id, include_csv_header) logging.info(f'datasets_parent: {datasets_parent}') return datasets_parent but I keep seeing missing 2 required…
-
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…