question

Upvotes
Accepted
20 1 0 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 5.0 MiB each and 10.0 MiB total.

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

1 Answer

Upvotes
Accepted
38.1k 71 35 53

@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 5.0 MiB each and 10.0 MiB total.

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

Click below to post an Idea Post Idea