-
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…
-
Issues with Bing Ads Connector
Hello All, Relatively new Domo user here, I just established a connection with Bing Ads to start pulling in all of our stats for our Bings Ads and straight out the gate I am seeing some significant inaccuracies with the data I am getting in Domo. Has anyone else had issues with Bing before? I know sometimes there can be…
-
DV 360 Connection Error
Hi everyone, I am trying to connect with DV 360 and facing the below error. Is there any steps that needs to be done in Google Console? If yes, please help me with the steps. Thank you.
-
New Data Setup From Account Page
I'm surprised this hasn't been mentioned yet. I didn't see anything when I searched for it. It would be nice to "Add Data" from the Accounts pane. Right click or even the existing options button open the modal appropriate for that Account. It's kind of a pain to have to search for a connector first and then select the…
-
Integrating with BlueCherry ERP
Hello Domo Community,I am reaching out to see if any fellow Domo users have experience integrating with CGS's BlueCherry platform. Specifically, I'm interested in understanding: Successful Integration Stories: Have you successfully integrated Domo with BlueCherry? If so, could you share how you approached the integration?…
-
Building custom connectors IT and Infosec systems
Hi, I am trying to build a bunch of custom connectors for various systems. I have built connectors for SentinelOne (updated one I created in a past job) EndOfLifeDate, DMARCLY Abnormal Email. I have had no luck with the existing JIRA connector so I am looking at creating my own JIRA connector but also creating connectors…
-
Can Domo Workbench Support TCP/IP Over SSH for Secure Database Connections?
Hi everyone, I'm working with Domo Workbench on a remote desktop (RDP) and need to securely connect to a MySQL database hosted on a private network. Typically, this is done via a TCP/IP connection over SSH, which adds an extra layer of security by encrypting the connection between the client and the database. However, I'm…
-
Google Analytics 4 Preferred Connector Error 401
I'm currently attempting to pull data for a GA4 account into Domo using the preferred Google Analytics 4 connector. I've selected all of the dimensions and metrics that I would need, but when I attempt to run the dataset it will attempt to pull the data in for around an hour and then return '401 : Unauthorized : Error…
-
Sub Directories in SFTP Connectors
Sub directory paths need to be enabled in the standard SFTP connectors. Limiting the ability to the root directory is too limiting as most people do not write to that directory and some are not able to. Please make this an option.
-
Parse data with no header
I have an API which pulls in data {"name":["details"],"name":["details"],"name":["details"],"name":["details"],.. If I MagicParse this I just get ONE long row with these details. What I am after is 2 columns of Name and Details. I have parsed the data and added the columns titles but how do I reference the data? for(var…
-
Multiple versions of Adaptive Insights sheets
Is it possible to get the Adaptive Insights connector to pull in multiple versions of the same sheet at once? Right now you select the version before selecting the sheet, but it would be helpful if we could select the sheet first, then pull in multiple versions at once, rather than have to create many different datasets…
-
Direct Query against on-prem source
Can Domo perform a direct query against an on-prem SQL Server instance? For example, if I have a database named "SalesDB" on my local SQL Server, can Domo connect to it and run a query like "SELECT * FROM Orders WHERE OrderDate > '2024-01-01'" directly? I thought workbench would've have that option.
-
Domo Connector trap errors
I have created a connector which works fine in Dev and has no problems when creating a dataset from Dev - however when I publish it I get error 'An error occurred during processing: Domo is ready, but the script has errors: "SyntaxError: Unexpected token < in JSON at position 0"; at line number 7; ' There is no problem…
-
Account transfer from Regular to Key Pair
Is it possible to mass transfer Datasets from a regular Snowflake Connection account to a Key Pair connector account?
-
Unable to get access_code with Oauth 2.0
When I use Oauth 2.0 authentication, I can get the 'code' through the Authorization URL, but when I fill in the Access Token URL, I can't assign the 'code' that I got earlier However, when I fill in the Access Token URL, I can't assign the 'code' that I got before to the 'access_token', so I can't get the 'access_token',…