Connectors

SQL Connector dataset set to 'Replace' but the data remains the same
I am using the preferred SQL Server connector and pulling in data. However I want to "restart" this dataset and wipe it out to 0 rows. I set the update method to Replace and modified my query to return 0 rows. I can see my preview returns no rows: However when I run this, the updated rows shows - and the total row count…
PayCom Connector?
Hi Domos, Does anyone have experience connecting PayCom (HR & Payroll software) to Domo? There is no canned Connector in the AppStore.
SQL Connector Returning No Rows
I'm sure this has been answered but I can't find it, so I'm hoping this is a simple answer. I have a SQL dataset that was returning rows but currently returns no rows. This is expected and should continue to switch between returning rows and returning no rows. The issue is that when it returns no rows the dataset in DOMO…
IDE Timeout changed to Inactivity Timeout
I send alot of time in the IDE creating numerous connectors and I often get kicked out whilst Im working. Its not inactivity as I can be in the middle of typing and get kicked out of the Developer platform, have to reenter my domain, enter my connector and 'most' of what I have just been typing is still there!! Can this…
when Building a connector I often get kicked out
I have spent a bit of time creating numerous connectors and I seem to often get kicked out. Its not inactivity as I can be in the middle of typing and get kicked out of the Developer platform, have to reenter my domain, enter my connector and 'most' of what I have just been typing is still there!! Any ideas? Is this a…
Amazon Vendor Central PO
Hi there, I am trying to pull Amazon purchase orders from Vendor Central. The current Vendor Central connector does not seem to be able to support that query. Has anyone found a good way to pull those? Thank you
Does Domo publish a list of new releases or version changes made to their APIs?
Does Domo publish a list of new releases or version changes made to their APIs? I am seeing a case where we are pulling from the data sources API but looks like the data type returned in the API call has changed, causing some things to break on our end. This is an API call to the endpoint: 'https://{our business domain…
Amazon Vendor Central POs
Hi there! I am trying get Amazon Purchase Orders from the Amazon Vendor Central, but I was not able to find a easy way to pull that data. Does anyone have a work around/way to get that data to Domo?
DomoStats 3rd-party connectors
Do you know when the Domo State 3rd party connectors are being deprecated? I'm trying to utilize the DomoStats connectors (new and old) and was wondering if I need to switch over to the new one sometime soon. Thanks!
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…
Google Sheets Connector Issue?
Hi Team, I'm trying to get Google Sheets connected but receiving this error: I've verified that I can connect to Google Sheets by "Re-connect"ing on the Connectors menu. I cleared Cache/cookies/history, and this has worked in the past so I've never had this issue. Any ideas?
Connecting to Dataverse
Has anyone connected to a table in Microsoft's Dataverse? If so, how did you connect to the data?
DomoStats Datasets report - Add Cloud Provider
Hi team, Our DomoStats Datasets report doesn't currently include a field which shows the cloud platform a dataset is stored on (e.g. Domo, Snowflake, Redshift). Same with the Domo Governance Datasets connector. Raising this here because a customer is looking for this functionality, and I do think it would be a useful…
JSON Connector - File without extension
Hi everyone, I need to connect with a EndPoint that has an specific Id, domina,, viewId and apikey. I have tried out many Json connector without any luck Is there any specific connector that I can use considering the following parameters? EndPoint id domain viewId apiKey
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…
PostgreSQL Connector vs Postgres Federated SSL Error
I have two accounts setup: the native PostgreSQL Connector the Federated PostgreSQL connector I can successfully query and retrieve data from the Federated PostgreSQL connector but when I put the same credentials into the native PostgreSQL Connector and try to run a custom query against it, I get the error: Error setting…
Export data from DOMO to Google Sheets on Schedule
Hello! I imported data from Snowflake using federated dataset to DOMO. Now I wish I can export this dataset to Google Sheets. I've tried Add-on, it partially works but it can't automatically run on schedule. I've also tried to use Magic ETL to writeback data but I can't get access to the API so it doesn't work. Can anybody…
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…
Json No Code and Json No Code oAuth Connector - Add response details
These connectors both return errors that start with "Domo is ready but…" in the dataset history which provide very little detail into the error that actually occurred. I'm not sure but from examples I've seen it seems like this might be a generic set of messages based on the HTTP status returned. I appreciate that Domo…
Zoom Connector - Webinar Reporting Challenges
Many people in our organization frequently conduct Zoom Webinars as part of our business model. The most important KPIs for us are # Registered and # Attended. Perhaps I am approaching this wrong or this is an opportunity for enhancement of the connector, but we have the follow challenges: Webinar Participant Report - the…
Best Way to Fetch GT Metrix Stats for Multiple URLs?
Hey everyone, I’m trying to build a GT Metrix connector to pull performance stats for about 40 URLs. I figured out how to bring in data for one URL at a time, but setting up 40 individual connectors and merging the results doesn’t seem like the best approach. Is there a way to request reports for multiple URLs at once?…
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.
Google Sheets - Metadata Import
As an analyst I'd like to import metadata about the Google Sheet as columns Metadata like: Google Sheet Name, Google Sheet Tab Name, and any other attributes that might be available In order to do automated data quality checks, and provide enhanced exploration on data sourced from Google Sheets
Create a concatenated field as part of SQL query and use it in Salesforce Adv connector merge key
I am working on setting up a Salesforce Advanced Connector, and use the query mode to select my data. In this selection, I created a custom field called merge key as below, CONCAT(CaseNumber, '_', LastModifiedDate) AS Merge_Key # also tried below, but same result CONCAT(CaseNumber, '_', FORMAT(LastModifiedDate, 'yyyy-MM-dd…
DataDog Dataset Join to Showcase Monitors and Events Together
Hello, I am trying to join the DataDog Events and DataDog Monitors datasets but I have not found any way to join them. I want to show every event that has occurred for each monitor over time with their severity. I have been looking at each of the respective datasets IDs and I could not find a primary/foreign key pair to…
Snowflake Connector | Partition Functionality
Which Snowflake connector is best suited for efficiently utilizing partition functionality when working with datasets that need to be partitioned across multiple columns? For example, if a dataset contains sales data and needs to be partitioned by columns such as region and sales_date to optimize query performance and data…
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?

Connectors

Discussion List