brycec Contributor

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.

Do you have a sandbox instance? Adding a DataSet to a sandbox instance requires it to have PDP rules enabled, even if you just set it up to give all rows access to anyone with DataSet access. Otherwise, you could just go to the PDP tab of the DataSet and turn off the PDP if you don't want it.

You can use the DomoStats People report as a DataSet to get a user's last login timestamp. Then, you can use the built in Code Engine function DOMO Users > deleteUser.

You can use the Utility > Add formula tile to achieve this. Put it just before your append tile on the line coming from your new data. Name the column, something like snapshot date, then put the formula as CURRENT_DATE().

Which API are you using and how are you authenticating? You should be able to use the Product API endpoint for Code Engine and use the X_DOMO_DEVELOPER header to authenticate with an access token.

I'm not aware of any limits on that API, but it certainly could have some. More likely, Postman is unable to handle that large of a response, and that is why it crashes. I'd suggest trying some other API endpoints, like query in the same API you are using. Or you could use the Product API endpoints of export to S3, query,…

I believe you are looking for the Card Permissions report on the DomoStats connector. DomoStats

CASE statements are exclusive, so once it finds an option that is true, it exits and doesn't evaluate other options. Not sure really how to explain it better, but I do have the solution. This is what variables are for! :) They are wonderful honestly. Create a variable that has your options of YTD and MTD, then create a…

@MrDeanoB Any chance you figured this out? I am looking to achieve the same thing and have had no luck so far.

If it is pulling the same date for every row, it sounds like you aren't grouping on the correct columns. What columns are you grouping on? You'll want to group in a way that identifies the unique row that you want the date aggregated for.

First thing I noticed, you don't want to have DAYOFMONTH in the check for Last Year, because comparing less than or equal to would mean you skip 05-2023 through 12-2023. Second, I would suggest splitting out your calculation into different formulas or even different tiles. So, I would first calculate your max date in a…

This should be achievable. What is your Beast Mode formula right now?

Are you saying your date is stored as a string/text column and not of date data type? If so, you'll need to use the function STR_TO_DATE() to convert the column to a date first, then you can use the other Beast Mode I sent.

You'll want to use the data repair feature. Add this exact string to the end of the URL of the DataSet: ?_f=dataRepair Then, you'll now have a new tab on the DataSet called Data Repair. Navigate to it. Now, you should have all the tools and options to do what you need. It'll let you delete updates, replace updates with a…

You can use Domo's undocumented public API for this. To authenticate to it, create an access token from these instructions: Use that token as the value for the header X-DOMO-Developer-Token when sending your API request. To find the right endpoint, required parameters, etc. just open up the network developer console in…