R connector to Domo giving 406 error
user05966
Member
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
0
Comments
-
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
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive