-
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…
-
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…
-
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…
-
Excel Auto Upload
Is there a connector which I can use to automatically upload an excel file from my computer into domo to update a dataset? I know Workbench has the capability of detecting when a file is changed then to rerun the job, but that is on one of our servers and not on my own machine. Is there a connector that can achieve this?
-
Snowflake Federated Connector 'No federated agent was found for the provided values...'
Have been using snowflake federated connector for about 3 months no issues then today all of a sudden receiving this error. The error displays when trying to 'create' the dataset meaning I am able to navigate through the scheme browser, select and view the dataset I want to connect but once I get to the final menu and…
-
Can you stream Salesforce data in real-time?
Hi Domo Community, Can you stream data from Salesforce into Domo in real-time? We recently switched to Domo for dashboarding and reporting. Our call center relies on Domo dashboards to set in-person appointments. The issue is that by default data can only be sent to Domo every 15 minutes. (Note: Our previous tool allowed…
-
CSV Advanced Connector Error (SFTP) - Failed to execute import successfully.
I am trying to pull a csv files with 47 rows and 14K records. It's giving an error "Failed to execute import successfully". It's only 1 csv files which is giving an error rest of the files I am able to export from the folder. What would be the issue ? Thanks.
-
Interpreting errors with Google Writeback - Enterprise
Hi All, I'm having an issue creating a google writeback for a dataset that I have access to (but don't own). I have done several Google Writebacks before with no issue. The problem is that it won't even create it and the preview gives me an error of: We had a problem generating your preview, please check that your settings…