-
Documentation on Dataset REST API for query?
I am using the following REST API against a dataset. Is there documentation on the sql sent as content via the POST method? Anything at all? I don't know the extent of what I can put into that statement around building beyond simple WHERE clauses, GROUP BY, etc. I need to know if there are any advanced functions. POST…
-
Query with date condition in Python
Hello, I tried to extract data from domo with ds_query function. Would you be able to advise what sql should I use to filter data where date_column is greater than current date - 7 days? query = "SELECT * FROM table WHERE date_column >= getdate() - 7" df = domo.ds_query(dataset_id=dataset_id, query=query, return_data=True)…
-
New role button missing
I want to create a new type of role in order to restrict all export of data or cards for certain users. However, when I go to the role management tab as an admin, there is no "new role" button? Am i missing something?
-
How to make NULL values display on a Table?
Essentially what I'm trying to do is.... SELECT DISTINCT Loan_Type FROM Dataset within a beastmode. I'm an having an issue where if no data exists for Type B then the entire row of the table disappears verses the type name being visible and 0s displaying. How can I resolve? What I want: Type Count Type A 5 Type B 0 Type C…
-
Use BeastMode calculation as column with Dataset query api?
Its is possible to select a beastmode calculation column in the query set API call? Im trying something like: {"sql": "SELECT realColumnName, beastmodeCalculationName FROM table"} and the result is There was a problem executing the SQL query: Invalid column(s) referenced We use a similar query in our custom domo app with…
-
is it possible to extract Card data through API?
Hit here, trying to extract data from a specific card. I seem to get pretty close with this https://developer.domo.com/docs/page-api-reference/page But that only tells me of the cards listed on a specific page and nothing about the data within.... I'm also able to query a…
-
Is it possible to create cards programmatically?
The Domo API seems to provide the means for creating and administering pages. Are there similar endopoints for creating cards inside a page?
-
Scheduled report with a repeated card
Hi I want to create a scheduled report to be sent by mail. However, I have a special requirement: I want one of the cards of the source dashboard to appear "duplicated" several times on the email report, each time with a different filter. For example, if the original dashboard has a "sales per day of the week" card, I…
-
join two tables with date comparison in where clause MySQL
I have two tables that I need to join based on the date differences. Table a looks like this: ``` Date Partner Revenue 12/01/20 Cosmo 10 12/01/20 Esquire 5 ``` Table b looks like this: ``` Date Partner Revenue 12/01/20 Cosmo 10 12/01/20 Esquire 5 12/02/20 Cosmo 20 12/02/20 Esquire 25 ``` I need to grab everything from…
-
Domo encountered an error proxying your request: 500
I have an API running in postman successfully, but when I am trying to perform the same using DOMO custom connector it gives the below error. Domo encountered an error proxying your request: 500 Can someone through some light on this? not sure what this error means, Where I can get the full details of error logs?
-
Unusual error with console.log
Hello, I'm starting a project in Sugarforce and I can't console the query results. Both datasets are correctly defined in the manifest file Although, when looking in the Network tab of Chrome, I see the results I've restarted my browser and still nothing in my console. Has anyone dealt with this or a similar issue before?…
-
The 'not' operator does not seem to work on the domo API for PDP filters?
Anyone run into issues with the 'not' operator on the domo API for PDP filters? The docs show that including false for 'not' on a filter will add a PDP rule that the column quals the value. In this example that Attending = 'TRUE' : { "id" : 8, "type" : "user", "name" : "Only Show Attendees", "filters" : [ { "column" :…
-
Unable to login to DOMO from App Dev Studio.
I have installed the App Dev Studio but when I am trying to connect to the instance, it gets stucked and the credentials doesn't pop up. What should I do to solve the? I have attached the ss also....The screen is not going ahead of this after I enter my domo instance .
-
Export very large dataset (million or row) in CSV as chunks
Is it possible in DOMO using python or postman to export whole dataset but break files(CSV/Excel) so we can have 5 million rows in each exported file.
-
Where to download pdputil.jar?
Hi, PDP Policy Autocreation section of the documentation mentions a command-line tools ("pdputil.jar") for managing PDP policies: https://knowledge.domo.com/Connect/Personalized_Data_Permissions_(PDP)/PDP_Policy_Autocreation I haven't been able to find a download link though. I've looked in Adming Settings | Tool Downloads…
-
Capturing datetime of updates
I have a table which has 'Update Datetime' column. As soon there is a request for work, this column is updated. I can easily create a recursive and keep track of all tasks with updated datetimes (timeline). The problem is that as soon the task is complete, this same column changed and shows the complete task datetime. So I…
-
How to implement commands from the Command Line Interface Tool in Python, specifically api requests
Question: Is it possible to execute command line interface tool operations within Python, specifically the 'list-dataflow' command? Elaboration: The 'list-dataflow' command in the command line interface tool returns JSON structured metadata for a dataflow. My guess is that this command is just making a GET request to a…
-
DataFlow Transform (i.e. Action) Types in API JSON data
My question: What factors determine the type of a dataflow transform in the api JSON data (e.g. GenerateTableAction, SQL, SqlAction)? Background: I am using DOMO's command line tool to get JSON structured metadata about a DataFlow. Specifically, I am using the list-dataflow command: Putting in the DataFlow id and a…
-
Timestamp Convention in JSON File from Command Line DataFlow Request
My question: Does anyone know DOMO's timestamp convention and how these map to normal timing conventions? Background: I am using DOMO's command line tool to get JSON structured metadata about a DataFlow. Specifically, I am using the list-dataflow command: Putting in the DataFlow id and a filepath returns a json file to…
-
User Profile fields only manual?
The title and department fields on the User Profile, is the only way to populate these a manual process? I can see the Bulk Import and Bulk Export but that is still manual. Any other way to feed and connect this data to a source?
-
Full list of Datasets & Cards
Hello, I was wondering if there was a way to extract a list of datasets into Excel. I am trying to see how many datasets we have, who owns them, and the impact each of the card has. Thank you
-
DOMO CustomApp - How get the the ErrorMessage of a domo.post?
Hi, I have built a Domo Custom App to call an AWS Lambda Function with domo.post. There's no problem in managing the response when all goes fine. But I haven't found how to extract the ErrorMessage from the response when it gives an error (HTTP errorcode: 400) Can someone tell me where domo keep this information? Thanks
-
Read only DataSet API access/token generation
Hi! I'm working with a third party and would like them to have read-only API access to a certain dataset. I just figured out how to query data with the DataSet API, but I was concerned with access. I haven't found a way to restrict access to data. I know you change the scope of the client, but I didn't find any scope…
-
Command line tools and the "DQL"
I was pointed to Domo's CLI tools today, and the documentation mentions the DQL in few spots. domo.com/api/domoweb/auth/helpcenter?redirectURL=/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool I assume that's the "Data Query Language", a find a few references to it in the command summaries:…
-
quarterly difference in sum(Revenue) saved in a new column SQL Magic Transform
I need to add a new column to my table that will have the difference between sum of revenue of a new quarter over the last one. I am using SQL Magic Transformation. My data looks like this: ``` Website Year Quarter Revenue cosmo.com 2019 4 10 cosmo.com 2020 1 15 cosmo.com 2020 2 5 fashion.com 2019 4 10 fashion.com 2020 1 5…
-
New to Domo Developer
Hello, Experts, Excuse me for being naive. I am a python developer and I am looking for a way to integrate data from an API that was built in the 16th century (sarcasm). The API allows for GET/POST/UPDATE/DELETE via RESTful API libraries but the responses come back as XML (hence 16th century). How the data is structured is…
-
Connecting curated Domo card to Google Travel API for report submission
Hi everyone, Objective: To connect curated Domo card to Google Travel API for report submission. I went through Domo Data API connection document, and I am still uncertain whether DOMO API's capability to export the data includes the capability to send the DOMO card data as .csv to another API endpoint or not. If yes, can…
-
Adding header column in between existing header columns
While populating data-grid after getting an API response. I have a problem statement where I need to add a new data-grid header in between the existing data-grid header while populating column data. As in my case, I want to add a new header name as 'Order Date' in-between existing 'Order ID' & 'Order Status' while adding…
-
Programmatically run a dataflow/dataset
Hello, I would like your help in order to understand how to run a dataset (or a dataflow) based on a trigger outside Domo. Let's say, for instance, I have a python script that check a condition on my database and if the condition is met, it should trigger the execution of two mySql Connector in Domo. Would this be possible…
-
Feature Request: Parquet format
I would like to be able to ingest data into Domo from an S3 source that contains files in Apache Parquet format. Is this on the targeted roadmap or something that is not been requested enough to be considered?