-
Any way to delete data automatically after a certain time?
So I'm updating a dataset of mine through a connector on a daily basis, and I foresee that after some time the dataset will be huge (having millions of rows!) I want to delete rows from this dataset that I don't need anymore. The criteria for this can be multiple e.g: Delete rows with dates before a certain time. OR Delete…
-
Any connector which tells how many rows were updated through connector?
I have a dataset which is importing data through a connector on a daily basis. I need to monitor how many rows are being updated daily, just to see the load on my server. Right now I do this by going to the connector dataset, and going to the history tab. I read online that there is a Domo Stats connector, and I checked it…
-
connector needs Date/time in yyyyMMddTHH:mm:ss+0000 format
Hi all, I am building another connector which needs date formatted <yyyyMMddTHH:mm:ss+0000> The year as a 4-digit decimal number including century, followed by the month as a decimal number with a range of 01–12, followed by the day of the month as a decimal number with a range of 01–31, followed by a character T, followed…
-
Re: microsoft sharepoint data connector
I'm trying to use the "Microsoft Sharepoint Account" connector to attach to an .XLSX file on our SharePoint site. The user credentials for the connector has read+write access to the site/file in question. However, the DOMO connect will not connect and I'm given a very generic error "Domo is ready, but the associated…
-
deactivation of dataset
i received an error from DOMO saying that the connector has been deacticvated . wanted to know the reason behind it. also in past 30 days the dataset hasnt been able to update automatically and i am getting an error saying that request timed out. what is to be done in such cases ?
-
SharePoint Online Writeback connector issues
Just writing to see if anyone else has attempted to use the SharePoint Online WriteBack connector and run into the same problem below - we've currently seen the same issue in 2 separate Domo/SharePoint instances. After following the steps in the documentation (plus a few extra steps as the documentation is a little thin at…
-
Email connector unable to receive more than 1 email at a time. Any workarounds?
So as it turns out the email Connector, great as it is, has a key flaw, if two emails arrive at close to the same time one of them will not be imported. Silly as this sounds, the following error comes up " The import has been cancelled because a new request has been submitted." I originally noticed the issue when I created…
-
Get Current Date/time
I am trying to build a connector which needs the call to include the date and time in the header.. Date / Time (x-mc-date) The x-mc-date header must be created in the following format: Tue, 24 Nov 2015 12:50:11 GMT Any ideas how I can get the current date and time and then also in this format? Thanks
-
Google Analytics issue
I have been using Google Analytics for course builder app tracking some time now and just noticed that all of my data from yesterday is coming out empty. When I check our Google Analytics account for my apps viewed yesterday I can see App Name and User ID in my custom report but when I look at the Domo dataset (which has…
-
Facebook Ads Advanced | 3-second video view
Hi there! I'm wanting to show Facebook video views by DMA. In looking directly inside Facebook business manager, Facebook reporting only breaks out video view by DMA for 3-second video views. When I go into the Facebook Ads Advanced connector, setup a custom report, the only video views I can see are for 10, 15, 30…
-
MagicParseJSON skip header
I have managed to authenticate an API and am getting JSON data however due to the fact that it has a header, magicparse puts all the data onto one long row. Is there a way to skip the overarching title below of "data": because the first column I want is Volume…
-
Domo Governance
We have recently switched from using DomoStats to the Domo Governance datasets and noticed the column "Role" in the Domo Governance datasets does not include anything in it if a user has a custom role.
-
Google Analytics session data showing improperly
I have a card to show how many sessions one of our company sites had the previous month. In Google Analytics I see it has approximately 2,000 sessions on Feb. 1st, but in Domo it has 6,000 sessions for the same day. I've double checked my card and I've filtered it to show the same web domain, beyond that I'm not sure which…
-
Issue with datagrid.magicParseJSON() for custom connector
I am currently not able to export data from a custom connector when using datagrid.magicParseJSON(my_data). I always end up getting redirected to an error page: https://api.domo.com/Error%20adding%20data%20to%20stream%20664.%20ApiData%20response%20400 It appears to be related to the fact that I have multiple nested arrays…
-
Issue with exporting data from custom connector
When attempting to export the data from a custom connector via the data process section and checking the box "Create/Update Dataset" I am able to do so up until my second loop. I successfully export data to Domo when I don't include the second for loop in the datagrid build below and am not sure why that is the case. When…
-
Salesforce Community Users
Lots of background setting up domo with salesforce. - New opportunity to where a client wants to use a salesforce community. Any gotchas to be aware of? Trying to undersand if we have additional steps to allow community users access to the same domo instance.
-
Change Data Type from Importing
Hi, I am having problem when uploading Excel data which contains a column of invoice number. It has leading zeros however every time when I import the data, this column will become number type. I did searched here and found exactly the same problem. So I would like to know it's been years later can we select data type for…
-
Uploading a Excel file stopped working
Process has been in place for about 18 months, getting a "cannot run" error due to restrictions on the number of times we can upload the data. However it worked two days ago and the actual upload process never even finishes and continue to get one hour refresh restriction error.
-
Governance Datasets
Is anyone aware of a Domo Governance / Domo Stats / Domo Metrics dataset that identifies whether a dataset has been certified? We are looking to start measuring the number of datasets that have been certified, and also cards that have been certified as well as part of our BI Team Governance KPIs. I've searched through…
-
Google Analytics Most Visited Pages
I'm using the Google Analytics connector and I'm trying to pull the list of most visited pages by title, but I can't seem to find the right "Report" to choose when building the dataset. In Google Analytics itself, this data is under Behavior - All Pages. However, I've chosen the Behavior report when building the dataset…
-
SurveyMonkey Responses irrelevant data
Hi, Has anybody had success in importing SurveyMonkey responses to DOMO? I have tried using all report choices but all I get is metadata and no luck with Survey Responses.
-
R Plugin Creating Dataset with correct datatypes
(Unsure if this is the right forum location) So I have a dataframe I've created in R. A few columns have been converted into num datatype, with values of 1, 2, and NA. When I create the dataset in Domo using the R Plugin, every single column is coming in as a string. My dates and nums have been turned into strings. The…
-
Adobe Analytics Metrics Multiplying When Summed
Hello, I am working with an Adobe Analytics Custom Report in attempt to show a total number for Purchases and Revenue by Tracking Code. I need a total number for a period of time that spans over the course of about 4 months. The metrics, when summed, are multiplying, which I realize could be an affect of the Date…
-
Google adwords via Big Query Service connector not pulling the data ( 0 rows)
I had followed all the steps mentioned in the below link Link: https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_Marketing/Google_Ads_via_Google_BigQuery_Service_Connector But no data is pulled into DOMO. I checked in the Google Adwords. The generated script…
-
ChannelAdvisor - Authorization Failed
I'm attempting to establish a connection to ChannelAdvisor. I've got my dev-key and password configured in Domo and it authenticates properly. I've even followed their documentation (https://developer.channeladvisor.com/authorization/soap-api-credentials-flow/rest-request-access-endpoint) to make sure the profile / account…
-
how to upload a csv of zip codes without casting them as numbers?
Hi folks, Just losing my mind here trying to upload a small csv file with zip codes. In excel, I have them cast as strings (since some zip codes start with 0). When I export to a csv, the csv has the zeros. When I import to DOMO, it takes the zeros away and zipcode 01760 becomes 1760. I've also tried putting quotes around…
-
Merge Key Location not Working
I am trying to add merge keys to my MySQL connector and it is just clocking forever. Sometimes I get the option to pick the keys but it is inconsistent. Most of the time is just says "Error Fetching Schema". What do I need to do to get this fixed? The merge operator is basically useless without specifiying the keys.
-
CSV Advanced - connection error - "Could not load known_hosts"
Hi, I'm trying to setup a CSV Advanced connector to pull in data from a client. The client has whitelisted the IP addresses per the documentation, provided a login ID/password, and provided the external URLs for the SFTP. I also have an exact file name I can choose the connector to look for. I'm able to get the CSV…
-
Salesforce - Taken Longer than Expected Error
I am trying to bring in a very large dataset into Domo from Salesforce using the connector with upsert. I keep getting the following error: The data import has taken longer than expected and has been cancelled. No data has been imported. The dataset is on the larger side, but I have trimmed it down to just this year…
-
'%' symbols not populating on the usage of CSV Connector
I have a couple of colums in a CSV which has % symbols included in the value. But upon uploading the data, I do not see the % symbol rather the value gets changed. If my CSV has 30% then upon uploading it changes to 0.300 I do not want that to show up in my card. How do I avoid the same. Please help me.