-
Issue with MongoDB atlas Connector, it keeps throwing error "Time out"
Good day, We used the MongoDB atlas Connector to connect with the mongodb database, I already whitelist my public IP address(to get my IP public address I used ipchicken.com), but it keeps throwing error "Failed to authenticate. Verify the credentials and try again. Time out." Here are my configurations in mongoDB atlas:…
-
Issue with Data export from domo
I am using domo SDK and trying to export data from domo.Out of all rows i could see some of the rows are. not getting. properly.Domo stores data in csv format and some of columns is having comma in between the string. Is there a way to have strings enclosed with "" to avoid getting rows break. ex- name,address,company…
-
JSON Pagination with Response Header
I'm new to working with Domo and the data connectors, but I'm attempting to use the JSON No Code Connector to pull in data from an API. This connector has options for paging and to get the next page or URL from the results. However, this API returns the paging data in the headers. Are there any workarounds for this, or…
-
Append new dataset from a daily email using email connector
Hi all, I am trying to push a daily report coming out of our customer system to DOMO via email connector. This report shows a only a daily data from prior day. Is it possible to append the dataset so we have accumulating dataset in DOMO? If yes, can you share how? Thank you Juan
-
Automating Amazon sales data
Has anyone figured out an automated process for getting Amazon sales data into Domo? From my understanding there isn't an existing connector and an issue is that you have to log in to Amazon to download a report.
-
Value Map all columns at once
Is it possible within an ETL to value map all the NULL values in all the columns within one function. When joining datasets and keeping all the columns there end up being NULL values all over the place. This has been notorious for making Beast Modes fail. My fix for this is to add a bunch of value map functions at the end…
-
Can I build a query with a parameter that is editable on the dashboard?
I have a query: select * from function_get_data(date) I see there is a query parameter option, but how can I allow the user to modify this on the front end? Thanks!
-
Pushing Domo Data into Azure
I see the Azure connector that will allow me to pull data from Azure into Domo, but is there a way to do the opposite and push data from Domo into Azure? For example, if I use Domo to pull down data from Google Analytics, is there a way to then push that Google Analytics data from Domo into Azure?
-
Domo Workbench Schedule will not work
Hi I have a dataset job that I want to auto-update once a day. I can manualy execute it and it will work with no issues. Just for testing purposes I set the schedule to every 15min but nothing happens. "next run" date and time will pass with no attempt. I am on workbench 5 and I also tried using group schedule with same…
-
Bing Ads API v12
Microsoft recently contacted us that we are using a soon to be deprecated version of Bing Ads API. We use Bing connector version 2.115 on Domo. Are you using v12 of the Bing Ads API? After Feb 5 they will not support v12.
-
Data Set "Advanced Scheduling" - Not Understanding Where I'm Going Wrong
Hi all, I'm trying to get a Connector Data Set to run everyday at 4 AM (EST), 10 AM (EST), 4 PM (EST), and 10 PM (EST). I've attached a screenshot of how I currently have the "Advanced Scheduling" configured but it seems to not be working in the way I was expecting. Could anyone please advise? Thanks, Samir
-
Internal Server Error (HTTP 500) when utilizing DomoR Plugin
Have code that connects an API and domo using DomoR Plugin, which has stopped working. Getting the error message: Internal Server Error (HTTP 500). Am not seeing what could have caused this issue, have tried removing some columns. The issue is with the dataframe, as I can import a different dataframe using the same…
-
Asana Connector + Stories?
Has anyone been able to get the Asana connector to query the "Stories" table? This seems to be where their user audit data resides and while I can query other tables like the "Tasks" table this "Stories" one continues to return no information. Any suggestions? (Perhaps there's a work around connecting directly to their api…
-
YouTube Basic User Activity Date Inputs
For most Domo connectors, you have the choice of entering in relative dates (today-2) or a specific date (1/1/2020). For YouTube's Basic User Activity, it appears you can only enter in numbers of days ago. Does anyone have a solution for entering in static parameters? In my screenshot example, Videos Published After (Days…
-
Plans/workaround for an Amplitude connector?
It appears that Domo doesn't have an Amplitude connector. Any plans for this on the roadmap? For those using Amplitude, what workaround do you use to pull this into Domo?
-
JSON Pagination Issue
Hi all, I am attempting to connect a JSON data source via the JSON custom connector, and am having some trouble with the pagniation. The key for the next page is in the data, so I have selected "Get next page token from results," and then "Add as a parameter," which is how I get these results in other applications. When I…
-
how can I use salesforce with upsert to create a monthly historical data?
Hello Beautiful People - how can I use salesforce with upsert to create a monthly historical data? basically, we want to have a month end snapshot every month, while during the new month, data gets updated. Thanks!
-
How to append data to a table automatically?
Hi all, I have been allowed to query our main table only 1 day at a time to avoid tech issues (MariaDB). I am wondering how I could pull say previous day's data and then append to all the previous data pulled. Each row has a unique ID so this should be easy to avoid duplicates. The other question is - what would be the…
-
converting code from Postman to Domo
I have managed to write a connector for Akamai however now need to convert it into Domo i.e. change variable names eg. is there any guide or tool for this as ther eare some parts Im not sure about i.e. where its making requests withi Postman that are obviously not relevant wihin Domo.
-
Microsoft Sharepoint Online Connector missing?
Hi I'm trying to connect to a Sharepoint list, so am searching for the following connector: 'Microsoft Sharepoint Online Connector'. https://www.domo.com/appstore/connector/microsoft-sharepoint-online-connector/overview Unfortunately this option appears no where when I search in 'Connectors'. The two options for REST and…
-
SFTP or CSV Advanced Connector for .rar file
Hi, I have a file that I need to get via a SFTP so I try to use the CSV Advanced Connector. It's working well for a .csv or a .zip be how do I do If I have a .rar file? Thanks,
-
uploading xlsb file to DOMO
Hi All , I have files that are available on sharepoint (and i dont know how to connect sharepoint to DOMO) But the issue is that the file available on sharepoint is in xlsb format. So how can i upload this file to DOMO ? Any suggestion on this will be much helpful ! Thanks in advance !
-
google analytics segment / user level data
Hi - My Session and Pageview data is correct when comparing DOMO imports to GA numbers for All Users. When I split this data down by imported segments, the data is incorrect. The segments are user-level Segments. My user data has never been correct, but I have been able to work around with correct pageview/session data Is…
-
Granular Google Analytics Campaign / UTM data
Hi all, I am struggling to get really detailed data out of Google Analytics, I know I can export it from GA to say to CSV but is there a way in DOMO to get more details out than just main UTM_CAMPAIGN parameter. As per Google we can use: Campaign Source utm_source Required. Use utm_source to identify a search engine,…
-
PDP policies keep getting disabled
We utilize a child instance for our external partners and the dataset that powers their dashboard has PDP policies set up. However, PDP keeps getting disabled on its own - pretty much every night. Any ideas why this might be happening? I've checked the main instance to make sure that there were no policies in place on that…
-
Domo Governance Datasets Connector Beast Mode not stored on Drill Levels
Hello I have been working with our Governance Datasets to do clean up and review on our beast modes. I am finding that I cannot locate any beast modes on the drill levels of cards that are not saved to the dataset. I have reviewed the data in the 3 different datasets that contain beast mode data and I am not able to locate…
-
Loading data from SSAS Cube
Wondering if there is a workaround / tip&tricks on creating MDX query to fetch fields from a SSAS cube? I am no MDX expert and it seems like you ened to write a MDX query to get what you need instead of like a GUI (pivotable report) in excel.
-
DomoR Datatype Conversions
I'm using DomoR to fetch a dataset and a column that should be text is being read in as col_double(). Many values are only digits, but other values contain characters so must be read as a text field. Is there a way I can control for the incoming datatype so I don't lose those character fields? An example of the error…
-
Can't locate file One Drive
I am using the Microsoft OneDrive for Business connector. I'm able to authenticate. A file in my company was shared with me, and this file has existed for months. However, while I can access it as a user, I'm unable to access it through the connector. I've tried via name, path, and a number of other configurations. I get…
-
Merge Key Location for Google BigQuery Service Connector
I can not pick a Merge Key Location when scheduling the update mode for the Google BigQuery Service Connector. Can someone explain how to pick a key and how in general to set up the scheduling? And if i can not choose a key, how does the connector work? What will be compared to replace rows in my dataset? Btw, I am using…