DomoDork Contributor

I agree with the idea that there needs to be a new JSON No Code (JWT) connector to supplement the standard connector and the OAuth connector. I'm actually running into this same requirement and making a custom connector or using Jupyter/python seems like overkill for something that is pretty standard from a JSON/API…

Hi @PMLeema - it's a private client system. But all they want is for us to send data to them via a webhook that requires the header "Authorization: <apikey>". But the JSON Writeback connector doesn't allow you to supply any custom headers so we get a permissions failure when we try to send them data.

Hi @damen, Since beast modes are realtime evaluations of data, lookups aren't really something a beast mode would support. Instead I would use a MagicETL to do your 'lookup' logic and output that 2nd mortgage amount as an additional column on your dataset.

I wonder if rows at the end of your range in excel has a bunch of blank rows. What happens if you open the xlxs file, go to the first empty row at the bottom of your data, highlight all rows below it and right click → delete rows, then re-save and re-import into Domo?

The way I approach this with workbench is to treat any data I bring into domo as a stage via replace instead of append. Then I use a recursive MagicETL with partition processing to take that data from stage and merge it into my final output dataset. @jaeW_at_Onyx has a good series of videos on this topic below. I hope this…

I 100% agree with this. If we could group tiles together along with colorize tiles, it would make complex ETLs much easier to work with. I would also extend the colorizing tiles idea such that when you colorize tiles and run a preview to see sample data from each tile it also colors the column headers. It would make it…

Hi @pauljames I have had this happen to me twice in the past. The first time it was because the value wasnt actually a NULL but instead a blank. The second time was when I was actually trying to filter out blanks (not NULLs) and there ended up being an invisible character in my blanks that caused the filter to misinterpret…

@ArborRose Absolutely. You can target individual datasets, change datatypes, remove columns, rename etc.

@ArborRose if you have access to the admin area, there is a schema manager in the governance toolkit to adjust the schema to your liking. We have to do that from time to time when using some connectors because Domo gets it wrong.

I've heard that this year there is no livestream but that a link will be sent out for viewing when the event finishes.

@ArborRose - I caught that and changed it right after posting. Still getting the same result. Looking at the network inspector what I seem to be getting back during the preview is an internal server 500 error from domo went it tries to execute the curl command. Starting to think I need to go back to the client and see if…

@ellibot yep, sure did :)

@ArborRose according to their python API sample, it should be "Authorization: Basic <base64 encoded id:secret> Looking at cURL documentation, this is the correct and expected way to specify basic authentication in a header: curl \ --header "Content-Type: application/json" \ --header "Authorization: Basic $AUTH" \ So in…

We had this limit in one of our datasets. The only way around it was to ask our CSM to increase the column size limit. They can do it on a case-by-case basis.

Agreed, this would simplify PDP automation so much and is very much needed.

@Jmoreno - I just did a quick test and I was able to pull in the incident data. Just use the JSON No Code Connector, setup a dummy JSON Account as part of the connector configuration (the URL itself doesn't seem to need any authentication but the connector requires an account to auth with), pop in the URL and it will pull…

Not sure about subscribing, but it looks like you could in theory use the No Code JSON connector to pull the incident data from into a dataset. From there maybe create an alert when new records are detected.

I thought about that, but we were really trying to avoid that kind of credit consumption. :)

Hi @TMonty0319, This should do the trick: DATE_FORMAT(STR_TO_DATE(TRIM(SUBSTRING(<your date field>,INSTR(<your date field>,',')+1)), '%d %b %Y %H:%i %p'),'%Y-%m-%d %H:%i:%s') This finds the first occurrence of the comma in your string and removes the day abbreviation since you dont really need that (since the day month and…

I would also add that when we used Inline Editing, if you hide columns as part of the editor configuration, it physically deletes the columns from the backend dataset when I don't think it should. It causes a rewrite of the entire table schema and ruins the upsert keys defined on the datasets tied to the editor.

I believe this is now in beta and part of the January 2024 release drop.

I would add that there should be some way to make annotations private. That way if I open a chart, my annotations show up, but if someone else in the organization opens the same visual, they only see their annotations unless otherwise specified. Maybe some sort of setting the owner of a card can set to make the private,…

Ok, it's been a long day. I didn't realize I was replying to an old post of mine. BAHHAHAHA. Still, point stands :)

10,000% agreed. This should be completely standard and baked in if Domo wants to be a very serious player in the BI space. I envision something similar to the watchdog feature where you just tick off various PII related rules (or specify your own via regex). Then incorporate checking against the rules as part of either the…

@ArborRose With the way this particular API is setup, it requires all 4 to be passed in as parameters to get any data back. I thought about doing multiple JSON connectors, but I'd still run into the same issue. What I realized right after I submitted this idea is I could just create 2 standard parameters for fromMonth and…

@cmarino I did this a different way. I barrowed a trick that I used to use in excel for the same purpose. Try this: sec_to_time(sum(duration_seconds) / 86400)

@ColinHaze You need to use domo.navigate() for this to work as DDX bricks are still considered Apps. For example: <li><a href="#" onclick="javascript:domo.navigate('/page/402244837', true)";>Return Home</a></li> This is per the developer documentation for Apps:

I really need this. It's so hard to validate data without being able to control what records come through in a preview. I also really think a sort tile would be super useful. I realize you can do this with the Rank and Window tile, but dropping in a sort tile would be much simpler.

This is so needed. Especially for Admins. It gets difficult to sort through objects and validate that sharing/groups/PDP are all assigned properly. Having this feature would give admin the ability to visually inspect and check to make sure a given user sees only what they are supposed to see.

Hey Grant, The source datasets are federated Dremio datasets so we're not actually copying data and federated datasets arent supported with virtual datasets. We don't want to copy data at all (since thats live data) and views seem to add alot of overhead on top of federated datasets. So we're just trying to figure out a…