-
How to download an xlsx file from a URL
Has anyone ever managed to dowload an excel spreadsheet from a URL or even better achieved this with a parameter for the URL? I have a need to download a file daily that changes its name each day and the file has a url on a web site - easy enough in my browser to click and download, rename and use workbench but that…
-
New Facebook Error
After months of successful runs, I started getting an error message in Domo last week on some Facebook datasets. I've attached a screenshot. Does anyone understand what this error is why it's happening? Domo is ready, but Facebook no longer supports requesting Insights for Pages that you are not an administrator for. I am…
-
Creating Temp Tables in Azure data connector
I am playing around with the azure data connector and wondering if the ability exists to create temp tables when writing my query for the azure sql data warehouse connector? I have been succesful in doing it with workbench but would be awesome if the same functionality exists with the Azure connection. I am currently…
-
Alert for Dataset - who triggered it
I am using alerts to track row addition, row updates and row deletions in a dataset. Works really well and an example of my alert is below. It accurately triggers and show that for the person Nunya, plan month January the column CVCNT was changed from 60 to 55 and CVDollar was unchanged. The alert does not say who…
-
Unable to connect to new relic connector nrql
I have used the correct combination of query key and insights api but still showing the error invalid credentials. Can you please help and rectify this issue
-
Campaign Manager update but don't load data
Hi, I have a couple of Campaign manager connectors and since March 25th, they update normally on the schedule like they use to do, but not data is loaded. I checked on campaign manager, and everything is ok. Does anyone know what is wrong? Thanks,
-
Marketo Connector API Data
Hi All, I have connected the Marketo Dashboard, but I'm unable to validate the data against the Email Performance Report in Marketo. On their community page I found a post that says: Marketo Support says DOMO is taking raw data logs from API connection while Marketo's algorithm is doing the following: * Reporting unique…
-
How to retrieve data from github
Hello, I've unsuccessfully attempted to use the Github connector to retrieve a file from Github, using all the relevant options in the dropdown when selecting a report. At best, I produce a dataset that seems to have relevant data about the repository but that is all. Any domo users able to provide clarity here? Thank you!
-
How retrieve data from Firebase
Hello, I try to retrieve data from Firebase without any success, the DOMO connector run without any error bu I get 0 data. Regarding the API AUTHENTICATION KEY, I had one key but Firebase indicates this warning "Database secrets are currently deprecated and use a legacy Firebase token generator. Update your source code…
-
APPEND and REPLACE
Hi, How dataset APPEND, REPLACE and ETL(Update Method only new rows) work internally? Does DOMO create a unique key internally and only update the modified or newly entered records from source? Suppose, we have some trillions of data in SFMC(salesforce marketing cloud). First, I will create a app cloud connector to SFMC.…
-
Domo Azure Data Lake Connector Questions?
Hi All, I'm planning on using Azure Data Lake Store Conenctor to build out my Domo data warehouse & I wanted to know if the following data file formats are supported in Domo? * Parquet * Avro * ORC * ADLS Table I looked at the connector documentation & I couldn't find a clear solution. I need a live connector within Domo…
-
Import JSON from URL
I have a RESTful endpoint that returns JSON data. What's the most eficient way to schedule importing that data daily? All of the JSON connectors I see require credentials. The endpoint i'm accessing doesn't require user credentials.
-
How to specify header row with Amazon S3
Hi, I have a CSV file in Amazon S3. The header should start on row 216 and data on row 217. I can't see any way to specify it like we can do it in the BOX Advanced connector. Is there a way to do it directly with the Amazon S3 connector or any other solution? Thanks,
-
Locate a SQL Connector Dataset based on Query Alone
Hello, We are working with a server with some resource limitations and sometimes SQL Connector queries hitting the database at the wrong time will block other processes from running. All the database managers can give me when they ask me to identify which Domo SQL Connector dataset caused the problem is an ip address, the…
-
Automating Doc Card Imports
Good Morning Random use case here. I'm trying to find a way to pull out embedded data from an email, store that data into a PDF, and then import that data as various doc cards into a Domo instance. It is not google forms I'm talking about here, but think of it like that. You do form in Google Forms right now Google forms…
-
I want to upload a CSV String to domo in which a column contains a ","
Hi, I want to upload a CSV String to domo in which a column contains a ","... eg i have a string "abc,xyz" and i want to upload this CSV into a single column. but when i try to upload DOMO considers the "," in the string and try to upload into 2 coulmns. How do i upload CSV string containing "," ie "abc,xyz" into a single…
-
Anyone using Google Ad Manager Connector?
I'm able to pull data using the All Networks report but am getting 0 rows of data for anything else. I've tried specifying an order name/number and left this info blank in hopes of pulling a larger sample. Neither yielded an error or any data. Any tips for working with this connector?
-
Want a dataset that allows individual row writes. Does such a thing exist?
I have a job that runs on one of my services and this writes data to S3 around 10k times per day. It is pretty bursty in traffic. I used to use an S3 connector to get this data into Domo but those broke after months of working just fine and support has been really slow to work with (each question to them takes around 1…
-
Scheduler Not Working Properly
I have been experiencing two issues. First, the scheduler doesn't allow me to input double 0s such as 2:00am UTC, it displays as 2:0_AM UTC. I thought it might be my browser, so I tried different ones and the issue is still happening. Second, once I enter in a time (8:30AM UTC), it will automatically switch to a completely…
-
YouTube Connectors Broken
Google decided to change their API and permissions on March 5th causing the existing Domo connectors to fail. The Youtube Reporting Connector was working correctly and I've re-connected the account without any issues however when attempting to pull data via this connection it's returning an error message "Domo is ready,…
-
YouTube Enterprise Advanced - Basic User Activity
Does anyone know how to run the Basic User Activity API so that metrics are only populated for videos that were published on or BEFORE the filter date? I am trying to get the historic daily stats for each video and what happens is rows are populating with 0s for videos published AFTER the filtered dates. So, if I want to…
-
Connector provides data for multiple tables
I am creating a connector but the json I get back gives me data for multiple tables. I am currently parsing then magicparsing as the top level is called 'data' var jsonRes = JSON.parse(res); datagrid.magicParseJSON(jsonRes.data); { "data": [ { "key": "osTypes", "title": "OS", "values": [ { "count": 5098, "title":…
-
Are there any issues with the Bing Connector?
There are some known issues please see my reply below.
-
Changing owner for Account in Domo
I want to change the owner for an Amazon S3 Bucket License/Account. However, Domo does not allow me to do that (it allows me to change credentials but not owner). I do not want to create a new account/License. I am currently going to 'Account' in Datacenter, and seeing/trying-to-edit account owners over there.
-
Emailed Scheduled Reports Format Changed
Not even a few weeks ago I was able to set up individual cards as scheduled reports (table format) and all the columns would show up in the emailed report. Something has changed in the last few weeks. Only the first two columns now show up in the scheduled report in the email. Anyone know what is happeneing? Everyone on my…
-
Instagram Business IGTV Metrics
I am using the Instagram Business connector and am wondering if there are metrics for IGTV? Similar to YouTube, IGTV has a playlist called a Series and each Series has individual videos with media titles. I would like to be able to measure each Series vs individual posts. In Instagram, the Posts tab also lists IGTV posts…
-
HubSpot dataset request too large
When i try to run the HubSpot connector for 'All Deals' i am getting the following error message. It was running fine when we had 1261 rows of data but we are now at 1286 and the issue has arose. Is there a limitation on the number of deals that you can import using the connector ? Has anyone encountered this issue before…
-
Brightcove Server Error Unauthorized Request
We use the Brightcove connector to pull Analytics reporting. When I try to pull a Video by Player report using the same account ID, a Server Error, Unauthorized Request (see screenshot) is generated during the run. The list of video players in our account displays fully in Setup, but we just can run the connector without…
-
Power BI DATASET to DOMO
Hi Please can anyone advise on solution to migrate reports from Power BI to DOMO. Any help appreciated. How to videos or plain simple instructions. Kind regards - New DOMO user
-
File is not supported. Please use legacy connector.
I've been using the File Upload connector with several XLSX sheets for over 2 years. We update this data weekly and it has worked flawlessly. All of sudden this week whenever I go to upload a .xlsx file I'm getting a, "'File is not supported. Please use legacy connector." error. It does not matter if I save the file as a…