ellibot Domo Employee

@STEVE T you may be able to update the variable automatically using a workflow like so: https://www.youtube.com/watch?v=09p-vFuiwcQ

@Malvika_Chauhan09 a current workaround for this is to create your own Domostats report like so: https://youtu.be/HWGFwwL3gn8?si=XGkScFObC4AUOuHe

@Kunal @dnewc @EhubMcCoy @JasonAltenburg @BryantCafferty take a look at this tutorial video: https://www.youtube.com/watch?v=09p-vFuiwcQ

@manojshipwire @jimsteph it looks like you can get the query that powers the domo dataset by hitting this API: GET https://{{instance}}.domo.com/api/data/v1/streams/{{streamId}} The Stream Id for connectors can be found in the DomoStats Dataset History report.

@AO3 there should be a control button that you can add to the app in the top-right corner:

@froghunter for most Domo connectors, you are able to pull in 1 table from the source system per connector. So if there are 5 ServiceNow tables that you need to pull you, you would create 5 separate connectors for each table.

I've also used Portable's Workato connector since Domo doesn't currently have one: https://portable.io/connectors/workato

@Larry_Goodwin I have used the JSON No Code connector to pull Workato data from their admin. Their API docs are super helpful: https://docs.workato.com/oem/oem-api/api-platform.html. Authentication is super easy, just need to generate an API key.

@ColemenWilson There is a command in the Java CLI called 'restore-card' that lets you add a card to any page in Domo. You can probably script it to find new pages created and then add the card legal wants

@sebastian_galindo since this is a product API (not a public API), you will need to authenticate with either a session token or developer token. Here’s a tutorial video on how to do that: https://youtu.be/Qy0aXeJWSlI?si=IqSS8ywmyY8nnmDw

@sebastian_galindo take a look at this product API: https://documenter.getpostman.com/view/5049119/UyxbppB2#cd86f68d-fb2a-476b-a153-3e329e3d61c2

@akeating as a workaround, it looks like there is a product API you can hit that will return a list of your subscriber organizations: GET https://{{instanceName}}.domo.com/api/publish/v2/controlcenter/subscribers?limit=200&offset=0

@ColemenWilson it looks like the Activity Log API might provide information about proxy logins, so you could theoretically create your own DomoStats for this info: https://developer.domo.com/portal/i19jain6fvwjj-activity-log-api

@Mwatson do you know if Clickup can generate an iFrame for the form? I feel like most project management platforms have a shareable link for the form. If so, you can use the iFrame Domo Brick to embed it into a dashboard: https://www.domo.com/appstore/app/youtube-player-brick/overview. You'll just need to change the URL of…

@GrantSmith any creative workarounds for this?

@luoqianhe this video might also be helpful too: https://www.youtube.com/watch?v=IiemadZqSBE&t=9s

@DomoDork did you fill out this section where the client id is the username and secret is the password?

@trafalger

@hanmari try appending '?_f=dataRepair' to the end of the dataset URL (so it would look something like this: https://{{instance}}.domo.com/datasources/987da1fb-0b5e-493d-85a0-fe8b10136cf4/details/overview?_f=dataRepair). You can then download the dataset as a csv, clean it in Excel, and then reupload it using the 'Replace…

@augustas.g if you want to do some custom scripting, @jaeW_at_Onyx shows off a pretty neat solution in this video: https://www.youtube.com/watch?v=3ZwlzOlRBbA

@Joe_M are you opposed to the out-of-the-box poll feature Domo provides?

@MattTheGuru this sounds related to your question. You aren't able to access Campaign resources using the normal x-domo-developer-token, correct?

@FXM32 Do the list-dataflow -i <dataflow_id> -f <FILE> flags

@PedroM Interesting, did you also try 'x-domo-developer-token' as the header? Not sure if it is case sensitive. Did you also have 'Accept' and 'Content-Type' as application/json in the request? I find that this can sometimes cause the request to fail.

https://www.youtube.com/watch?v=kjVZ5-dR6LE

@cgshinn3 you can accomplish more custom schedules using the streams API. Here's an example: https://www.youtube.com/watch?v=0cTMM9xOuxw&t=8s

Hi @FXM32, I believe you can accomplish this using the Java CLI and "List-dataflow" command. This will get you a JSON export that should contain all the SQL statements contained within the dataflow.

@ColinHaze take a look at this tutorial video and the GitHub repo in the comments: https://www.youtube.com/watch?v=tE49eGXtPB0&t=99s You'll need to first use the Domo Data or SQL API to get the data from the dataset: domo.post(/sql/v1/${datasets[0]}, SQL QUERY HERE, {contentType: 'text/plain'}).then(handleResult);

@ColinHaze in order to sync data to the AppDB dataset, you can run: collectionService.runSync(); I have noticed that sometimes it will not sync every time you run this command, but it does store the data and add it during the next run. I've also heard that AppDB datasets are only supposed to update as often as 15 min, so…