R connector to Domo giving 406 error

user05966

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', 'eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJyb2xlIjoiUHJpdmlsZWdlZCIsInNjb3BlIjpbImF1ZGl0IiwiYnV6eiIsImRhc2hib2FyZCIsImRhdGEiLCJ1c2VyIiwid29ya2Zsb3ciXSwiZG9tYWluIjoib2FuZGEuZG9tby5jb20iLCJleHAiOjE1NDgzMTQzNTcsImVudiI6InByb2QxIiwidXNlcklkIjozOTkwNDk1ODUsImp0aSI6ImU4MjdkNTdiLWJkNzUtNDRmNC1hMmU0LTMwN2Y0NWE3YmE5OCIsImNsaWxwOrZBZm3i0mg_y5VMuO_yprvx-7VdoD2gBsLzH5LQMsXohO7g459dCHi2bT8F-FtmJd9e_SqGhcQdC9F-rLh04I0-44X3QlmPADqnlF1nd5bekyR-HEFg1fdx8IcjctSvmWwlHYCY3mapFV6Rm4Rox8AsPZHTufTAw2KEUG1awZ9LBryG2Eg-_M2oI5zG6-ZyymzEm7DcPujGbNtHG456LF6JTPagxocV3di6rHZ8lm_AWs68iqIlLUfRqcyfKN3WFw7km6OoRlXrFcEAxZvviEyAg')
> DomoR::fetch('A_TABLE_NAME')

 

With this I am getting below error:

Error in DomoR::fetch("A_TABLE_NAME") :
Not Acceptable (HTTP 406).

 

Any pointer why am getting this error?

 

 

> sessionInfo()
R version 3.5.0 (2018-04-23)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 17134)

Matrix products: default

locale:
[1] LC_COLLATE=English_United States.1252  LC_CTYPE=English_United States.1252    LC_MONETARY=English_United States.1252 LC_NUMERIC=C                           LC_TIME=English_United States.1252    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] DomoR_0.1

loaded via a namespace (and not attached):
 [1] httr_1.3.1       compiler_3.5.0   pryr_0.1.4       magrittr_1.5     R6_2.2.2         tools_3.5.0      curl_3.2         Rcpp_0.12.16     stringi_1.1.7    codetools_0.2-15 stringr_1.3.1  

 

dthierjung

Hello,

 

So when you use the fetch() command in R, you have to pass in the id of a dataset, not the name of the dataset.

 

The id of a dataset can be found in the datasets url just after the "datasources" like in the example below:

 

https://{instance_name}.domo.com/datasources/ead12fdf-6519-4230-8s8c-9d457562b477/details/overview

 

Here's a reference page for more examples: https://github.com/domoinc-r/DomoR