-
Weird warning "This DataFlow is incomplete" on QBO connector
So we run the Domo Cloud Connector quickbooks online (and advanced) and often get this warning, even though the dataflow shows as having run 100% successfully. "This DataFlow is incomplete". It is odd though, after waiting about 10 minutes, the output dataset does show up. Also, why the huge lag for datasources (even small…
-
Quickbooks Online - received $ transactions
Hello, we are trying to get our received $ transactions at the lowest level of detail /and at day level from quickbooks online with domo cloud connector(s). To be clear we are not talking about invoices, but rather paid invoices (e.g. deposited in the bank, so QBO registers it as a paid invoice in QBO). Can anyone give me…
-
API Dataset description
Hi All, Can someone plz tell me how to check description and columns level information for API dataset? I found below link but where to run these codes? https://developer.domo.com/docs/dataset-api-reference/dataset
-
Adobe API Connection
How can I correct dimension name in advance query of Adobe connector in DOMO? The dimension name is not right what Adobe Suite is showing in DOMO. Check the first option , "Content -> Show ". I tried every possible name in advance query but it is getting failed.
-
Date Column importing incorrectly (subtracting a day)
I am using the Microsoft Sharepoint Online Connector to bring in some data from an excel file. I have a date column, that for whatever reason, comes into the DOMO datebase a day earlier than what is listed in the excel document. It has also added time to the date column. I have tried lots of different date formats to see…
-
Specifying Multiple Emails for Dataset Via Email Connector
Hi all, I have a simple question, I'm making a Dataset Via Email connector and I want to specify certain emails to load the data from, however I'm not sure how to insert multiple emails in "From Email Address" in settings. For example, I want to include two emails, say x@y.com and z@y.com in the "From Email Address" field…
-
Does Domo already have a table of population by state?
Statistically normalizing to population by state is a frequent calculation. Does Domo have a built in table detailing a states population or other means by which to perform normalization by population?
-
Is it possible to connect from Domo to an AWS RDS instance via AWS privatelink?
My company is an AWS user. I'm considering creating a MySQL RDS instance and then using it as a data source for Domo. In order to improve security, I'd like to connect via the AWS network rather than the Internet. I believe that AWS PrivateLink is intended for this purpose. Can anyone help? Thanks Neil
-
Stuck: Dropbox File Advanced Connector
I am trying to get a file from Dropbox using the Dropbox File Advanced Connector and am so far not having any luck. Here is a short video to demonstrate what I’m doing:
-
Week of the year seems odd
Hi all, I am showing my graph interval by week. But the weeknumbers seem odd. week 53 - 2020 = 30 december 2020 week 2 - 2021 = 3 january 2021 Is week 1 only 2(to 4) days? Can someone explain this? This seems like a mistake in Domo rather than in my data, right?
-
ETL Slowed down by large Data Input
I'm currently using a dataset in a few dataflows that contains around 10M rows of data (this includes historical extracts from the last day of each month as well as the previous day). Any ETL process that is using this dataset as an input takes a long time to run due to all of the rows having to load in before anything can…
-
Encoring Issue Import Adobe Analytics Data using CSV SFTP Push Connector
I try to import Adobe Analytics Data using CSV SFTP Push Connector I followed this KB. https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_File_Retrieval/CSV_SFTP_Push_Connector But encoring error happened. Does anyone using this? I try to selected encode 'auto' ,…
-
Datefield recognized as text
Is there a way to view the faulty date which is actually seen as text? Because I can't just check them all by hand. Thanks in advance
-
Connect Airtable to DOMO as a PostgreSQL database
Hello everyone, I'm excited to share a new tool we built to connect Airtable to DOMO - Sync Inc (https://syncinc.so). With a couple clicks, we'll setup a hosted Postgres follower database containing all your Airtable data. We keep your database in sync in real-time. All you have to do is connect your Sync Inc database to…
-
Connecting to Office365 Exchange Calendar
I'd like to extract information from our Office365 implementation of Outlook/Exchange, specifically the calendars. Can the existing Microsoft Exchange connector be used to accomplish this? It is asking for a URL and I don't know what would make it happy.
-
Maximum length of console output exceeded
We are using Datagrid connector type to create custom connector. After the authorization step, while calling external API to fetch order details, the resulting response displayed in console is limiting to only one record giving message - Maximum length of console output exceeded. Please do let us know what might be the…
-
S3 RO credentials with Amazon Web Services Billing Connector is giving a "Failed to authenticate"?
We are attempting to use the pre-built Amazon Web Services Billing Connector to connect to the S3 bucket containing our cost and usage reports. The access key/secret key credentials have read-only and list permissions to the bucket: { "Version": "2012-10-17", "Statement": [ { "Sid": "ListObjectsInBucket", "Effect":…
-
DOMO Connection to SharePoint online File
Hi! Help will be greatly appreciated. I have been trying to connect one of my sharepoint file to DOMO but it is always giving me an error with the Server related url is not right. BAsically the location of my file is at Documents/Folder1/Folder2/Folder3/Folder4/Folder5/Doc.xls. I have tried the option of…
-
Domo Governance Connector is Broken for Pages and Cards
It looks like the Pages and Cards dataset (Domo Governance Connector) is broken. I was wondering if anyone else is having a similar issue. I opened a ticket with Domo, and it has since been transferred to one of their 3rd party connector partners. Still waiting to hear what the problem is. For us, it stopped working on…
-
Combining two header rows
I am receiving data in the format below. I would like to merge the two header rows into one where it would merge 'Date and Product Qty'.
-
Netsuite Saved Search not matching with Domo connector dataset
Netsuite Saved Searches work by applying filters and displaying result fields on a particular Netsuite object. In our case, transactions. The expectation when using Domo's Netsuite connector to import a saved search using a saved search ID is that the number of records would match. Has anyone experienced the number of…
-
Microsoft SharePoint Online Rest Connector - Download all files in a folder
I've gotten the Microsoft SharePoint Online Rest Connector connected in our Domo instance and have been succesful pulling in individual file contents using the "Download Item Contents" report option. However, we have a sharepoint folder where users will drop multiple files, and I need to bring the contents of all of these…
-
Modifying and running a data set set-up by a former employee
Hi everyone- I was trying to edit (and change the auto-run schedule) a data set built via the Salesforce connector that was set-up by a former employee. I had to login with a separate account (into the Salesforce API Connector via DOMO) and I had the "admin" user make themselves the co-owner and remove a few fields on the…
-
Google Ads Data Discrepancy Between API Reports
There are several reports you can bring into Domo through the API scripting to Google Sheets then have the Google Sheets Connector pull in the data. I have set up this process in our instance and it has been working perfectly for several months. The trouble I find is between reports such as Geo Performance, Ad Performance,…
-
Facebook Ad connector Generic Admin Account Login
To connect Domo to Facebook or Facebook Ad, one has to have Admin access to a personal Facebook login. We have tried to create generic Admin Users, but with no luck. Facebooks seems to be thorough about eliminating any account that is not tied to an individual. Has anyone figured away to use a generic admin to bring the…
-
Automate Export and email
Hi, I am trying to automate the process below: 1 - Schedule export with CSV from Card from DOMO 2 - Receive CSV via email 3 - Automatically send the CSV to a virtual inbox which will upload my CRM (Hubspot) My issue is at step 3 as Gmail does not allow me to set up an automatic forward to a virtual inbox, need validation…
-
Anyone Using Call Tracking Metrics (CTM / CallTrackingMetrics) Data Connector?
Good day everyone, I am having some trouble using the CallTrackingMetrics Data Connector provided by Domo. The connect was easy to setup, it accepted my credentials, and successfully moves data - all of which is great. However there are literally no filters or controls for the incoming data. This creates a scenario where I…
-
Sharepoint REST - Application Permissions
Hello Dojo, I am trying to find a succinct list of the permissions required to setup the Sharepoint Rest Connector within the Azure Portal. This article has an overview of the setup process, but after following the directions, I am not able to use the connector with the Client ID and Secret, receiving the error, "{App…
-
Can't pull in JSON from S3 connector
I'm trying to pull in a few json files from the S3 connector and one of the files throws up this error: Failed parsing JSON source: JsonReader at line 1 column 24976613 to Json The other two json files ran successfully and are very similar to the one that isn't pulling. I'm unsure on how to troubleshoot this.
-
Federated data solution - example
Hi Team, Please help me understand the Federated data feature available in domo, I did go through the article https://knowledge.domo.com/Administer/Other_Administrative_Tools/Using_the_Federated_Data_Solution. But, I would like to know the difference how it is useful to me when compared to workbench, currently I use domo…