-
rdomo package - dictate schema
I recently encountered a parsing error when creating a dataset using rdomo, where a text field was being interpreted as a date field. Misinterpreting datatypes when pushing to Domo or retrieving from Domo happens, but this was the first time where I couldn't find a solution. Through support, we were able to create a…
-
R - Domo API SDK (rdomo) - Working??
Hi, My colleagues and I, from various departments including Research and Accounting, were surprised when the Domo API stopped responding last Tuesday. Initially, we suspected it might be an issue with our IT Department, but they promptly confirmed that they hadn't blocked any API calls and had checked their firewall…
-
Color rules in Domo Phoenix
Hi all, I am using the DDX Phoenix Scatter Plots App and wanted to apply some color rules like you do in a regular card in Analyzer. I was looking at the documentation but it is only shown how to change the color palette, not how to apply color rules (ex: if Metric < 1 then red else green). Do you have any suggestion?…
-
API Log in DomoStats
We want to do an audit of datasets accessed via API calls, as well as the clients using those calls, and I was amazed that this isn't logged as part of DomoStats (or the deprecated (?) Domo Governance datasets). I am recommending that this be added either through DomoStats or some other mechanism.
-
Workato - Pulling data into Domo
Has anyone successfully connected to Workato and pulled in admin report and data for system monitoring? Looking to connect from Domo into Workato. Assuming this is thru a Json connector, but need guidance and code if you have an example to work from.
-
Amazon Product Reviews API
-
PyDomo - DS_Update to Append Data?
Hello all, I've written a script that ideally will create a datastream into Domo. At the moment though, I'm struggling to find a way to replace the update method of ds_update() from PyDomo. The default appears to be replacing the data, but I need to append the dataset. Does anyone have any experience with this? Any help…
-
JSON Dynamic Body
I'm liking the JSON Low Code OAuth connector, especially the dynamic parameters and looping option. Problem is, we need to post a body with dynamic values. Seem like the dynamic parameter capability could be extended to do token replacement in the body content as well.
-
Integrating with BlueCherry ERP
Hello Domo Community,I am reaching out to see if any fellow Domo users have experience integrating with CGS's BlueCherry platform. Specifically, I'm interested in understanding: Successful Integration Stories: Have you successfully integrated Domo with BlueCherry? If so, could you share how you approached the integration?…
-
Google Analytics 4 Preferred Connector Error 401
I'm currently attempting to pull data for a GA4 account into Domo using the preferred Google Analytics 4 connector. I've selected all of the dimensions and metrics that I would need, but when I attempt to run the dataset it will attempt to pull the data in for around an hour and then return '401 : Unauthorized : Error…
-
Append a Dataset using Domo API
We are trying to append data to a dataset using the "Import data into DataSet" DataSet API Platform(OAuthAPI) documentation. https://developer.domo.com/portal/4ba1c85b30ae1-import-data-into-data-set When we use end point "https://api.domo.com/v1/datasets/{dataset_id}/data?updateMethod=APPEND", it replaces the data in the…
-
Google Ads Connector isn't pulling in Product Feed Demand Gen Campaigns
I have multiple Google Ads Connectors setup to pull in at both an 'Ad Group' and a 'Campaign' level for pulling in PMAX as well as normal campaigns. I'm getting all of the campaigns that I need aside from one single campaign. We are also storing this data in Looker Studio with a 3rd party connector tool and it isn't…
-
How to Setup UKG Connector?
Hello, We are trying to use the UKG connector, but it is not clear what all the fields are. Username: I assume this is a service account name? Password: I assume this is the service account password? Client Access Key: Not sure where to find this. User Access Key: Is this generated by the user account in UKG? Service Host…
-
It is possible to call the Domo powerpoint plugin with the API ?
Hi ! I’m looking to run the DOMO powerpoint plugin using a script. Is there a way to do this? An API call to the DOMo plugin? Basically, the script will need to update the powerpoint based on user-defined filters in a third-party application. Is that even possible?
-
Create a JSON API with Domo
Has anyone had any success in using Domo to build an API for external system to connect to receive structured JSON data? The JSON writeback connector KIND OF handles the PUSH component, but it is severely limited by its 100 row output limitation. And for GET requests, it seems the Domo API outputs data in its own format…
-
NetSuite Connector
Due to privacy I cannot share any records, nor can I simulate it. This is going to take familiarity with the NetSuite connectors to answer. This connector does not work like other APIs. We have tried two of the NetSuite connectors recommended to us by Domo. When we validate the information we find a couple records missing…
-
Domo API to import files to domo
domo = Domo(client_id, client_secret,api_host=api_host) I want to add an additional argument here that is updatemethod=Append. I am not sure what the correct syntax for this would be. For extra context, I am currently reading files into python and essentially once I read these files in, I want to combine them and then…
-
More query params for ListDatasets
Endpoint: https://api.domo.com/v1/datasets (GET) As a data engineer, I am trying to programmatically list multiple datasets using specific parameters. When I use the UI, I have multiple filters such as Last Run, Type, Owned by, etc. However, the datasets API only supports 'namelike.' It would be awesome if we can use the…
-
API Authentication Security Improvement
As per API authentication guide here - The first step to get access to Domo APIs is to generate ClientId/Secret and then make a request to get access token. This request is of type "Basic Auth" where client credentials (ClientId/Secret) are passed as base64 encoded string. Since these creds act like username/password…
-
Embedded cards using APIs with pfilters - graph by options
Hi Community, I have been embedding cards using the API with pfilters. This seems to be working well but some graphs are defaulting to graphing by day vs hour. I know I can adjust this within the card but wondered if anybody had any luck programmatically adjusting this. The documentation for APIs is a little lacklustre and…
-
Python Requests Library in Codeengine
Hello, I have started using the codeengine to create API calls to automate some of our tasks with systems outside of Domo. Python is my primary language and I have noticed that I have not been able to find documentation on making the calls with python. I know there is support for calls using JavaScript and I have been…
-
Having trouble running a workflow from a Domo Brick
There's a brick called Workflow Start Form that I'm basing my implementation on, primarily the function const startWorkflowWithParams = (alias, params) => { var startURL = '/domo/workflow/v1/models/' + alias + '/start'; domo.post(startURL, params).then(data => { console.log(data);…
-
Precision Loss With Dataset APIs
Hi folks, I'm hoping to get some pointers on getting precise decimal data while using the Dataset export API. I ran a request to retrieve data for a dataset on my domo instance using the API docs and was able to get my file downloaded onto my notebook. However I'm noticing that the decimal fields seem to only be returning…
-
API Tokens - Tracking Usage / Governance
From a security standpoint it'd be great to see when / where an API Token is being used. Alternatively give the activity log have a flag that a token was used vs a user logged in the system. When someone leaves there's no easy way to track which APIs are used and what needs to be changed.
-
API Authentication Access Token Expiration Time
After issuing a request for an access token, what measurement is the expires_in data expressed in? Minutes? Seconds? Example Response: { "access_token": "whatever", "customer": "acmecompany", "expires_in": 3599, "jti": "81dece4c-df73-4569-853c-2d1a328897fd", "role": "Admin", "scope": "data user", "token_type": "bearer",…
-
routing ETL failures through zapier
Is it possible to send ETL failure messages to Slack using Zapier or a similar service?