Data Transformation || R Connectivity || Automation

Neeraj
Neeraj Member
edited March 2023 in Datasets

We have a business scenario wherein we need to do data transformations for a data with source from cloud. We need the data to be exported to R or similar tool and import back to DOMO after transformations. We need to automate this process.

 

Please provide us the steps/process to do this.

 

Thanks in advance...!!!

Best Answer

  • kamuela
    kamuela Domo Employee
    Answer ✓

    @Wilko There are a couple package dependencies that cause this issue.  You need to make sure that you have httr version 1.0.0 or lower and readr 0.2.0 or lower installed in your instance of R.

    I am no longer with Domo. Please @mention @Millhouse for connector specific questions.

Answers

  • kshah008
    kshah008 Contributor

    Hi all,

     

    Can anybody help @Neeraj out?

    Thanks!

  • Hi @Neeraj,

    You could certainly use Domo’s connectors to download data from various 3rd party cloud sources. Within Domo, you could complete any pertinent transforms on the data and output it to a dataset. You can then export that data out of Domo using Domo’s API, which will provide a CSV dump of the dataset. Details on integrating with Domo’s API can be found in the Domo Developer Portal:

    https://developer.domo.com/docs/domo-apis/data


    ** I work for Domo

  • kamuela
    kamuela Domo Employee

    @Neeraj We also have a plugin for R that simplifies the moving of data between Domo and R.  After installing the plugin in R, you can create a new Domo DataSet directly from R or you can retrieve an existing DataSet from Domo, run your tranformations in R and then push the changes back into Domo.  It is currently available as a beta release.  Feel free to message me directly if you'd like access to it.

     

    Thanks,

    Sam

     

     

    I am no longer with Domo. Please @mention @Millhouse for connector specific questions.
  • Hi @kamuela,

     I've been given the DomoR plugin, and am currently exploring it.

     

     One problem I have encountered is the fetch command (DomoR::fetch). When I run it I get the following error:

     

    Error in readr::read_csv(x, locale = readr::locale(encoding = encoding),  :

      unused arguments (check.names = FALSE, na.strings = "\\N", colClasses = c(NA, NA, NA, NA))

     

    The dataset I'm calling exists and has data in it.

     

    I thought initially I had to explicitly name the columns ie c() but that made no difference.

     

    Is this something to do with library versions in devtools package? Have you guys come across this problem before?

     

    regards

     

    Dave

  • kamuela
    kamuela Domo Employee
    Answer ✓

    @Wilko There are a couple package dependencies that cause this issue.  You need to make sure that you have httr version 1.0.0 or lower and readr 0.2.0 or lower installed in your instance of R.

    I am no longer with Domo. Please @mention @Millhouse for connector specific questions.
  • Hi @kamuela

    Many thanks your answer was right on the mark. Problem Solved.

     

    Regards

     

    Dave

  • Hi,

     

    How do we get a hold of the R package?

     

    Vince

  • kamuela
    kamuela Domo Employee

    Hey @vblain if you want to send me a direct message with your Domo login URL and an email address, so I can see which customer account you are part of, I can send you the details.

     

    Thanks,

    Sam

     

    I am no longer with Domo. Please @mention @Millhouse for connector specific questions.