-
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.
-
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',…
-
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…
-
How to get Gross Sales from Shopify?
My team and I are in the process of building datasets from Shopify's API but we are not able to get the gross sales amount to match with the gross sales amount in the Shopify's dashboard. Does anyone have any insights on this? We selected the report "All Orders". We have played with all columns, total_price,…
-
Shopify Payouts
Hi, Does the Shopify connector have payout details, including the transactions within each payout pool?
-
Can parameters have dimensions other than "report" ?
I'm working on a custom connector, and have a quick question. In "Advanced Mode", is the "Show When" input able to use dimensions other than "report"? Trying to make it so that when a user selects a "Geographic Breakdown" (e.g. Geographic Breakdown == 'State'), a new "State" parameter appears where a user can select the…
-
Google Ads Connector isn't pulling in Product Feed Demand Gen Campaigns
I have multiple Google Ads Connectors setup to pull in at both an 'Ad Group' and a 'Campaign' level for pulling in PMAX as well as normal campaigns. I'm getting all of the campaigns that I need aside from one single campaign. We are also storing this data in Looker Studio with a 3rd party connector tool and it isn't…
-
Upload Spreadsheet Large Files Connector - Not uploading all data
Hi All, I have a dataset that I need to update using the Upload Spreadsheet Large Files connector, however when I drop in the new dataset it only seems to import 31,074 rows of data when it should be a couple of hundred thousand. For reference I've tried uploading as a CSV & an excel workbook - does anyone know why this is…
-
AzureAD to Domo for User data
As there is no direct connector in Domo for AzureAD, what methods are people using to import AzureAD user data to Domo? The main goal is to import user data and pick up different attributes such as last sign-in, job title, department, groups etc. We would prefer not to use Workbench, how are other companies doing this?…
-
"We're sorry but the system can't do that right now." - Connector Builder
I'm trying to build a custom connector to draw data from the College Scorecard website. I'm using Javascript to write the data processing script and haven't been receiving any errors with my code. However, when I run the script, a new page opens that says "We're sorry but the system can't do that right now." When the…
-
How do I make a Domo to Power BI Connection with Microsoft Authentication or Okta SSO and not ROPC?
Using the connector on the left requires an ROPC verification type which asks for the users Password. Our security requires that we work through a redirect with SSO and a token is passed back so passwords are only entered in one area. I believe the MSAL connector on the right should fill that criteria but it is still…
-
New Grant to Manage All Connectors for Admins
It would be nice for admins to be able to view and manage all connector accounts. Currently, admins cannot see which accounts are in the environment without creating a card or having the account shared with them. Even then, they are not able to manage who has access to them without being the owner. Our current work around…
-
LinkedIn Ads Connector - Upcoming update to the 'Ads Creative (versioned)' report
On Monday, July 29th 2024, Domo will update the version the API endpoint that is used to generate the 'Ads Creative (versioned)' report in the LinkedIn Ads connector. Datasets that are powered by this report at the time of the update will be affected as follows: (1) Columns that are populated by the older version of the…
-
I have AWS ELB log files stored in S3 that I want to load into Domo
I have been unable to get the S3 Advanced connector to process the file. The connector has successfully connected to the correct bucket in S3. The logs are space-delimited text files that use double quotes around multi-word elements. The files do not contain headers. Since there are no headers, how do I name the columns in…