-
Matching Snowflake Federated RowCounts to dataset views
Hi all, Can someone help me understand the Row Count of a Snowflake federated dataset, and when it updates? We have a table in snowflake that has recently been updated to include more rows. The Federated Connection dataset does not show the updated row count. However, dataset views built off of this dataset do show the…
-
Dayforce Connector
Hello, Curious if anyone has used the Dayforce Connector and what kind of credentials they needed to insert. For username and password, would that be the username and password of someone in the company with an admin level Dayforce account that they use when logging onto Dayforce?
-
Uploading daily reports csv in box
I am recieving daily reports via outlook Mail everyday. By creating a rule I uploaded the daily reports into a box folder. Say from 1st jan to 21 July today. A list of over 100+ files in the box folder. So basically I am using a box connector advance to upload my daily reports up onto domo. However when I set it to run, it…
-
OneCloud - DOMO REST API
I am trying to configure a connection between the application OneCloud and DOMO. OneCloud has a built in DOMO connector but the connection is still not working. It only asks for client ID and client secret. I have seen a ton of posts about a token but I can't figure out how to get one or if I need one. Any help would be…
-
Postgres SSH Connector - Data Types not importing as expected
I am currently using the Postgres SSH Connector to import datasets from our warehouse into Domo. When I try to import a boolean column it is imported into Domo as a string, and often the primary key field which is an integer in the warehouse is imported as a float. This kind of defeats part of the point of using a…
-
table for countries with codes and continent
Is there a data dimension or other dataset out there that provides a listing of: country - country code (2 letters) - country code (3 letters) - continent
-
Domo to Google Data Studio?
Hello! Has anyone created a personalized connector to connect Domo & Google Data Studio? Right now I am pulling Domo datasets into Google Sheets and then into GDS. I would love to take out the middleman, but am unsure how to improve this process. Any ideas? Thanks :)
-
Adobe Analytics JWT v2 Connector Multiple Segments
Hi, I'm wondering if there's any way to apply 2 (or more) segments to an Adobe Analytics report built through the JWT v2 connector. I realize a possible workaround is to just go and create a new segment in AA which combines the rules from the 2 or more segments, but this is not always feasible based on the number of…
-
Jira Cloud connector does not pull over custom multi-select values?
I am trying to pull in sprint data using the Jira Issue Report via the Domo Jira Cloud connector. I have one important custom field, Developer (it's really Dev Assigned) that is multiselect, but the data does not get populated in the pull (even though the field is listed, it shows up blank)> Is this a known issue with the…
-
How to convert Milliseconds into Date
I have a data set with timestamp represented in milliseconds and I want to convert it into date . Data sample: "1656076776827" Expected after conversion: "24 June 2022 09:19:36" I looked at the beastmode and could not find anything that would help me to convert it, any suggestions?
-
Has anyone pulled data from ActiveCampaign?
I am working on getting data from ActiveCampaign into Domo and wanted to see if anyone has succeeded in this.
-
A connector more reports every report put data in a different dataset
Hi to all, i wish to have a connector where every report make a call to a different endpoint of an API so i wish that every report write the data in a different dataset. I know how to build different report but I havent found the way to put the data of a report in a specific dataset and the data of another report in an…
-
Any way to pull in basic Quickbooks records? (Customers, Vendors, etc.)
I can't find a way, using either of the included Quickbooks Online connectors, to pull basic lists of records from Quickbooks -- e.g., my Customer list, my Vendor list, Sales Receipts, etc. All I see are reports, which are nice but don't necessarily include all the data I would need. For example, a G/L report doesn't…
-
NetSuite App TBA Connector
Are there other users of this connector? Just curious how was your experience and if you encountered any issues? Any tips? Already filed ticket with Domo, however we still keep getting this error; any body else experienced this? TIA. Domo has received your data, but there was an error in processing. This will automatically…
-
Snapshot Historical Data
I'm appending daily data for historical use. Because of the size I don't want store all of the history. I just want the last 8 days only and remove the other dates. How can I do this in ETL? I can filter for the last 8 days, but it still stores other dates data.
-
Schedules Reports- DomoStats
Is there anyway to be able to see in Domo Stats, reports scheduled by others? We're trying to see users who are inactive with no reports being sent or emailed. Problem is we can only see reports you've scheduled not what's being sent to a user.
-
Netsuite connector - Saved Search ID
I'm trying to pull data from Netsuite via Netsuite App TBA connector. However, I keep getting Domo is ready, but the details you entered are invalid. Verify the dataset details and try again. The only required field in Detail is Search ID. Which I follow the below instruction to use search ID in Netsuite Search table and…
-
How can I load multiple files from SharePoint to DOMO?
Hello, I'm new to DOMO and I just want to ask how can I connect or load multiple excel or txt files to DOMO from SharePoint? Thanks!
-
Google Ads Connector - Field Error.
Hi Guys, I am using Google Ads Connector. I am getting error when I try to add or change the segments. However, the connector seems to running well. Thanks, Tarun
-
DOMO Form
Can external user, without DOMO license, submit response to a DOMO form?
-
Can you use pagination with NO Code JSON Connector
I'm having issues configuring the NO Code JSON Connector's pagination. I've read some other thread saying it isn't possible, but why is it there in the connector as an option?
-
Google Analytics Append / Replace
Hi Just wondering if anyone had ever seen this before? We have the Google Analytics connector in Domo. We had an issue were data for a couple of days was not pulling from Google Analytics. We updated the Settings for the datafeed and tried to run the data again. The connector is set to Replace as opposed to Append. But it…
-
Microsoft D365 Finance and Operations Connection
Anyone managed to create a connection to the Online version of Microsoft D365 Finance and Operations? I would really appreciate any assistance offered in relation to the same.
-
Date_Add or Date_Sub Trying to minus a year
Hi Guys, I'm trying to minus a year from date field coming from Netsuite. This is what I have but it doesn't seem to be working? SELECT DATE_SUB(ENDING, INTERVAL 1 YEAR) 'Last Year' FROM ACCOUNTING_PERIODS Any suggestions would be great. Andrew
-
Amazon Athena Connector in Domo
Hello! I am attempting to create a new amazon athena connection with an ATS. This connection has been created before, with 50 varying data pulls, however, the previous owner of the connections is no longer with us. Does anyone have knowledge as to how to properly create a new amazon athena connection, essentially mimicking…
-
Reach
Hi DC, Has anyone ever successfully configured the Reach metric from Facebook in Domo? I mean to be able to pull through the correct unique reach value whether the granularity is total for month, total for ad campaign or reach per day? To date, no matter how much time we have put into this along with Domo, we have not been…
-
Json No Code Connector - Question.
Hello Everyone, I am using Json No Code Connector to pull the data in the Replace mode. I would like to only replace data which is changed at the backend and not the whole data. Is there a way we can do this in Connector settings ? Or any other way ? Thanks,
-
Snowflake key pair
I have two connections, one with the normal Snowflake connector and one with the Snowflake Key Pair. The normal Snowflake connector works fine but the Key pair connector is not returning any number values. The string fields are returning values, it's just the number fields that are null. They are different users, but the…
-
How to import sheet name or file name as a datapoint? (Dropbox advanced file connector)
Hi Team, My source data is in csv's where one of the datapoints is embedded in the file name and the worksheet name. Is there a way to import that datapoint into domo?
-
Unable to import JSON files from S3 connector
Hi Team We have an S3 bucket which stores some JSON data. When we are trying to import this to DOMO we are getting the following message Failed to sanitize XML document destined for handler class com.amazonaws.services.s3.model.transform.XmlResponsesSaxParser$ListBucketHandler We have checked the json format and all is…