-
Is it possible to make a HTTP request using the Python Script tile of Magic ETL?
We would like to use data of a dataset in the body of a POST request and we were wondering if the Python Script tile in Magic ETL would work for that. We have analyzed but it does not seem to have libraries for that. We have this solution to export the dataset and make the request in a Python script in a Virtual Machine…
-
write_dataframe fails to write output of pd.pivot_table having Nulls
Domo python tile fails to write the pivoted dataframe with pd.pivot_table if it has nulls while converting - even if you add 'fill_value=np.nan'. See below: The pivot function works perfectly fine - it does generate the df, however, when you try to write it, it fails - see below if I write the unpivoted df, it works fine…
-
R and Python for determing dataframe equality in ETL
Greetings Domo Community, I have currently been refactoring Magic ETL tiles and have been attempting to use Python and R scripts to test for equality before finalizing the refactored tile components. Using both approaches with Python and R I have had significant difficulties in completing this task, which I will outline…
-
DomoR vs DomoSDK?
I have been handed an r script that has is using an accessToken to connect to domo and extract a dataset using a dataset ID. My end goal is to translate this to Python, as I have an existing pipeline in python that needs this dataset. Initially using the naive approach I tried to connect to Domo using pyDomo but was…
-
Daily Dataset Update via Python fails on first run each day
I am using the Domo Dimensions Calendar as an input to a Python script that updates an dataset of the next 365 days as columns |2023-01-27 | 2023-01-28 | 2023-01-29 | 2023-01-30 | ........ | 2024-01-27 So, when the script runs tomorrow the first column will be 2023-01-28, and so on. It works, to a point. The first daily…
-
"Column referenced but not found" Python error creating date-sensitive columns in ETL
Objective: To take an existing dataset that shows event start and end dates, and a total value and parse that info into a daily value that appears in columns representing all dates between start and end. Method: Using Domo Dimensions Calendar, select only rows from current date to +2 years. Use the result in a Python…
-
R Script Packages
Is it possible to install packages to use in an R Script (DataFlow > Scripting > R Script)? I tried install.packages(), but "/usr/lib/R/site-library" is not writable. I tried installing to a few other folders too (e.g. install.packages(lib = '/usr'), but they aren't writable. Granted this is a fringe use case, but it would…
-
Column Names with R plugin
Hello, I am using the R plugin and noticed that all the attributes (column names) from my source which contain spaces are replaced with a "." in R. (i.e. "Prod. Name" -> "Prod..Name") Is there a way to avoid this behavior? I know that I could change the names again in R but this becomes really challenging and…
-
Getting an error in the R tile but not native R?
Hello! This has stumped me - wondering if anyone could help me out Part of my code is attempting to sort by the max date. This works just fine in RStudio, but for some reason not in the R tile within Domo: summarize(Date = max(Date)) Error: 1: In if (class(df[[colName]]) == "factor" | verbatim) { : the condition has length…
-
Connection error when trying to initiate Domo using R
Hi, I am trying to initiate Domo from R using the DomoR package. Below is my code - library(DomoR) DomoR::init('my_company', "aaa51e07b27d5d8828517xxxxxxxxxxxxxxxxxf90f4") With this code, I failed to initiate and got below error - Error in curl::curl_fetch_memory(url, handle = handle) : Timeout was reached:…
-
R Warning message prevents execution on any data set
I am attempting to use magic ETL, and keep getting the following error message whenever I attempt to use R: Warning message: In if (class(df[[colName]]) == "factor" | verbatim) { : the condition has length > 1 and only the first element will be used I've attempted on several data sets with just the basic template code, and…
-
Is there a way to change the data type before fetch function in DomoR R Plugin?
I am using the DomoR R plugin to connect to Domo and get the dataset we have in Domo for some analysis. The issue I encounter are: * There're lots of warning message after the DomoR::fetch() function: * See spec(...) for full column specifications. * See problems(...) for more details. * The data which should be a string…
-
Trying to fetch data from within DOMO using R ; getting the following error-Not Acceptable (HTTP406)
Hi, I am trying to use the R Plug In option in DOMO to 'Fetch' a dataset from DOMO, do some manipulation next and then push it back to DOMO thereafter. But I am constantly getting this error : Not Acceptable (HTTP 406) when I use this code : DATA_RMMSB<-DomoR::fetch(my_dataset) my_dataset is a variable where I have stored…
-
R connector to Domo giving 406 error
Hi, I am using R connector package 'DomoR' to fetch one dataset which is used in one of the Domo cards as below: > library(DomoR) Welcome to DomoR > DomoR::init('xxxxx',…
-
R plugin
Hey Domo Team, I am trying to get your R plugin up and running as per this page: https://<account_name>.domo.com/downloads/rplugin When I get to the Github installation portion I get an error: Error in stop(github_error(request)) : Not Found (404) This is reproduced in the Rstudio console in the image attached. There is…