-
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…
-
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 ^_^
-
Shopify Connector - Partial Refunds not showed in refunds report
I am trying to get the refund amount from orders with the financial status "partially_refunded" and therefore I am pulling the "Refunds" report from the connector. However, it seems like only fully refunded orders are listed here. Is there a way to get "partially_refunded" orders in this report as well (or is there a…
-
Linked Ads connector- Fields to Select
Hi, I am looking for Campaign Ads at daily level. What Fields I have to select in linkedin ads connector.? Thanks
-
Is anyone having issues with Dropbox datasets?
We have five Dropbox datasets that have failed to run. "Domo is ready, but we could not find a file at specified path. Please enter a path for a file uploaded on dropbox." They have been running continuously for the past month up until that point. The files are across two separate Dropbox accounts, so it can't be a…
-
Bing Connection - Almost there but....
I've tried to connect to the bing connector. I've done the app registration in Azure, but when I go to link the connector I get an error that reads as: Domo is ready, but the credentials you entered are invalid. Verify your account credentials and try again. But, I am connected, and have done all the steps in Azure I feel…
-
Google Sheets connector datasets failing due to auth token expired.
Hello, I am seeing that something today happened for all of our google sheet datasets via connector are failing or having long run times due to this error message. "Domo is ready, but the authentication token is expired. Please verify your account credentials and try again" Does anyone know the resolution for this? I tried…
-
If possible, how can I call a Stored Procedure or Function?
I am converting some dashboard in Tableau to DOMO and have run in to some obvious differences between the two. I'm trying to figure out how to pass a user selected field from DOMO to a Stored Procedure or Function as an argument. Right now I am reading in the entire table of xx million rows and would like to be able to…
-
Snowflake federated dataset refresh
have created a Snowflake federated dataset with a Cache TTL of 900 seconds. I have some confusion about the following. When I add reload data to my base table in Snowflake, I expect the Federated dataset to run in real-time or after 900 secs. But I don't see my 'Last run' section getting updated on the Dataset Overview…
-
Importing a CSV using SFTP and double quotation marks to isolate the data
Hi, this is a bit of an odd question but will do my best to ask it. I have a CSV file i am pulling for a SFTP, the file is in a CSV format and pulls the headers and first cell but it stops. After each comma the data is wrapped in double quotation marks, for example: 12328354,"User Name","1","Company Brand, Town" from that…
-
Shopify Inventory Level at Location
Hi everybody, I'm looking at a solution to retrieve the inventory levels of my products in Shopify. Any idea on how to do it without using an external connector? Thanks