-
ETL Process to Analyze Google Reviews and Generate Automated Replies
Hi everyone, I’m exploring adding a step to an ETL process to analyze Google review data and generate recommended responses using ChatGPT or a similar tool. Currently, I have a Zapier connection set up, but it’s unreliable and inconsistent. Here’s what I’m looking to achieve: Dataset Input: I have a dataset of Google…
-
Is there a way to multi upload spreadsheets from a folder?
I want to bring a set of spreadsheets from my one drive folder to domo , all at once, instead of uploading each spreadsheet separately. How can achieve this in domo?
-
Shopify Products and Product Variants report moving from REST API to GraphQL API
Note: this announcement pertains only to the Shopify Connector (com.domo.connector.shopify). At this time, the Shopify Custom App connector (com.domo.connector.shopifycustom) is not affected. Shopify has released a new GraphQL and is slowly phasing out its REST API. As a result, Domo is adding new reports to the Shopify…
-
SharePoint connection help
I am trying to connect my instance with sharepoint. however there are categories to choose from site , subsite and more. I only want to connect the account to a sub folder in my sharepoint to later download the files from. How can I achieve this in domo and magic etl.
-
Slack Data Connector
Has anyone created a dashboard from the Slack data connector that could share their experience?
-
GA4 Connector append data
Hi I used the connector to bring 365 days of data into Domo from GA4 which took almost 14 hrs Now I don't want to use huge amount of credits on updating this daily. Was thinking may be instead I can append yesterday data only to these already pulled data. Any Idea how to do that? Appreciate your thoughts and solutions here!
-
Do Domo connectors work with MFA
I am hoping someone can answer this question. Do Domo connectors work with MFA? We have been using the FB connector to pull in reporting data but as of this morning it appears FB is requiring us to setup MFA for the FB account, we are using to access the data. My concern is will we still be able to pull in this data via…
-
File connector to upload file by file name, not id?
Hi everyone, what file connector should be used to upload a file to DOMO on a schedule? For example, we have \upload\filea.xlsx that we want to upload every morning at 9 am. filea.xlsx is recreated daily and the original file is replaced with the updated one, creating a new file of the same name. Thanks for any input!
-
Optimizing Google BigQuery Service Connector
We are currently funneling our Google Analytics 4 (GA4) data into BigQuery, and then connecting to BigQuery with 'Google BigQuery Service Connector' in Domo. We are partitioning using date keys and bringing in the past 3 days of data (to account for attribution in GA4) with an append. However, our daily updated rows ranges…
-
GA4 connector stopped on Importing ...
I was wondering if anyone else have a GA4 connector issue? I am waiting for a long time on the Importing status and nothing is happening. Normally it was super fast. Also the dimensions and Metrics I chose were checked already with and all should be good. I have restarted my computer, clear cache and several time login and…
-
MS Exchange Mailbox Connector
IDEA: This connector should have the ability to connect to multiple email accounts through MS Exchange Mailbox Connector. Currently having only access to 1 single email account is not very helpful and setting up multiple connectors is a lot of Manual Work. USE CASE: User wanted to analyze the email content from multiple MS…
-
No Code JSON - Upload File Containing JSON Data
I am getting the below error message when trying to manually import a JSON file using the no-code JSON connector. "Domo is ready, but there was an error parsing an expected JSON response from the API. Please check that the API is returning the expected data" I am using a JSON account with no parameters other than the name…
-
Strange datetime behavior when using the Five9 Domo Connector
I am using the Domo Five9 connector to pull a report containing list data into Domo and am encountering challenges relating to datetime fields. The two fields I am having issues with are: Timestamp - This field tracks the date and time that a given record was added to a list. created_date_string - This field within Five9…
-
R - Domo API SDK (rdomo) - Working??
Hi, My colleagues and I, from various departments including Research and Accounting, were surprised when the Domo API stopped responding last Tuesday. Initially, we suspected it might be an issue with our IT Department, but they promptly confirmed that they hadn't blocked any API calls and had checked their firewall…
-
Can I alter or replace the connector for a given dataset?
The MySQL SSH connector I had been using stopped being able to connect last week after my network administrator retired the server that I was using as an SSH tunnel. I can still connect to the target database using a direct MySQL connection and would like to alter the connector settings or swap it with a different…
-
Connectors - Enhance Scheduling
Currently, the scheduling capability with respect to Connectors is based solely upon UTC (see first screenshot below). The scheduling capability available with respect to Magic ETL 2.0, however, provides the user flexibility to specify timezone (see second screenshot below). Can the scheduling capability with respect to…
-
Duplicating Connectors
Although there is the option to duplicate dataflows, it would be nice if we could also duplicate connectors. Some connectors are more complicated and have very specific settings that are crucial to getting the right data in. Currently, I'm testing out Facebook API Connectors and it's not efficient to constantly check that…
-
Ability to create a copy of a dataset, and then update settings
SO OFTEN we have to bring in multiple datasets from a single connector. It can be an incredibly time-consuming process, with many of the same steps taken over an over again. If we could simply set up one dataset, then make a copy with a new name, and adjust settings, it would save HOURS…so many hours. It would also make…
-
Sharepoint Online Rest connector - "selected file may no longer exist"
I notice I get the subject line error message for Sharepoint Online Rest Connector when someone updates the sharepoint file for a couple of datasets, even though it has the exact same path, name, sheetname, etc. And then I have to go into the Domo dataset settings and re-select the file. Could this have anything to do with…
-
sharepoint connector - server relative url
We have a new sharepoint site and have transferred our files there, so I'm needing to update the server relative urls in the sharepoint connector settings for datasets. Is there an easy way to determine the server relative url? We ran this and got the info highlighted in yellow: I've tried…
-
Workato - Pulling data into Domo
Has anyone successfully connected to Workato and pulled in admin report and data for system monitoring? Looking to connect from Domo into Workato. Assuming this is thru a Json connector, but need guidance and code if you have an example to work from.
-
How to pull data from a report within a website report
Hello, We pull pricing information from the USDA: https://mymarketnews.ams.usda.gov/public_data Previously, we used an advanced HTML connector and it was easy enough to just swap codes out in the path to pull the item I wanted information on - example below ONS was for pulling onion pricing. They have changed their website…
-
Facebook Ads Advanced Custom Insights report > change in available unique metrics
On Oct 30th 2024, Facebook will make a change to the API that powers the Custom Insights report in the Facebook Ads Advanced connector (com.domo.connector.facebookads.) The change to the API will restrict the action_type breakdowns returned by the unique_actions and cost_per_unique_action_type fields to the following…
-
Amazon Product Reviews API
-
New Dataset from Connector History
I occasionally have to use this download menu item in a dataset connector's history to download a csv and then import the csv into Domo to use to compare against current data. It would be super handy if we could cut out a step and provide a menu option to create a new dataset as well.
-
What is the workaround to pull in more than 4 dimensions with the Adobe Analytics connector?
We are using the Adobe Analytics v2 OAuth Partition Connector - Server to Server connector. (https://connection.domo.com/appstore/connectors/com.domo.connector.adobeanalyticsv2.server?origin=search). This connector only allows you to pull in 4 dimensions. Unfortunately, that is not enough for one of the events I am trying…
-
Mega-Ultron-Super-Duper Connected Dataset to rule them all
BLUF: Should I join/append all of our data so we have one workable dataset? This isn't a technical question, but rather theoretical. We've got data in many places (I'm sure this is common): Budget in XYZ Financials in ABC Stats in DEF Stats Historical (just switch systems so have a different datamart) in LMN Everything…