question

Upvotes
Accepted
Michael avatar image
1 ●1 ●0 ●0

Package DatastreamDSWS2R error requesting acces Token

Hello,

I am trying to download data from Datastream directly in R using 

require(devtools)
install_github("CharlesCara/DatastreamDSWS2R")

This works so far.

next I saved my username and password (those credential I use for Refinitive) and entered

mydsws <- dsws$new(username=DatastreamUsername,password=DatastreamPassword)

This throws the following error

> mydsws <- dsws$new(username=DatastreamUsername,password=DatastreamPassword)
...retrying
...retrying
...retrying
...retrying
Error in .self$.loadToken() : 
  Error requesting access Token.  Error message was:
Timeout was reached: [product.datastream.com] Connection timed out after 10001 milliseconds

Do you know why or do you have a solution for me?

datastream-apidsws-apirtoken
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

wasin.w avatar image   wasin.w

Hello @Michael

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.

Thanks,


AHS

Jirapongse avatar image   Jirapongse

Hi,

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

4 Answers

· Write an Answer
Upvotes
Accepted
wasin.w avatar image
24.6k ●54 ●17 ●14

Hi,

Based on all given error messages, it seems to me that your machine cannot connect to DataStream server. I suggest you contact your network or IT team to verify a connection problem on your side.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Jirapongse avatar image
78.8k ●250 ●52 ●74

@Michael

From the error, the request was timed out. You can try the following code to directly send a request to the server. 

library(httr)
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))
test
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Michael avatar image
1 ●1 ●0 ●0

@jirapongse.phuriphanvichai

Thank you very much for your answer. However this seems not to fix the problem as it still throws an timeout error.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jirapongse avatar image Jirapongse

It could be a network issue. You need to contact your network team to verify the problem. If you need to connect through a proxy, you can use the following command to set the http_proxy.

Sys.setenv(http_proxy="http://127.0.0.1:8080")
DatastreamUsername <- "username"
DatastreamPassword <- "password"
mydsws <- dsws$new(username=DatastreamUsername, password=DatastreamPassword)


Michael avatar image Michael Jirapongse

I tried it and this produced a new error:

Error in .self$.loadToken() : 
  Error requesting access Token.  Error message was:
Failed to connect to 127.0.0.1 port 8080: Connection refused
Jirapongse avatar image Jirapongse Michael

127.0.0.1:8080 is my test proxy. You should contact the network or IT team to verify the problem.

Show more comments
Upvotes
Michael avatar image
1 ●1 ●0 ●0

Hello @zoya.farberov, I tried using my local proxy but now I am encountering a new error which is: 

Client error: (403) Forbidden

Since I am not an IT specialist, I am kind of stuck at this point. Do you know a solution for that? Best regards Michael

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.