Error in proxy connection in DSWS API

Proxy connection DSWS.pngOne of our clients wants to connect through proxy when using DSWS API. His code currenlty looks like the attached, but getting following error msg:

HTTPSConnectionPool(host='product.datastream.com', port=443): Max retries exceeded with url: /DSWSClient/V1/DSService.svc/rest/GetToken (Caused by SSLError(SSLError("bad handshake: Error([('SSL routines', 'tls_process_server_certificate', 'certificate verify failed')])")))

_get_json_Response : Exception Occured:

get_data : Exception Occured

(<class 'Exception'>, Exception('Invalid Token Value'), <traceback object at 0x0000029FA02A7788>)

Traceback (most recent call last):

File "C:\ProgramData\Anaconda3\lib\site-packages\DatastreamDSWS\DS_Response.py", line 146, in get_data

raise Exception("Invalid Token Value")

Please assist. Thank you.

Find more posts tagged with

dsws-api

Accepted answers

Jirapongse

@bob.kim

On Windows, the Datastream Python library uses the wincertstore package to load the Windows certificate file.

The code looks like this:

import requests
import wincertstore
cfile = wincertstore.CertFile()
cfile.addstore('CA')
cfile.addstore('ROOT')
cfile.addstore('MY')

proxy="http://<proxy>:<port>&quot;
url = 'https://product.datastream.com/DSWSClient/V1/DSService.svc/rest/GetToken';
       
myobj = {"Password": "<password>", 
         "Properties": [{"Key": "__AppId", "Value": "PythonLib-1.1.0"}], 
         "UserName": "<username>"}


x = requests.post(url, json = myobj, proxies={'http':proxy, 'https':proxy}, verify=cfile.name)


print(x.status_code)
print(x.text)

All comments

Jirapongse

@bob.kim

I can run the DSWS API through the proxy properly.

The problem may be specific to the client's environment. The client can contact the client's IT support team to verify the proxy settings.

bob.kim

Thanks very much @Jirapongse Jirapongse. Would you by the way have any examples frequently experienced in regards to client's IT related issues in similar cases? That'd be greatly helpful. Thanks again.

Jirapongse

@bob.kim

The datastream server is on the Internet so any machines that can connect to the Internet can access the server.

Therefore, if clients are unable to connect to the datastream server, it could be a problem in network, proxy, or firewall settings.

Jirapongse

@bob.kim

The client can try the following code.

import requests
#http_Response = requests.post(reqUrl, json=jsonRequest, proxies=self._proxy, verify=self._sslCer, timeout= self._timeout)
proxy="<proxy server>"
url = 'https://product.datastream.com/DSWSClient/V1/DSService.svc/rest/GetToken';
      
myobj = {"Password": "<password>", 
         "Properties": [{"Key": "__AppId", "Value": "PythonLib-1.1.0"}], 
         "UserName": "<username>"}

x = requests.post(url, json = myobj, proxies={'http':proxy, 'https':proxy})
print(x.status_code)
print(x.text)

The client may need to specify the certificate file in the sslCer parameter.

Datastream(username, password, config=None, dataSource=None, proxy=None, sslCer=None)

What operating system (Windows or Linux) is the client using?

bob.kim

Cheers! i Will get back to you with client's OS

But can client directly use the above code, i.e. I'm guessing he will just need to replcace <proxy server>, <username> and <password>, but able to use the rest?

Lastly do you also directly support end users/clients via email?

Thanks again!

Jirapongse

@bob.kim

On Windows, the Datastream Python library uses the wincertstore package to load the Windows certificate file.

The code looks like this:

import requests
import wincertstore
cfile = wincertstore.CertFile()
cfile.addstore('CA')
cfile.addstore('ROOT')
cfile.addstore('MY')

proxy="http://<proxy>:<port>&quot;
url = 'https://product.datastream.com/DSWSClient/V1/DSService.svc/rest/GetToken';
       
myobj = {"Password": "<password>", 
         "Properties": [{"Key": "__AppId", "Value": "PythonLib-1.1.0"}], 
         "UserName": "<username>"}


x = requests.post(url, json = myobj, proxies={'http':proxy, 'https':proxy}, verify=cfile.name)


print(x.status_code)
print(x.text)

bob.kim

Thanks again. So are you saying to add the code above to run the DSWS code?

Cheers,

Bob

Jirapongse

@bob.kim

Yes, Datastream uses this requests.post method to send requests to the Datastream server.

EXPLORE OUR SITES