-
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…
-
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…
-
Trying to connect my Marketo Smart list to DOMO
Hi Community I am trying to connect my Marketo smart list in domo to create a DOMO chart. But i am getting a error as " Failed to execute import successfully. " Can someone help me in fixing this issue . Will add the error screenshot and the setting page screenshot for more clarity.
-
Compressed (zip) Foler upload with 2000+ csv's, best way to upload and append all?
I am trying to upload around 2500 csv's of historical data into Domo to then compile into ~8 total files (they are deliniated in the file name of each output) and I can't seem to find an efficient solution to do this without uploading them individually. Any ideas? Thanks!
-
How to Setup UKG Connector?
Hello, We are trying to use the UKG connector, but it is not clear what all the fields are. Username: I assume this is a service account name? Password: I assume this is the service account password? Client Access Key: Not sure where to find this. User Access Key: Is this generated by the user account in UKG? Service Host…
-
Admin can't update connector passwords
I recently had to update the password for a connector that was assigned to another team member originally. However, I could not save the new password even though I am an admin. Is there a way to make sure admins can update connector passwords even if they're technically not the owners?
-
Json Connector to only run when data is pushed to it.
Currently, there is no option to change the schedule for the JSON WebHook connector. Since this impacts the billing when the connector is running every 15 minutes regardless if data is pushed to it, I'm suggesting an option to toggle when we want the json connector to only run when data is pushed to it.
-
ServiceNow connector - Name for custom table in setup
I'm trying to use the ServiceNow Connector (the non-Upsert version) to bring data in from various tables. The human-friendly name is My Requests, and the entity name is sc_request_list.do, assuming I've understood what I'm looking at. I'm kind of new to SNOW, so I could certainly be wrong. Here's the name on-page: And the…
-
Has anyone successfully used a connector to subscribe to an MQTT Broker
I have found the following article, which describes my requirements exactly, but can find no such connector. Am I missing somthing?
-
Domo Changing Values
Anyone know how to make sure domo doesnt change values in my uploaded excel file? Clearly, everyone one of the values in the excel file has .XX and nothing more. Domo is adding values to the upload. How do I get this to stop?