-
window.addEventListener("message") does not trigger when card is clicked
Hi experts, I have successfully built and ran the sample. My card is loaded. Now I want to watch the event of card clicking and get out the selected data. With the help of Domo, the event of message will be just work when card is clicked, or filter is changed, but nothing happened. I also tried to change column&value of…
-
Domo dependency (domo-java-sdk-all) issue
When I defined compile group: 'com.domo', name: 'domo-java-sdk-all', version: '0.4.0' in the gradle dependecy, it fails to load. Seems because bintray-domo is disabled. Is there any alternative repository?
-
Getting Current User Profile Data
I'm currently working on a custom application that allows users to submit data. We would like to be able to capture a field from their Domo profile in order to apply PDP when showing the data that they have submitted. Is there a way that we can capture current user data from Domo when the user is viewing the card?
-
Api fails for filters
Hello folks, need help over domo programmatic filters. While calling api it's gives us a error https://public.domo.com/embed/pages/my embed ids /stack?parts=metadata,datasources,drillPathURNs,domoapp,slicers,dateInfo&includeV4PageLayouts=false But i have no idea for what case is happen error logged `{ "status": 404,…
-
use fields from different tables group by date to calculate percentage
Hi, I am trying to calculate a percentage using two fields from two different tables in SQL Magic Transformation. Table a looks like this: Date All Revenue 09/01/21 100 09/02/21 200 Table b looks like this: Date HDM Revenue 09/01/21 90 09/02/21 170 I need to build a table that would calculate the percentage of HDM Revenue,…
-
Connector for an API with self-signed certificate
I'm trying to build a custom connector to an API in our intra environment. This API uses a self-signed certificate. Currently in Dev Studio, I get an error when testing this API; the httpRequest object returns 500 and there is an error in the Dev Studio Javascript. I'm trying to narrow down the cause and was wondering if…
-
SAML Authentication in the Mobile App
I'm planning to do SSO with SAML, but I can't find a way to support SAML authentication in the Domo mobile app. I assume that the app probably doesn't support SSO, but has anyone else achieved this?
-
Pydomo creating dataset arguments
Hey guys, After my first question about creating dataset via API, i installed pydomo like people suggested. Now I have a question about pydomo. If I want to create a dataset with pydomo, what arguments can I use? I want to name columns and set datatype for each column. I saw the documentation on how to create a dataset but…
-
400 Error when trying to create a dataset with API on Python
Hey guys I'm trying to create a dataset with API on Python script but it's throwing a 400 error. Below is the code. json = { "name": "Dataset Name", "description": "Description", "rows": 0, "schema": { "columns": [ {"type": "STRING", "name": "Col1"}, {"type": "STRING", "name": "Col2"} ] } } response =…
-
Assembler Upsert Date Column
Hi. I need to get a snapshot of today's data in order to compare it with tomorrow's data once we have it. The existed dataflow uses the Replace method, so by just grabbing yesterday's numbers I won't be able to track the changes. So I created an Assembler that would grab the historical data and append today's data each…
-
Remotely trigger a DataSet refresh?
I'm checking out some of our options for speeding up data ingestion in Domo. A few of our Postgres pulls are taking longer than we would like, and I'm exploring creating a materialized view to cut the PG processing time down to 0, from Domo's perspective. That still leaves the data transfer time, and the Domo processing…
-
Test a custom connector to a private API in Connector Dev Studio?
I'm trying to build a custom connector to an API that is only accessible in our intra environment. I was wondering if it was even possible to test this connector in the Dev Studio as it may not be able to reach the API endpoint. Currently the error that I get is as follows: Whenever I try "Run Script" to test my…
-
Api Documentation showing only 3 user roles, 5 available in the Admin page?
Hello everybody! I'm following this page: And I can read that there are three roles: Admin, privileged, participant. In the role part, it says: The role of the user created (available roles are: 'Admin', 'Privileged', 'Participant') However, when I access the admin settings in my account, I can see two other roles that are…
-
Importing data from Spyder (locally) to DOMO
Hello, I have a Python script created on spyder which I need to import into DOMO. Just wondering how would I be able to do that. I saw the documentation on API and creating custom connectors but no luck. Thank you in advance.
-
Domo Custom APP - Domo Phoenix MEGA_TABLE Chart don't show total_row
Hi to all, I have a DCA that use Domo Phoenix to show the data (es: https://developer.domo.com/docs/dev-studio/step3) I'm using the MEGA_TABLE (select "Mega Table" from https://domoapps.github.io/domo-phoenix/#/domo-phoenix/properties) This is the charSetting of the chart: { "width": 1230, "height": 180, "backgroundColor":…
-
Can i connect AWS S3 with AWS credential by S3 connector?
I want to use the Domo S3 connector to access data in the S3 bucket. But I use SSO to sign in to the AWS, and it seems the connector can only accept access keys and secrets but not tokens. Is there a way to connect Domo to s3 in an SSO-enabled AWS account?
-
How to include include Pie chart inside Map Chart
I have created a Map chart that represents 'Number of Universities 'in each state in US. I would like to add a 'Pie' chart inside each state so that I could bring information on how many Private Vs Public universities each state contains. I want to make a chart something like below, With DOMO Map chart, however I could…
-
Notification of DataFlow and DataSet Processing Failures
I'd like Domo to notify our admin team's Google Chat or mailing list when a DataFlow and DataSet fails to process. I know that it can be configured in "Notifications" from the top right corner of each DataSet, but I don't think it is possible to notify any email address other than the owner. I have also not found a webhook…
-
Dataset Switching using vb.net
Does any one have experience with dataset switching using vb.Net to switch datasets on the fly? We are having issues getting the json string generated. Any help would be greatly appreciated!
-
External Chat with DOMO
Hi, People! Anyone already use a external chatbot with DOMO? Our idea is use a external application to ask simple questions like "What's my total sales in Jan/21 of product X?" and that application will log in DOMO, pull the data from dataset or card (is possible to return a card, too) and place the response to the user...…
-
Is there any way to get Embed Id programmatically?
I integrate with DOMO using java SDK and REST API, and I can get dashboard id or card id without any problems. But then I need to embed them on our site. But I see that the iframe for embed that will only use the dashboard/card id mark as deprecated, and now it is necessary to use the iframe with the Embed Id. Please tell…
-
Error in using Pydomo ds_get
Hi, I am trying to run this simple code to fetch data from a dataset on the domo instance. but i am getting the following error. AttributeError: 'Domo' object has no attribute 'ds_get' I am not sure what i am doing wrong. Can someone help with this. I am pretty new to python and API's from pydomo import Domo clid = 'XXXX'…
-
Data Stuck in "Storing" Mode
Hi All, Domo went down for a second earlier today when it came back up it appears that some of our datasets are stuck in storing mode. I was wondering if anybody had any experience troubleshooting this issue.
-
How to grab the last x days in MySQL Table
Hi. I have a very simple task of grabbing the data for the past 7 days. My current query looks like this: select * from `table` where `date` > CURDATE() -7 This works perfectly well, only when we get to the next month it is not grabbing any day from the previous month. I need to grab the data regardless of what month it…
-
API call after generating an auth_token fails with comment about 'Full authorization required'
This occurs in sandbox domain for "michael-dev-321536". I have checked curl construction several times. I figure I am doing something obvious wrong.
-
Stopping Emails from going out on User Creation.
Hello, As the title suggests, is there a way to stop emails from going out when a new user is created or when pages are added to a user through the admin tab? We enabled SSO so now we can't edit the email address once the user has been created. Not sure if this question has been asked before. Thank You.
-
Stock Open Opportunities by Active Account Executives in a period
Hi all!, I need some help here. I have a dataset of active employees in a specific date or period builded with a snapshot dataset day by day. I.e: By the other hand, I have a dataset of opportunities, with "Date Created" and "Closed Date". If an opportunity has a "Date Created" less than or equal to "active period" and…
-
pyDOMO Create users based on existing dataset
Hi, Im trying to automate our creation of users and assign role dynamically based on our existing dataset in DOMO. Im new to pyDOMO and currently following samples below: user_list = pd.read_csv('UserList.csv') def add_user_list(ul,domo_object,invite=False): ur = CreateUserRequest() users_created = [] for index, row in…
-
Documentation on Dataset REST API for query?
I am using the following REST API against a dataset. Is there documentation on the sql sent as content via the POST method? Anything at all? I don't know the extent of what I can put into that statement around building beyond simple WHERE clauses, GROUP BY, etc. I need to know if there are any advanced functions. POST…
-
Query with date condition in Python
Hello, I tried to extract data from domo with ds_query function. Would you be able to advise what sql should I use to filter data where date_column is greater than current date - 7 days? query = "SELECT * FROM table WHERE date_column >= getdate() - 7" df = domo.ds_query(dataset_id=dataset_id, query=query, return_data=True)…