ArborRose Coach

In Code Engine and Workflows, the account input type would be statically bound to the compiled execution. So the credentials would be to one account. I don't think you can dynamically switch at runtime. This isn’t a bug; it’s a security boundary in the Code Engine runtime. If there's a way, I'd love to see it.

Based on your comments, I would expect to leverage the Domo API. But I wouldn't expect the Python tile to handle anything like that. In Domo Magic ETL, the Python scripting tile must declare a static output schema. Domo enforces that so downstream tiles and datasets know the column structure ahead of time. Even if your…

It could be that the link briefly shows unfiltered data before applying filters, which would indicate a timing or permissions issue where Domo is fetching data before fully enforcing the permissions/filters for that user. If a user generating the link has broader dataset permission than other people, the initial data fetch…

Sorry, I included two 100's in there. Unencoded this would be CONCAT( '<a href="https://{yourinstance}.domo.com/page/0000000000?pfilters=[', '{"column":"Col1","dataType":"string","operand":"IN","values":["', `Col1`, '"]},', '{"column":"Col2","dataType":"string","operand":"IN","values":["', `Col2`, '"]},',…

I answered this is a different window. I believe this is a duplicate of the same question. Here's an example answering how to pass the variables with the UserID as a value of 100. CONCAT('<a href="https://{yourinstance}.domo.com/page/0000000000?pfilters='…

Somehow an issue on the forum lost the answer I posted. Re-summarizing in simple form. If you clear your browser cache and close all browser windows (so it closes any connected session), it will probably come back to you with fixed width or full screen as an option. Closing the browser will clear any open model dialog…

There's some trouble with duplications in the question posting. Re-answering this question. CONCAT('<a href="https://{yourinstance}.domo.com/page/0000000000?pfilters=' ,'%5B%7B%22column%22%3A%22group%22%2C%22dataType%22%3A%22string%22%2C%22operand%22%3A%22IN%22%2C%22values%22%3A%5B%22',`group`,'%22%5D%7D%2C'…

The preview only samples data. Such as the first thousand rows. The full ETL may hit limits or collisions the preview does not catch. New rows of data might contain a field that was previously clean and now has NULL or unexpected values. Check critical fields like dates, Ids, and numbers. Check case sensitivity (where…

A "Not Runnable" error in Magic ETL usually indicates that the ETL cannot execute due to issues with its structure, dependencies, or configuration. Here are common causes: Disconnected or Missing Inputs If a dataset used as input for the ETL is deleted, renamed, or inaccessible, the ETL cannot run. Invalid or Broken…

Sounds like a good plan. Here's a thought - what about something like Domo Workspaces (Python) reading from your server to create a dataset? Assuming Exchange / Outlook…. MSAL Token (MS Authentication Library) from msal import ConfidentialClientApplication # Azure App credentials CLIENT_ID = "YOUR_CLIENT_ID" TENANT_ID =…

There is a post in ideas, requesting this. https://community-forums.domo.com/main/discussion/63994/dataset-via-email-connector-enhancement-include-sender-as-system-level-column You could possibly try setting up a proxy email box. Instead of sending the file directly to Domo's email address, set up a dedicated internal…

Congratulations @Data_Devon!

https://developers.google.com/youtube/v3/determine_quota_cost I've never pulled from YouTube, but here's my guess. On the page link, it mentioned a default of 10,000 units per day. And the reports endpoint costing 10 units per call. And one unit request for things like videos, playlists, etc. It seems to suggest that to…

Based on review of multiple support sites, the following apparently are NetSuite supported. Function NetSuite Support Notes _1 ----------- ------------------ ------- ADD_MONTHS(date, integer) Yes Returns the date plus the specified number of months. LAST_DAY(date) Yes Returns the date of the last day of the month for the…

Try WHERE TH.TRANDATE >= TO_DATE('2024-01-01', 'YYYY-MM-DD') I don't think Netsuite knows the SQL version YEAR().

It sounds like the reason Domo can’t authenticate your Trade Desk account is due to the multi-factor authentication (MFA) you mention, which prevents standard username/password logins for API connections. The workaround is to use API credentials instead. Can Trade Desk provide a Client ID and Secret specifically for API…

This sounds like a feature request rather than a question. Is the following (below) a correct summation? If so, maybe a forum admin could move it to Feature Request: Improve Filtering and Visibility in Execution List Summary Currently, the Execution List in Domo does not allow filtering or searching by recipient (e.g.,…

Domo ETLs executions are trigger based, not condition. It won't trigger on a condition specifically. You would have to simulate a dataset change or something to get the flow to run. Such as having an ETL filter rows where INVOICE LIKE '%,%'. If not rows match the dataset won't change. If rows do match, the flow would…

Create a table card. Drag your category colum to the rows. Drag the category column again to the values and set aggregation to count. Category Count Text1 2 Text2 3 Text # 3 1

Besides the question Colemen asked, I'd also ask about that inner join you show on the first row. You are selecting columns previously and then inner joining. If the column you want is not in the selected columns of the other side, how would the inner join find it on both sides?

Yes, its possible. Time zones shift by hours, centralized on UTC (Universal Time). Depending upon the local time zone, you shift so many hours. In Dallas, I am 5 hours off UTC time…depending upon daylight savings. Meaning when it's 1 PM in Dallas, it is 6 PM UTC. DATE_ADD(`utc_datetime`, INTERVAL `user_offset_hours` HOUR)…

Let’s break this down : Initial row count: 32,168,003 Later row count: 32,190,212 Change: +22,209 rows Now review your alert rule in your post: Rule Any row has changes for column(s): 'Row Count, Tag' Row Count decreases by 1 Tag is equal to audit:frequency That’s a bit confusing, because the UI sometimes shows decreases…

Could your data types be affecting the alert? It looks like exponentials versus float may be affecting the logic.

Here's a break down of the way I was thinking. Apologies my docking unit just died and I have no monitors. I'm not used to using a laptop screen…lol.. AppointmentID,AppointmentDate,Provider,Metric 1,2024-06-15,Mitch,1 2,2024-07-20,Justin,1 3,2024-08-05,Kristin,1 4,2025-01-10,Kristin,1 5,2025-02-22,Kristin,1…

lol….Yeah, who's Brent? I don't see anything where you designate the % split across time. One way you could do this is to organize something to show the date duration and split %, maybe something like: Provider Galley Split % Start Date End Date Mitch John 100% 1900-01-01 9999-12-31 Justin John 100% 1900-01-01 9999-12-31…

Via Domo Governance Datasets you can find information about cards, pages, datasets, flows. However, governance metadata is more aligned toward dashboards/pages, datasets, and access, rather than specifically marking app to card linkage.

Thanks for the response Grant. In light of pydomo not supporting upsert - I rewrote my code to extract the existing data, combine it with new extracted data from the API, then remove duplicates and replace the data back to Domo. Due to the duration of Python run and credits consumed, I moved my testing to Visual Studio…

Lol…no. I can't stand using CLI and Jar files. I'd almost rather shoot myself in the toe and watch myself bleed out. Is that the only way to put a primary key on a dataset?

Yeah, that sounds buggy. Have you tried to create just a one or two entries using add columns? And then go back over and edit all?

I agree with Grant based on my experience with the Domo No Code Connector. This issue probably stems from changes on the Domo side—unless your IT team recently updated your network or proxy settings. Vendors usually don’t change their APIs often, but if the endpoint recently updated its authentication, request headers, or…