-
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?
-
Update all attributes(department, title..etc) of User API
With the dynamic groups being able to pick the users automatically through user attributes, it is very convenient if we can automatically change the values of user attributes, example, department. set department through API→ pick that department and set to dynamic group, with such dep name,, I badly need this now actually..
-
AppDB API Bulk Document Request - Size and Rate Limits
What are the constraints around usage of the bulk document create/upsert/delete requests in the AppDB API? I've run into a handful of errors with these endpoints that appear to not occur when I shrink the request body or querystring length below some magical threshold. Knowing the size or rate limits for these API…
-
data/v1 endpoint - Filter on columns and values with spaces in their names
Is it possible to filter results on the data/v1 endpoint with columns or values that have spaces in their names? I've tried every combination imaginable to get results for a column named Spend Category, but continuously get this 400 error. Filtering results with columns and values that don't have spaces works as expected.…
-
Action Type Query Parameter
Currently working the audit API and noticed that I cannot add actionType as a query parameter. I would like this feature to be added so I am able to pre filter the data prior to download. Thanks!
-
How to retrieve e-mail campaign information via API
Hey all, I have been trying to get information about e-mail campaigns running on my organization's Domo instance. I have been able to find the information needed through a GET request at the following endpoint: https://campaigns-prod.domolabs.io/api/v1/email/campaigns/ However, I struggle to authenticate correctly. I tried…
-
Indicate in the UI when a dataset ID is being used in an API or writeback EXPORT
Simple idea with a profound impact. Indicate in the datacenter/dataset UI that a specific dataset is being used in an API or writeback EXPORT