Connectors

How to create a column which SUMS based on the grouping of another column
Hello, I am trying to write an ETL which sums a value based on the grouping in another column (invoice number) which yields a column with the total quantity for each invoice. i have attached a simple table as an illustration of what i am looking to achieve. I do not want to write a formula where i have to continually…
How do/will connectors work with MFA?
Hi everyone... I'm trying to use The Trade Desk connector but when I fill in the credentials when setting up the connector, it fails as it can't authenticate. My assumption is because both of the accounts I tried to use (and I'm presuming all Trade Desk accounts) have multi-factor authentication enabled. I'm told you can't…
Connector Deprecation Announcement - Amazon Marketplace Web Service (MWS)
What is happening? Amazon is retiring the API that powers Domo’s Amazon Marketplace Web Services (MWS) connector in favor of its new Selling Partner (SP) API (https://developer-docs.amazon.com/sp-api/) on Sept 12th 2022. Customers who currently use the MWS connector will need to migrate to Domo’s Selling Partner (SP)…
Zendesk 1000 row limit
Hi everyone, I am trying to pull the data for call inbound from Zendesk connector. It seems, it's pulling only 1k rows. Is there any API limit to it? Is there a way to increase it ? Thanks.
Google Ads Connector - Location Data
Hi All, I'm using the newer Google Ads connector, and when I select Geographic View and select any of the geo_target_xxx segments (lets just do geo_target_state), I get "geoTargetConstants/21132" in my results. There are 51 variations of that 5-digit number, counting up from 21132 to 21184. I assume these are the states of…
Version Control for Query-Based Connectors
It would be helpful to mirror Domo's dataflow version control features in Connectors that use user-entered queries, such as the Snowflake connector. Currently the only way maintain a version history for these connectors is by housing the SQL code in Github or another external repository. Ideally users should be able to…
SSH postgres
I have a bastion server within my AWS VPC with access to our postgres database. I have confirmed that I can SSH from my office (with public IP whitelisted) into the E2C server and then connect to the database. When I try to set up the DOMO connector with the same credentials and settings it is giving me this error: "Failed…
Any plans to create connectors for App Store data?
I understand APIs are provided but any plans to create connectors for the API integrations? Specifically for Apple, Google and Amazon.
Password Protected .zip file - CSV Advanced Connector
I want to use the CSV Advanced Connector to pull the most recent file from an SFTP server. It is a .zip file that is password protected. I am able to choose '.zip' and select the latest file, but unable to enter a password so Domo is unable to read the file.
Pull Data from AWS Bucket which is encrypted.
Hi everyone, I need to pull the data from AWS bucket which is encrypted. Is there a way around to pull the data using Amazon Advanced S3 connector. Thanks,
Breaking down bundles into individual items
Hello Everyone, I am currently pulling in sales data from shopify. We have a core range of about 20 products and another 20 or so bundles which are made up of those core products. I am hoping for some assistance with how to break down these bundles into its components (core products) as we would love to see how the core…
Pull files from Amazon Bucket
Hi everyone, Amazon bucket is password protected, is it possible to pull the files in Domo using Amazon s3 advanced connector? Thanks
SFTP Writeback Connector Allow NO Field Enclosure
Currently, the SFTP writeback connector forces you to enclose each field with a Quote Delimiter. Request to make this optional as sometimes I know my data doesn't contain those characters and this overhead is causing Domo not to work for me as configured today.
Reach Data (LinkedIn Ads)
Hi All, I recently Swap approximateUniqueImpression column with averageDailyReachMetrics_approximateReach in my dataflow diagram. Even though the dataflow is running completely fine without error, it's the LinkedIn API is causing an error and making dataset update unsuccessful. Error: Domo is ready, but LinkedIn Ads…
Help with Converting Time Zone - 'DateTimeOffset' to 'DateTime' in SQL Connector
Hey everyone, I'm having trouble with a conversion from DateTimeOffset to Datetime in a SQL Query (inside a SQL connector). I am trying to convert my date columns when they are imported in DOMO as UTC so they are coming in as the right time (Db is UTC, Domo is Pacific) and convert them to DateTime. When I run…
Increase Zendesk connector row limit
Currently, the Zendesk connector is limited to 1000 rows, it would be great if we could select a time frame and pull more than 1000 rows!
CMiC
Hi Guys! Has anyone worked on getting data into Domo from the CMiC ERP system? I am looking for ideas on how to get that data and possibly what connectors or APIs I should be looking to use. Thank you ^_^
Linked Ads connector- Fields to Select
Hi, I am looking for Campaign Ads at daily level. What Fields I have to select in linkedin ads connector.? Thanks
Connect SQL Server Management Studio to Domo
Hi everyone, I have database in Microsoft Sql Server Management Studio. Is it possible to connect it with Domo instance using Microsoft Sql Server Connector ? https://domohelp.domo.com/hc/en-us/articles/360043436173-Microsoft-SQL-Server-Connector
Zoom Phone Calls w/ Call Log API
Hi, I am using the Zoom connector, which provides a good number of reports. However, we use Zoom Phone for our call center, and would like to be able to pull in metrics regarding phone calls. Here's their documentation for reference: https://marketplace.zoom.us/docs/api-reference/phone/methods/#operation/accountCallLogs…

Upcoming Events

Part 3: What’s New in Domo: GA Features You Should Be Using Right Now
In the third installment of our new feature release series, the ACE team walks through the latest Generally Available updates and how they translate into real business value. This session focuses on Worksheets, and Domo Documents, highlighting how these capabilities improve collaboration, streamline data access, and make…
AI Academy: Readiness Automation
Join Lindsay Gillespie as she walks through how to automate AI readiness workflows using a pre-built Pro Code App. Rather than building from scratch, attendees will be provided with the application files and guided through how to deploy, configure, and use the app within their own Domo instance. This session focuses on…
PDP Automation for a Fast-Changing Organization
Join Tyson Lewis as he walks through how to automate Personalized Data Permissions (PDP) to keep pace with a fast-changing organization. Learn how to implement both row-level and column-level security in a scalable, automated way so you can confidently share data while protecting sensitive information. This session will…
AI Academy: Workflow Inception - Leveraging Workflows Within Workflows
Join Tony Merrill for a deep dive into Workflows in Domo and how to take them a step further by chaining them together. In this session, we will build two workflows and show how one workflow can call another, creating modular, reusable automation that scales with your business processes. You will learn how to design…

Connectors

Discussion List