-
Sharepoint lookup id field
I'm hoping someone in the community has done this before. I'm using the Microsoft Sharepoint Online Rest Connector with the List Items report to pull a list of files and their metadata from a document library. One of the fields is set up as a "People and Groups" lookup field in sharepoint, and in the Domo Dataset, I'm just…
-
Removing Duplication and Ordering Objects within a Concatonated Field
Hello, Our company offers several different product lines and I am attempting to count how many times each combination is owned. There is a field that comes through to Domo from a SFDC connector with this information, but there is a ton of duplication within as a customer can own multiple of 1 product. Example: I'm…
-
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…
-
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.
-
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…
-
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…
-
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
-
If possible, how can I call a Stored Procedure or Function?
I am converting some dashboard in Tableau to DOMO and have run in to some obvious differences between the two. I'm trying to figure out how to pass a user selected field from DOMO to a Stored Procedure or Function as an argument. Right now I am reading in the entire table of xx million rows and would like to be able to…
-
Snowflake Federated dataset refresh rate
I have created a Snowflake federated dataset with a Cache TTL of 900 seconds. I have some confusion about the following. When I add reload data to my base table in Snowflake, I expect the Federated dataset to run in real-time or after 900 secs. But I don't see my 'Last run' section getting updated on the Dataset Overview…
-
Snowflake federated dataset refresh
have created a Snowflake federated dataset with a Cache TTL of 900 seconds. I have some confusion about the following. When I add reload data to my base table in Snowflake, I expect the Federated dataset to run in real-time or after 900 secs. But I don't see my 'Last run' section getting updated on the Dataset Overview…
-
Importing a CSV using SFTP and double quotation marks to isolate the data
Hi, this is a bit of an odd question but will do my best to ask it. I have a CSV file i am pulling for a SFTP, the file is in a CSV format and pulls the headers and first cell but it stops. After each comma the data is wrapped in double quotation marks, for example: 12328354,"User Name","1","Company Brand, Town" from that…