Best Of
Re: Microsoft Planner + Power Automate
Microsoft does have a Planner API (
You might be able to write a custom connector to pull in the planner data instead of having to write it to a SQL database and then import into Domo.
Re: Pivot Table - More control over subtotal rows
#LetsGo DOMO Team…..help out some frustrated users. Thanks!!
Re: Pivot Table - More control over subtotal rows
Completely agree! I have users downloading data from DOMO in order to pivot out in Excel, since the DOMO pivot card is unusable when only able to subtotal every row on a DOMO pivot card.
Re: Pivot Table - More control over subtotal rows
This is a pain point for us here at GE HealthCare as well. It would be great if this enhancement request can get some traction 😊
LAFligg
Re: Cleaning data off an appending dataset
Hello @user045907 is it possible to replace these datasets instead of appending?
Depending on the window you are looking to populate, and how you are using it, grabbing a window that is x days historical from today is an option in many connectors, but not all.
Which connectors are you using, do they provide a switch for append / replace?
Trigger a dataset update via python using a post call
I am currently successfully triggering a dataset update from Snowflake to Domo via python using the following code:
import requests
#list of dataset ids and stream ids for the Snowflake>Domo connections guids = { 'datasetID': 'StreamID', 'DatasetID2': 'StreamID2', }
#Does the work of kicking off updates for all Domo datasets linked to Snowflake
domo_token = 'xxxxx' headers = {'x-domo-developer-token': domo_token}
for i in guids: url = f'https://domain.domo.com/api/data/v1/streams/{guids[i]}/executions' r = requests.post(url, headers=headers)
The problem is that this is legacy code and so I'm trying to determine how the original developers set this up. I know the dataset ID is in the dataset URL, but I'm not sure how to get a streamID, or set up a stream if necessary that works by executing a snowflake query.
Does anyone know how to set something like the above up where you can trigger the execution of a dataset via the stream api?
For reference, I found some documentation from domo on streams but it's a little too bare to put into action.
