Facing Problems while trying to get data placed in AWS S3 bucket using R

Hi ,

I am trying to fetch data9csv,xlsx,tsv)  placed in AWS S3 bucket into spotfire  using R , but getting errors. please help me out.

R Script :

library("aws.s3")

# create a temp file location
tf <- tempfile(fileext = ".csv")

#save the S3 object to the temp file
save_object(   
            key = 'Key ',
            secret = 'Secret ‘, 
            object = 'folder/name.csv',
            bucket='bucketname',
            file <- tf
            )

(or)

 

library("aws.s3")
tf <- tempfile(fileext = ".csv")
Sys.setenv("AWS_ACCESS_KEY_ID" = "Key,
           "AWS_SECRET_ACCESS_KEY" = "Secret"
)

save_object(   
          object = "S3://bucketname/folder/filename.csv ",
          opts = list(verbose = TRUE),
            file = tf
            )
irisTable = read.csv(tf, header=TRUE, sep=",")

 

error1 : when i select 'Force Server' option in the drop down  
TIBCO Spotfire Statistics Services returned an error: 'Error in library(&quot;aws.s3&quot;) : there is no package called &apos;aws.s3&apos;'.
   at Spotfire.Dxp.Data.DataFunctions.Executors.RemoteFunctionClient.OnExecuting()
   at Spotfire.Dxp.Data.DataFunctions.Executors.AbstractFunctionClient.<RunFunction>d__0.MoveNext()
   at Spotfire.Dxp.Data.DataFunctions.Executors.SPlusFunctionExecutor.<ExecuteFunction>d__0.MoveNext()
   at Spotfire.Dxp.Data.DataFunctions.DataFunctionExecutorService.<ExecuteFunction>d__6.MoveNext()

but i see aws.s3 package installed on spotfire server 

error2: when i choose 'Force Local' option in the drop down 
TIBCO Enterprise Runtime for R returned an error: 'Error in .loadNamespaceImpl(package, path, keep.source, partial) : error executing useDynLib for dynamic library 'xml2' from package 'xml2' loaded from C:/Users/ID/Documents/TERR/x86_64-pc-windows-library/4.2 : Error in library.dynam(chname = chname, package = package, lib.loc = ... : Foreign binary xml2 could not be loaded'.

After looking into this i went through Tools>TERR Tools>Package Managment>Selected xml2 in CRAN Package Reposiyory and loaded into dxp . But i didn't see any change after this 

 

Can some one help me out 

(3) Answers

Login