-
Parse data with no String name
I am building a new connector and some of the JSON data has no string names i.e. {"user1":["PC1"],"user2":["PC4","PC5"],"user3":["PC1","PC2"]….. If I use magicparse I just get 2 (very long) rows, where I'm after a column of names and a column of where they are seen. is it possible to reference the data in another way such…
-
How to edit Data Assembler jobs
hello, How can I edit a data assembler job in domo? For example if I want to change the setting or create a new one?
-
MapBox - No Background
I'm in well over my head but here goes nothing… In my first attempt at using Bricks, I downloaded the MapBox Donut Cluster Bricks. I got it connected to my MapBox account and have a dataset with quantities for each Lat/Long value. However, there is no "backdrop" for the chart: It's working in that the donuts each have…
-
SQL Connector dataset set to 'Replace' but the data remains the same
I am using the preferred SQL Server connector and pulling in data. However I want to "restart" this dataset and wipe it out to 0 rows. I set the update method to Replace and modified my query to return 0 rows. I can see my preview returns no rows: However when I run this, the updated rows shows - and the total row count…
-
PayCom Connector?
Hi Domos, Does anyone have experience connecting PayCom (HR & Payroll software) to Domo? There is no canned Connector in the AppStore.
-
SQL Connector Returning No Rows
I'm sure this has been answered but I can't find it, so I'm hoping this is a simple answer. I have a SQL dataset that was returning rows but currently returns no rows. This is expected and should continue to switch between returning rows and returning no rows. The issue is that when it returns no rows the dataset in DOMO…
-
IDE Timeout changed to Inactivity Timeout
I send alot of time in the IDE creating numerous connectors and I often get kicked out whilst Im working. Its not inactivity as I can be in the middle of typing and get kicked out of the Developer platform, have to reenter my domain, enter my connector and 'most' of what I have just been typing is still there!! Can this…
-
when Building a connector I often get kicked out
I have spent a bit of time creating numerous connectors and I seem to often get kicked out. Its not inactivity as I can be in the middle of typing and get kicked out of the Developer platform, have to reenter my domain, enter my connector and 'most' of what I have just been typing is still there!! Any ideas? Is this a…
-
Amazon Vendor Central PO
Hi there, I am trying to pull Amazon purchase orders from Vendor Central. The current Vendor Central connector does not seem to be able to support that query. Has anyone found a good way to pull those? Thank you
-
Does Domo publish a list of new releases or version changes made to their APIs?
Does Domo publish a list of new releases or version changes made to their APIs? I am seeing a case where we are pulling from the data sources API but looks like the data type returned in the API call has changed, causing some things to break on our end. This is an API call to the endpoint: 'https://{our business domain…
-
Amazon Vendor Central POs
Hi there! I am trying get Amazon Purchase Orders from the Amazon Vendor Central, but I was not able to find a easy way to pull that data. Does anyone have a work around/way to get that data to Domo?
-
DomoStats 3rd-party connectors
Do you know when the Domo State 3rd party connectors are being deprecated? I'm trying to utilize the DomoStats connectors (new and old) and was wondering if I need to switch over to the new one sometime soon. Thanks!
-
New Data Setup From Account Page
I'm surprised this hasn't been mentioned yet. I didn't see anything when I searched for it. It would be nice to "Add Data" from the Accounts pane. Right click or even the existing options button open the modal appropriate for that Account. It's kind of a pain to have to search for a connector first and then select the…
-
Google Sheets Connector Issue?
Hi Team, I'm trying to get Google Sheets connected but receiving this error: I've verified that I can connect to Google Sheets by "Re-connect"ing on the Connectors menu. I cleared Cache/cookies/history, and this has worked in the past so I've never had this issue. Any ideas?
-
Connecting to Dataverse
Has anyone connected to a table in Microsoft's Dataverse? If so, how did you connect to the data?
-
DomoStats Datasets report - Add Cloud Provider
Hi team, Our DomoStats Datasets report doesn't currently include a field which shows the cloud platform a dataset is stored on (e.g. Domo, Snowflake, Redshift). Same with the Domo Governance Datasets connector. Raising this here because a customer is looking for this functionality, and I do think it would be a useful…
-
JSON Connector - File without extension
Hi everyone, I need to connect with a EndPoint that has an specific Id, domina,, viewId and apikey. I have tried out many Json connector without any luck Is there any specific connector that I can use considering the following parameters? EndPoint id domain viewId apiKey
-
How do I make a Domo to Power BI Connection with Microsoft Authentication or Okta SSO and not ROPC?
Using the connector on the left requires an ROPC verification type which asks for the users Password. Our security requires that we work through a redirect with SSO and a token is passed back so passwords are only entered in one area. I believe the MSAL connector on the right should fill that criteria but it is still…
-
PostgreSQL Connector vs Postgres Federated SSL Error
I have two accounts setup: the native PostgreSQL Connector the Federated PostgreSQL connector I can successfully query and retrieve data from the Federated PostgreSQL connector but when I put the same credentials into the native PostgreSQL Connector and try to run a custom query against it, I get the error: Error setting…
-
Export data from DOMO to Google Sheets on Schedule
Hello! I imported data from Snowflake using federated dataset to DOMO. Now I wish I can export this dataset to Google Sheets. I've tried Add-on, it partially works but it can't automatically run on schedule. I've also tried to use Magic ETL to writeback data but I can't get access to the API so it doesn't work. Can anybody…
-
Creating an HMAC and pushing data to a JSON Webhook connector with a secret applied
It can be a little confusing when trying to setup the JSON Webhook connector with a secret applied and push data successfully. The biggest hurdle can often be creating the HMAC to pass in through the header. Depending on the source that you're pushing from or what programming language you're using will change the setup…
-
Json No Code and Json No Code oAuth Connector - Add response details
These connectors both return errors that start with "Domo is ready but…" in the dataset history which provide very little detail into the error that actually occurred. I'm not sure but from examples I've seen it seems like this might be a generic set of messages based on the HTTP status returned. I appreciate that Domo…
-
Zoom Connector - Webinar Reporting Challenges
Many people in our organization frequently conduct Zoom Webinars as part of our business model. The most important KPIs for us are # Registered and # Attended. Perhaps I am approaching this wrong or this is an opportunity for enhancement of the connector, but we have the follow challenges: Webinar Participant Report - the…
-
Best Way to Fetch GT Metrix Stats for Multiple URLs?
Hey everyone, I’m trying to build a GT Metrix connector to pull performance stats for about 40 URLs. I figured out how to bring in data for one URL at a time, but setting up 40 individual connectors and merging the results doesn’t seem like the best approach. Is there a way to request reports for multiple URLs at once?…
-
Shopify Products and Product Variants report moving from REST API to GraphQL API
Note: this announcement pertains only to the Shopify Connector (com.domo.connector.shopify). At this time, the Shopify Custom App connector (com.domo.connector.shopifycustom) is not affected. Shopify has released a new GraphQL and is slowly phasing out its REST API. As a result, Domo is adding new reports to the Shopify…
-
SharePoint connection help
I am trying to connect my instance with sharepoint. however there are categories to choose from site , subsite and more. I only want to connect the account to a sub folder in my sharepoint to later download the files from. How can I achieve this in domo and magic etl.
-
Google Sheets - Metadata Import
As an analyst I'd like to import metadata about the Google Sheet as columns Metadata like: Google Sheet Name, Google Sheet Tab Name, and any other attributes that might be available In order to do automated data quality checks, and provide enhanced exploration on data sourced from Google Sheets
-
Create a concatenated field as part of SQL query and use it in Salesforce Adv connector merge key
I am working on setting up a Salesforce Advanced Connector, and use the query mode to select my data. In this selection, I created a custom field called merge key as below, CONCAT(CaseNumber, '_', LastModifiedDate) AS Merge_Key # also tried below, but same result CONCAT(CaseNumber, '_', FORMAT(LastModifiedDate, 'yyyy-MM-dd…
-
DataDog Dataset Join to Showcase Monitors and Events Together
Hello, I am trying to join the DataDog Events and DataDog Monitors datasets but I have not found any way to join them. I want to show every event that has occurred for each monitor over time with their severity. I have been looking at each of the respective datasets IDs and I could not find a primary/foreign key pair to…