-
error on domo login on fresh install
Hi i've installed the domo-advanced-sample-app repo, and installed ryuu and plop globally. When i try to do domo login i get this error: [ERROR] The domo cli tool has experienced an error. As it is [ERROR] possible this bug has already been fixed, please try updating [ERROR] using `npm install -g ryuu` and run this command…
-
How to delete rows automatically based on a date in a dataset ?
I am inserting new rows in a dataset on daily basis, and now the dataset size has became huge since the rows are added daily. I want to delete the rows from this dataset based on date criteria (Dataset has a column type of "date" in it). So the criteria is like I want to maintain rows in dataset for last 30 days. eg assume…
-
Connecting LivePerson to DOMO?
I tried contacting LivePerson about this but as they are unfamiliar with DOMO they couldn't answer. It's a messaging service, and I want to retrieve two datasets from there: Message logs, and KPIs. For now I just want to look at the message logs to get me going. There's no DOMO Connector for LivePerson so I have to create…
-
APIs related to moving DataFlows
I know there are some unlisted/documented APIs related to DataFlows - importing and exporting them from environments. These aren't currently included in the SDKs and I'm wondering if there are plans on the roadmap to add them? Also wondering if they are stable to use as is as well.
-
Specifying Domo sub-domain using python SDK
Is there a way to specify that I would like my request via the python sdk to only return from a specific sub instance of Domo? If not, how would I specify/pass this in a standard API call?
-
Embedded card via programmatic filters does not allow BETWEEN pfilters
We changed our integration to use Programmatic Filters for authentication. That part works just fine. It is when I apply additional pfilters via the query parameter, the embedded card fails to load. Its that Date column again, which is a calculated field, with the BETWEEN filter. the final url with the POST to domo server…
-
I want to export my dataset as chunk of excel/csv file
I have a dataset in domo and I want to export the it in to chunks of excel/CSV file and each file having 5 lakhs rows. I found this link on domo developer. Can some one guide me how to proceed with this? I have Python 3.7.1 installed on my system and also having Anaconda distribution to work with Python if needed.…
-
Failed to connect to api.domo.com port 443: Connection refused
I am unable to connect to api.domo.com. Created a clientid and secret from https://developer.domo.com/ And when I tried the curl command to authenticate, following error occurs. curl -v -u CLIENT_ID:MY_SECRET_KEY "https://api.domo.com/oauth/token?grant_type=client_credentials&scope=account" * Trying 52.86.16.162... *…
-
Management API filtering would be so helpful
Currently the Users API https://developer.domo.com/docs/users-api-reference/users-2#List%20users lets you filter by offset and limit. However, for every use case I know of, an external application doesn't need all of the users, but a single user. So you either have to know that users Domo supplied ID or you have to…
-
Creating a Dataset
Hi All, I have been testing/trialling a lot of Business Intelligence and Domo is the only BI that has instantly clicked with me. I think this is the BI which would automate a lot of work and provide smarter reports. I want to know what would be the best practice to join multiple sales reports - these needs to formatted. We…
-
Is there any way to delete multiple datasets at once?
-
What URL do I use when setting up a Google Analytics property for CourseBuilder?
Do I use the instance URL or the app page URL?
-
Is there a way to connect Domo CLI commands to Domo apps?
I want this Domo CLI command be use to domo apps.. is there a way? The command swap-owner does not exist in Domo API so I'm looking for a way to use it It Transfer ownership of Alerts, Cards, Groups, Pages, Reports, DataSets and/or DataFlows from one user to another.
-
SQL transforms LAG or LEAD
I tried LAG function in mySQL transform, but it appered to be missing. Is this correct?
-
Phoenix error - unsure why
Hello all, I'm exploring Phoenix charts and I have my query like this: const ds = 'DS_Name'const select = ['dept_code_name', 'absval', 'trx_date'];const where = ['account = 8981', 'dept_code = 459', 'trx_date last 1 month'];const dategrain = ['trx_date by month'];const query =…
-
Domo Query API - Row limit?
Hello, Experts, Is there a limit to the # of rows you can pull down from a Domo dataset using the Domo Query Dataset method? https://developer.domo.com/docs/dataset-api-reference/dataset#Query%20a%20DataSet I have built a https request using python and then leveraging writing that response to a python pandas data frame.…
-
Deleting cards with API
Hello Evryone, I have 10K+ cards which was identified by our BI team which are no longer used. How can I delete these cards (have the cardid of them) with the API / python sdk?
-
Error while updating dataset schema using DOMO CLI
HI, i tried to change the scehma of one API dataset using DOMO CLI and the command set-scehma. After i noticed i update the schema with uncorrect columns as upsert . i tried to run back with the original schema but i got the following error. Index progress error for dataset ae4f6f65-5ebf-47b1-9213-fe73ee5dfdcd. Indexing…
-
How to writeback new variables to DOMO dataset in Custom App
Hi all I am currently developing a Custom App in DOMO where I need to create new variables, based on the output of a multiplication formula, onto a DOMO dataset linked in the Custom App. Do I put the writeback syntax in JavaScript file? Or how should I go about doing it? Appreciate your help!
-
Create DataSet API is not creating schema anymore.
This was working before. I am trying to create a dataset with a schema of 2 columns. The dataset creation is succesful but it is getting created without any columns in it. Even the example given in developer.domo.com doesn't work. I tried both dataset and Stream APIs. In both cases the API successfully created dataset but…
-
OpenID Connect does not work with Amazon Cognito
Hi, When trying to setup Amazon Cognito as the OpenID Connect provider I get an "invalid_scope" error returned from Cognito. This is created by the fact that Domo is requesting the following scopes on the request to Cognito: * scope=openid profile email phone address The address scope does not exist within Cognito and as…
-
Make Domo Api Accessible Using Token
Hi Devs,We were integrating Domo Dataset Api into our client application for which we need token, So we created one using a Client id & Client Secret. From that we've got the token generated. There is no problem in generating a token. Issue is, we made use of the token above, Inserted that into POSTMAN to check the Dataset…
-
Connect a valid source Error in Magic ETL with BigQuery Service Connector
Hi, I am trying to transfer the data from one dataset to another. The original dataset is getting the data through BigQuery Service Connector. When creating a Magic ETL and choosing my original dataset as `input dataset` and `Append Rows` I get an error: `Connect a valid source to this action to get started`. Not sure why…
-
Pulling CSV file from UNIX Server
Hi All, I am trying to pull CSV file from UNIX server using below DoMo connectors but getting some errors. 1) CSV SFTP Pull Connector - Inspite of providing correct credentials and hostname with appropriate syntax I am getting error as "Failed to Authenticate. Verify the credentials and try again" 2) CSV Advanced Connector…
-
Is it possible to get the list of users / groups a dataset is shared with?
Hi New to Domo and forum and tried to access this information but could not find it anywhere. Is it possible to get a list of users / groups the dataset is shared with either using a connector or the Python API ? I want to create a central source to check that rather than going to individual datasets and checking it.…
-
Renaming of columns in Datasets without destroying cards
Dear Domo-Crowd, we are starting a project to rename measures and dimensions in our datasets. Basically we need to clean up our measure/dimension-namings. As Domo-Cards use the names of the measures/dimensions as identifications, this would screw up all our cards. I was wondering if anyone in this community already went…
-
Domo CLI - create-dataset produces "error status 500"
I am testing Domo CLI and I simply downloaded the schema for a dataset with "get-dataset" and then try to upload the same file to create a new dataset using: "create-dataset -n "Marketing Dataset - Test Help Center" -t DataFlow -s dataset_download" I receive an "error status 500" with no further information and there are…
-
Domo CLI not working
Hello, any tech support advisor roaming here? I'm unable to domo init, dev or publish. I've recently configured my laptop for React.js development and I'm unsure if that screwed up my domo cli configuration I'e already tried the ryuu commands seen here https://developer.domo.com/docs/dev-studio/next-steps-2 I've also…
-
Export filtered data into CSV/Excel
Hello Experts, For one of our business partner we have created a dataset as per his business requirement containing @500,000 records. He applies filters on "Data Tab" of that dataset to view data as per his requirement. Once filter is applied, record count reduces to @1000 only and he need to export these 1000 records into…
-
calculating variance with mysql week over week
I need to display week over week difference with mysql in `Week Over Week Users` column. My data looks like the following: ``` Date Users Week Over Week Users 06-01-2019 10 10 06-08-2019 15 15 06-15-2019 5 5 ``` Currently, `Week Over Week Users` only reflects the data that I have in `Users` column. The desired output would…