question

Upvotes
Accepted
akshay.kaushal avatar image
20 ●2 ●3 ●3

When connecting to DSWS; I get 'SSLError(SSLError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:852)' Error

Hi All,

I am trying to pull data from DSWS using python. However even after providing username, password, and proxy details, I'm receiving this error. In the documentation it is mentioned that I should be doing something like this:

Please find the SSL certificate path on your local machine and provide the same in the code as shown below:

import DatastreamDSWS as dsws

ds = dsws.Datastream(username='XXXXXXX', password='XXXXXXX', sslCer='path\certfile', proxy='XXXXXXX:XXX')


However, I am unbale to figure out which certificate is needed exactly for the sslCer parameter and how to find its path on my local machine? Pls help, thank you


datastream-apidsws-api
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.

akshay.kaushal avatar image akshay.kaushal

Hi, pls help as I've hit a roadblock here

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
79.2k ●251 ●52 ●74

@akshay.kaushal

The DataStreamWS URL is https://product.datastream.com. I have checked this URL with https://www.sslshopper.com/. It uses a COMODO certificate so it should be this file: http://crt.comodoca.com/COMODORSAOrganizationValidationSecureServerCA.crt.


However, if you use a proxy server, you need to contact your IT support team for the certificate file of the proxy server.

The certificate file path depends on the operating system. You need to refer to the operating system documentation for the certificate file path. I found answers on this website.



1601271170948.png (164.4 KiB)
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.

akshay.kaushal avatar image akshay.kaushal

Hi @jirapongse.phuriphanvichai, thank you so much for your reply. I will ask the IT for the same.

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.