-
Unable to create a dataset
Hello We have added a dataset and while trying to add dimensions and metrics in settings, we are receiving an error: "Domo is ready, but Adobe Analytics responded with an error: User does not have access to the global dimension for this request." We have Administrative Access to Adobe Analytics. A Any Suggestions would be…
-
Major Domo Practical Test
Activity #1:The DomoStats connector allows MajorDomos to run reports based on users, DataSets, activity logs, and many other areas. You should use these reports to create cards that inform you of the activity and users within your instance, to better maintain and govern your instance. In the Domo Appstore, find and connect…
-
Anyone experiencing Shopify connection issues?
I have tried to create a new Shopify connector by using our domain name and user login. Everything works up until that point. After signing in to Shopify, I get the error: "Oauth error invalid_request: Your account does not have permission to grant the requested access for this app. You may be able to resolve this issue by…
-
IP Whitelisting
Hi, I have a client who is looking to use the SFTP Writeback Connector, an external organisation who hosts the SFTP server wants to whitelist the incoming traffic from Domo. The client wants to understand if this means that they should simply whitelist their instance URL? Or is it more complicated and would they have to…
-
Sharepoint lookup id field
I'm hoping someone in the community has done this before. I'm using the Microsoft Sharepoint Online Rest Connector with the List Items report to pull a list of files and their metadata from a document library. One of the fields is set up as a "People and Groups" lookup field in sharepoint, and in the Domo Dataset, I'm just…
-
Teams webhook on alerts
Does anyone have configured a Teams' webhook on Action section for alerts? When I insert my incoming webhook url and try to send a test, it's failing.
-
ETL sometimes does bring information and in others it does not
I have a connection with QuickBase, sometimes when I execute my ETL it does bring the information correctly, but if it is executed more than once the result is zero records, does this happen to anyone else?
-
Find the source table of an API connection
We have a data table that nobody seems to know the origin. All we know is that it is an API connection. Is there a way where we can see the API code within Domo to see what the source data is for this table?
-
How do/will connectors work with MFA?
Hi everyone... I'm trying to use The Trade Desk connector but when I fill in the credentials when setting up the connector, it fails as it can't authenticate. My assumption is because both of the accounts I tried to use (and I'm presuming all Trade Desk accounts) have multi-factor authentication enabled. I'm told you can't…
-
Google Analytics 4 property not showing in connector
I have a google analytics 4 property monitoring my iOS and Android apps but don't seem to be able to access the data through the Google Analytics Connector. The authenticated user definitely has access to the property (in fact full admin rights) and it is active. I've looked through other connectors, but there don't seem…
-
Refresh Excel datasheets that have been uploaded via Plugin
I recently started using Domo and have an Excel spreadsheet with several tabs that I uploaded to Domo via the plugin. I created a dataset for each tab and then appended them for a single output. This spreadsheet is updated by a few different people and I need to update it probably 2-3 times/month. I tried searching the…
-
Connector Deprecation Announcement - Amazon Marketplace Web Service (MWS)
What is happening? Amazon is retiring the API that powers Domo’s Amazon Marketplace Web Services (MWS) connector in favor of its new Selling Partner (SP) API (https://developer-docs.amazon.com/sp-api/) on Sept 12th 2022. Customers who currently use the MWS connector will need to migrate to Domo’s Selling Partner (SP)…
-
OData connector -- returns list of tables rather then data from tables
Hi folks, We have connected to an application DWH using the OData connector. In Domo this connector produces a list of the tables available but not the data from these tables. How do we get the data from specific tables? My frame of reference here is Power BI which displays a list of tables, once connected, to select and…
-
Zendesk 1000 row limit
Hi everyone, I am trying to pull the data for call inbound from Zendesk connector. It seems, it's pulling only 1k rows. Is there any API limit to it? Is there a way to increase it ? Thanks.
-
Google Ads Connector - Location Data
Hi All, I'm using the newer Google Ads connector, and when I select Geographic View and select any of the geo_target_xxx segments (lets just do geo_target_state), I get "geoTargetConstants/21132" in my results. There are 51 variations of that 5-digit number, counting up from 21132 to 21184. I assume these are the states of…
-
Is there any way to connect or join an excel spreadsheet to a dataset that is already in Domo?
Hi All! I am new in Domo and I don’t have an IT background but I have gone through the Domo Certification Training (pending the tests). I am trying to get my excel spreadsheet to get updated every time the cards in a dashboard in Domo updates, I have tried to use Magic ETL to join my data but I have not been able to get an…
-
DOMO Groups
Hi DOMO Team - Good Day! I just need some help with regard to groups. we created a list of new groups for all our people and created a card to show all the groups that they are in and it shows that including the new group that we put them in. we would like to create a Beastmode where, when this person is in their 'legacy'…
-
Google analytics filter capabilities
Is there a way to see google analytics campaign data filtered by Source or Medium? They are imported as two different data sets and I don't see a common key that I can join the two by.
-
How do I convert a string to a date within Magic ETL?
I've seen questions asked about converting string to date, and answers were all given to use Beast Mode or add a separate field. Is there a way to do this in Magic ETL? I want to just have all the cleaning done in one place but can't find a way to do this in either version of Magic ETL.
-
Any plans to create connectors for App Store data?
I understand APIs are provided but any plans to create connectors for the API integrations? Specifically for Apple, Google and Amazon.
-
Create a view table in Access to a Domo Dataset
I know there is a way to do this i just cant find it. I have an Access Database that I use daily. I would like to create a table view to a DOMO dataset so i can run analysis in my Access database. I know there is a way to 'connect' the DOMO data to the Access database, just a newbie that needs a little direction here.…
-
SyntaxError: Invalid JSON when using the DOMO Governance Datasets Connector
Hi DOMO - I just want to know why I am getting this error when I try to create a dataset using the DOMO Governance Datasets Connector > SyntaxError: Invalid JSON: <json>:1:0 Expected json literal but found N No subject alternative DNS name matching five9.com.domo.com found. ^ at line number 24 Need help to know what I am…
-
How to download domo dataset to a linux server using Python?
I have been using pydomo python SDK to access and download the datasets from domo to a linux server. I have been able to build a script which can pull the details of the dataset from domo: Details look like below: 'lastSuccessfulExecution': {'createdAt': '2022-10-26T11:42:15Z', 'currentState': 'SUCCESS', 'endedAt':…
-
Transition from a regular PostgreSQL connector to PostgreSQL SSH connector
We want to start using the "PostgreSQL SSH" connector in place of the regular one. We already have a number of datasets created, so I'm wondering if there's an easy way to have a dataset use the new SSH connector. I really want to avoid recreating all of the datasets. The post below makes it sound like this isn't possible…
-
Automating file load from dynamic file structure
New to Domo Is there any way to automate loading files from a dynamic file structure / path? I am trying to figure out a way to automatically fetch files where the subfolder may change based on input location. The file name and type remain constant, but the folder name can vary. Hoping there might be a clever way to use WB…
-
Best way to get parquet data from AWS S3 bucket?
We have some parquet files being replicated to an AWS S3 bucket. I've started to look to see if I can use Amazon Glue to crawl the bucket, Athena to query the Glue table, and then Domo to pull data from Athena. I'm running into a few issues (like the initial load file Glue picks up as a table, says it has rows, but Athena…
-
Creating an HMAC and pushing data to a JSON Webhook connector with a secret applied
It can be a little confusing when trying to setup the JSON Webhook connector with a secret applied and push data successfully. The biggest hurdle can often be creating the HMAC to pass in through the header. Depending on the source that you're pushing from or what programming language you're using will change the setup…
-
MySQL Connector vs MySQL Partition Connector "Near Realtime" Performance Best Practice?
Hi all, I'm currently investigating the best practice for performance connecting with MySQL for a "near realtime" connection for monitoring missed call tickets in Domo. The idea is Domo will replace both FiveTran and Snowflake. Any guidance is highly appreciated!
-
Combining two data sets
Hi. I have two datasets. One is leads generated by date by employee (in addition to other fields). The other is hours worked by date by employee (in addition to other fields). I have tried to combine this with Magic ETL but the data never comes out right. I want to be able to calculate leads per hour and be able to display…
-
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…