brycec Contributor

Comments

  • Commenting to remove from unanswered
  • @cadellfalconer I do use governance toolkit, as well as the APIs. The toolkit is limited by the inability to edit a job, and that a new job must be created every time you want to create virtualized DataSets. It would be very nice if the toolkit could be an automation, much like how other toolkit jobs work. For example, I…
  • There isn't a way to add a field without it being a filter to smart text. You could add it as a filter, and select all, to add it. There also isn't a way to add smart text to an Excel export unfortunately. I like that feature idea, you should create a post in the ideas exchange to start getting the product team to look at…
  • You can go to your profile picture in the top right of Domo, then click the gear icon in the top right of that modal. Then go to the notifications tab and uncheck the SMS column (3rd column) for the line "A Card or Dashboard is shared with you". I assume that works with App Studio Apps too, but I haven't specifically tried…
  • What type of chart are you using? You have a property called balanced_distribution that isn't on the default bar chart and I cannot find what type of chart uses that property.
  • Have you tried removing the import statement? Code Engine is weird and it might just be built in and allow you to call that Domo function without the import statement. Otherwise, you can use the requests package instead the Python SDK.
  • One of the functions in the DOMO Notifications action should do what you want. You can find them by adding an action in a tile and searching for email.
  • You could instead use goals/objectives to achieve this, since they do have key results that track percent (or other measure) complete. Otherwise, you could pull the DomoStats reports for Projects and Tasks and display them in cards. You can collect the priority and estimation from workflow forms, an app, etc. and add that…
  • API documentation from Domo has been historically poor. You are using the OAuth API, which usually changes versions if there are significant changes. But, API development has also historically been disorganized and not well managed. There isn't a list of changes anywhere that I've found unfortunately. When these changes…
  • I assume this Domo connector doesn't do what you need, but I wanted to bring it up in case you hadn't seen it. I'm not familiar with the Amazon Vendor Central: Amazon Vendor Partner. Assuming the above doesn't work, there appears to be an API for the Amazon Vendor Central: Vendor Central URLs. You can then use the JSON…
  • You can use an alert on a card, so that you can add those conditions as filters on the card. Then, add an action to the alert that triggers a workflow. That workflow can then create a task in the task/queue center for the owner to fill out.
  • You'll want to use the append tile instead if the structure of the data is the same. Append will add rows to the bottom of the other DataSet, without increasing columns. Joins is for joining on keys and will increase the number of columns you have. If you still need join, you just have to use multiple join tiles one after…
  • I was playing around in the Product APIs and found that editing Virtual DataSet jobs is possible via the API, just not the UI. 1. Get the applications (different toolkits): GET https://<your_instance>.domo.com/api/executor/v1/applications 2. Use the application ID for the Virtual DataSets to get all the jobs: GET…
  • Some of my favorites from Gemini: Vance's Vanguard Thompson's Titans The Visionaries The Data Diopters The Insight Iris The Retinal Rockstars The Cornea Commanders The Focus Force The Data Sight Squad The Pixel Pupils The Analytic Acuity The Clear View Crew Vance's Visionary Diopters As someone who inherited a Domo…
  • Have you checked out the developer documentation? DOMO Developer | APIs They have recently started documenting their "Product APIs", which are extensive.
  • I played around with the API and tried to find a way to change the owner. As far as I can tell, it is not possible. The best thing you can do is probably just create a new one and replace everywhere the old one is used, as sucky as that is.
  • For that endpoint, I've always used the parameter includeAllDetails=true, instead of the parts that documentation mentions. However, that endpoint doesn't return columns or Beast Modes. For columns, use this endpoint: api/query/v1/datasources/<dataset_id>/schema/indexed?includeHidden=true. For Beast Modes, use this…
  • This might be helpful though. The R SDK has the file pdp_create.Rd: \name{pdp_create} \alias{pdp_create} \title{Create a new PDP policy} \usage{ pdp_create(ds, policy_def) } \arguments{ \item{ds}{Data set id from Domo.} \item{policy_def}{List object with parameters as given in documentation.} } \value{ List with all policy…
  • Probably won't be much help, since it is not the SDK and you already tried just adding "type", but here it is as cURL generated from my HTTP Postman request: curl --location 'https://<instance>.domo.com/api/query/v1/data-control/<datasetIid>/filter-groups' \ --data '{ "name": "Pod Owners", "dataSourceId": "<datasetIid>",…
  • Not that I can find anywhere unfortunately. Domo isn't great at documentation, especially with newer features.
  • Do you mean User Management in the Governance Toolkit? If so, passwords are not controlled by the configuration DataSet, so your existing users would keep their password. Additionally, there is an option when setting up the toolkit job to "send invite". If you check this, it will send new users an email inviting them to…
  • Using the Product API for AI Services Layer instead, I know the endpoint to list models for a certain use case (e.g., text-to-sql) is https://<your_instance>.domo.com/api/ai/v1/settings/services/sql/models. That being said, you may be able to use that same endpoint in the App Framework API you are using, likely…
  • Not exactly sure, because I ever use R. But the object keys are almost identical to using the Product API endpoint https://<your_instance>.domo.com/api/query/v1/data-control/<dataset_id>/filter-groups. For that, a "type" key is used with a value of "DYNAMIC" to achieve the result you are looking for. I'd trying adding and…
  • What you might be looking for is Page Drill functionality. If that isn't, you could explore hyperlinks instead of a literal drill, and then use pfilters. PS: despite that documentation for pfilters being about embedded content, they work on both dashboards and cards that are not embedded.
  • I had a similar problem in which I wanted to track vacation and sick time accrual for our employees. I needed to show the balance as a running total without it losing any history and becoming inaccurate due to date range filtering. The solution that worked in this case was to change my leave transaction DataSet from row =…
  • You want to use a FIXED function. SUM(MAX(`Facebook Spend By Day`) FIXED (BY `Date`))
  • If you are building a Domo app (pro-code or brick), then you will likely need to use one of Domo's SDKs and this authentication hack won't work. But, to use the X-DOMO-Developer-Token header, you simply add a header to your API request key: X-DOMO-Developer-Token, value: <your_access_token>. You can generate an access…
  • Weird. Might be a bug then. I would reach out to Domo Support.
  • I believe what you are looking for didn't exist, until the latest feature update at the end of January. It should now be built-in and possible. Current Release Notes - Workflows: Initialize Variables
  • I'm not sure how you would download files from Domo. But if you just mean get the data from an Excel or other file in that folder and put it in a DataSet, that is possible. We usually use the report "File Download" on the SharePoint connector in Domo, enter the exact Site ID, then putting in the file path to that folder.