ellibot Contributor

@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:

@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: . You'll just need to change the URL of the iFrame in the HTML tab to the one Clickup provides.

@GrantSmith any creative workarounds for this?

@luoqianhe this video might also be helpful too:

@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:

@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.

@cgshinn3 you can accomplish more custom schedules using the streams API. Here's an example:

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: 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…

@ColinHaze Link should never change.

@Victoria_G1 have you tried adjusting the date formatting on the card level? I find this is easier compared to adjusting it in the ETL or beastmode.

@Joe_M if the end-user created the Client ID and Secret, Domo should enforce PDP and access based on their user. So if they only have access to a few datasets, they'll only be able to access those datasets via API. I would also recommend doing some testing with a fake user that has limited access.

@robdmitchell I don't believe Domo has created a new quickstart dashboard with the GA4 connector. The best thing I can think of doing is downloading one of the old GA3 dashboards, and then manually migrating the cards over to your GA4 datasets (very messy, but can give you a good starting point).

@CaitlynMaddox To my knowledge, I don't think it's possible to replace the internal values with their corresponding labels. Usually, I have to pull another report using the HubSpot connector that shows the corresponding labels. I'll then join that with the original report in a dataset view.

+1 to what @GrantSmith said, Domo doesn't expose this in the public Dataset API. It is possible to get the underlying query using one of the undocumented APIs. Documentation on those can be found here: . I'm guessing it would be a GET to https://{{domo_instance}}.domo.com/api/data/v3/datasources/:id

@patrickj I'd also recommend trying out Domo's Dataset Views feature: Definitely depends on your use case in terms of flattening tables before Domo or inside Domo. If you find your pgsql connectors are running very slowly, I'd recommend doing fewer joins in the connector itself and instead try dataset views.

@Jazeppi if you need a quickstart on DDX Bricks, I made a YouTube tutorial with example bricks that show how you can retrieve data using Domo's SQL API in the brick:

@pauljames I always liked this public example that Domo has:

@BSovers are you using the 'Salesforce Advanced' connector for this? Have you been able to accomplish this with Salesforce's own REST APIs? If so, I might recommend using the JSON No Code connector () to replicate the API calls.

VERY INTERESTED! @Mitch_Umbrellabi are you in the Slack community as well? I think lots of people would be interested in there as well. Here's a link if you want to join: