-
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…
-
Dayforce Connector
Hello Has anyone used this connector and did you have any problems with the credentials? We had someone with Admin role try to use her credentials to connect but it says invalid. We are trying to work with Dayforce to figure out the issue, but thought I'd ask Thanks
-
How do you pull Revenue data from Facebook connectors?
I'm trying to create a marketing dashboard for my company that looks at revenue, spend, ROAS, etc. I am able to pull spend and a value for ROAS, but I can't seem to find the variable for revenue. I know Facebook usually refers to revenue as "purchase conversion value" but I can't find that variable when selecting the…
-
Ironclad integration
Has anyone try and was able to integrate and pull data from Ironclab app? If yes, please share tip and trick how to do so
-
Facebook Ads Advanced Connector Error - "You are calling a deprecated version of the Ads API. "
I have facebook ad level data and Facebook campaign level data being pulled in daily - today it didn't run automatically and is running the error: "DOMO is ready but Facebook returned an error: (#2635) You are calling a deprecated version of the Ads API. Please update to the latest version: v13.0." What do I need to do to…
-
Domo unable to pull all fields from Jira using "standard ticket report". Need assistance please.