-
How to grab the last x days in MySQL Table
Hi. I have a very simple task of grabbing the data for the past 7 days. My current query looks like this: select * from `table` where `date` > CURDATE() -7 This works perfectly well, only when we get to the next month it is not grabbing any day from the previous month. I need to grab the data regardless of what month it…
-
API call after generating an auth_token fails with comment about 'Full authorization required'
This occurs in sandbox domain for "michael-dev-321536". I have checked curl construction several times. I figure I am doing something obvious wrong.
-
Stopping Emails from going out on User Creation.
Hello, As the title suggests, is there a way to stop emails from going out when a new user is created or when pages are added to a user through the admin tab? We enabled SSO so now we can't edit the email address once the user has been created. Not sure if this question has been asked before. Thank You.
-
Stock Open Opportunities by Active Account Executives in a period
Hi all!, I need some help here. I have a dataset of active employees in a specific date or period builded with a snapshot dataset day by day. I.e: By the other hand, I have a dataset of opportunities, with "Date Created" and "Closed Date". If an opportunity has a "Date Created" less than or equal to "active period" and…
-
pyDOMO Create users based on existing dataset
Hi, Im trying to automate our creation of users and assign role dynamically based on our existing dataset in DOMO. Im new to pyDOMO and currently following samples below: user_list = pd.read_csv('UserList.csv') def add_user_list(ul,domo_object,invite=False): ur = CreateUserRequest() users_created = [] for index, row in…
-
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…
-
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…