Datastream API in R

Question

I am attempting to use the Datastream API in R (through the VS Code IDE). I already did so successfully in the past and already initialised my Datastream personal username & password. Now I am trying to run code on a new project (the code was written by someone else). I ran the code: mydsws <- dsws$new() But received an error message beginning by: > mydsws <- dsws$new()Error in curl::curl_fetch_memory(url, handle = handle) (…) I am led to believe the error is not with my code or my laptop, but a connectivity issue. May I please ask for your help to fix it?

Jirapongse · Accepted Answer

@juliesls

Thank you for reaching out to us.

DatastreamR is a third-party library, and therefore we do not provide support for it.

You can use the httr library to verify the connection. For example:

library(httr)

DatastreamUsername <- "Username"

DatastreamPassword <- "Password"

token_url <- paste("http://product.datastream.com/DSWSClient/V1/DSService.svc/rest/Token?username=",

DatastreamUsername,

"&password=",

DatastreamPassword,

sep="")

test <- httr::GET(token_url, httr::timeout(300))

print(test)

print(status_code(test))

print(headers(test))

print(content(test))

wasin.w V3 · Accepted Answer

Hello @juliesls

It seems you are using the https://github.com/CharlesCara/DatastreamDSWS2R library. Please be informed that it is a 3rd party library, not LSEG official product. I strongly suggest you contact the library developer directly via the https://github.com/CharlesCara/DatastreamDSWS2R/issues page if you want to continue using the library.

Alternatively, you can use the pure HTTP approach like suggested by @Jirapongse.

JasonRamchandani01 · Accepted Answer

@juliesls You can also you the following R package which was written and is maintained by a client and was very kindly open-sourced to the community - it contains R wrappers for Datastream (ported from CharlesCara) and the Workspace APIs. You can find the package here:

https://github.com/GreenGrassBlueOcean/RefinitivR

I hope you can find this of use. Has anything changed in your environment such as firewall or blocking that might need whitelisting - it seems strange it was working before and now it is not - can you try the approach outline by @Jirapongse and report back thanks.

EXPLORE OUR SITES