Refinitiv Data Platform API connection error
Hello,
I am trying to establish python api connection to refinitiv dataplatform.
I have already installed refinitiv-dataplatform library for python (https://pypi.org/project/refinitiv-dataplatform/).
I am trying to establish connection throught following command:
rdp.open_platform_session( 'token', rdp.GrantPassword( 'user', 'password' ) )
Unfortunately, I gets following error in response: "2021-01-19 13:50:01,725 - Session session.platform - Thread 44920 | MainThread [Error -1 - ConnectError] b'[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1123)'".
Could i kindly ask you to help me understand and solve this problem?
Best Answer
-
Further update: I was able to get similar error when the library is used in conjunction with a proxy server which intercepts and re-sign's the https requests.
rdp.open_platform_session(appKey, rdp.GrantPassword(username = myuser, password = mypass))2021-01-25 13:48:34,624 - Session session.platform - Thread 9916 | MainThread [Error -1 - SSLCertVerificationError] b'[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get localissuer certificate (_ssl.c:1124)'<refinitiv.dataplatform.core.session.platform_session.PlatformSession object at 0x00000000025A2760>
To alleviate this issue:
- Are you able to connect without going through proxy server?
- If not, do you have access to proxy's certificate?
Also, what is the result after you installed:
python-certifi-win32
0
Answers
-
This may be related to your environment. Can you please provide the following:
- version of the refinitiv-dataplatform
- version of the http dependencies: httpcore, httpx, requests
- version of your desktop Eikon/Refinitiv Workspace
0 -
Thank you for your interest and additional questions.
Here are the versions of the relevant software:
refinitiv-dataplatform==1.0.0a7.post1
httpcore==0.10.2
httpx==0.14.3
requests==2.24.0
Eikon desktop 4.0.52 (4.0.52055)
Moreover, I forgot to mention this ealier, but I managed to establish connection via python API using following command:rdp.open_desktop_session('token')But as far as I know, this metod requires locally installed and actively running eikon software. That is why, I am looking for this second method of connection to be working.
0 -
Thanks @jaroslaw.szymanski,
I matched your dependencies and did not see the same behavior. It's good you tested your desktop and that you are able to establish a connection. Because, you are connecting directly into the platform (not through the desktop), this will have no dependencies.
I'm in contact with the developer and will keep you updated.
thanks.
0 -
We would like to capture some debugging information from you if that is ok. At the top of your code, can you insert this:
# to get trace from http lib
import os
os.environ['HTTPX_LOG_LEVEL']='trace'
os.environ['HTTPCORE_LOG_LEVEL']='trace'This will generate output to the console. In addition, you should also see a log file created in your current directory. If you can also include the details from your log, stripping out any login credentials, if necessary.
thanks.
0 -
Above debugging code generated folowing output in my console:
TRACE [2021-01-20 11:01:21] httpx._config - load_ssl_context verify=True cert=None trust_env=True http2=FalseTRACE [2021-01-20 11:01:21] httpx._config - load_verify_locations cafile=h:\python\lib\site-packages\certifi\cacert.pemTRACE [2021-01-20 11:01:22] httpcore._async.connection_pool - get_connection_from_pool=(b'https', b'api.refinitiv.com', 443)TRACE [2021-01-20 11:01:22] httpcore._async.connection_pool - created connection=<AsyncHTTPConnection http_version=UNKNOWN state=0>TRACE [2021-01-20 11:01:22] httpcore._async.connection_pool - adding connection to pool=<AsyncHTTPConnection http_version=UNKNOWN state=0>TRACE [2021-01-20 11:01:22] httpcore._async.connection - open_socket origin=(b'https', b'api.refinitiv.com', 443) timeout={'connect': 60, 'read': 60, 'write': 60, 'pool': 60}TRACE [2021-01-20 11:01:22] httpcore._async.connection_pool - remove from pool connection=<AsyncHTTPConnection http_version=UNKNOWN state=5>TRACE [2021-01-20 11:01:22] httpcore._async.connection_pool - removing connection from pool=<AsyncHTTPConnection http_version=UNKNOWN state=5>2021-01-20 11:01:22,764 - Session session.platform - Thread 39868 | MainThread[Error -1 - ConnectError] b'[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1123)'<refinitiv.dataplatform.core.session.platform_session.PlatformSession at 0x209d4e96520>And this is the content of log file:
[2021-01-20 10:57:47,220] - [session.platform] - [ERROR] - [access_token_updater] - [_do_update] - [Error -1 - ConnectError] b'[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1123)'
0 -
Thank you for the details - I will pass this off to the development team. One thing I forgot to ask, is what version of Python are you using?
thanks
0 -
I am using Python 3.8.5.
0 -
Thank you. We're going through the list of dependencies as we believe there may be a conflict within. Can you provide the version of your 'nest-asyncio'? We are using version 1.3.3.
0 -
Sure, I am also using nest-asyncio==1.3.3.
0 -
I'm working with development to better understand your situation. Given you are having no issues when you use the desktop session
rdp.open_desktop_session('token')Is a good indication the http packages you have are not the issue. I tried to replicate your environment, making sure I'm using the same version of Python, and did not run into any issues.
While development believes the Python code, by default, doesn't take into account Windows certificates, they want you to try the following:
> pip install python-certifi-win32
This is based on the assumption that if you are using Windows and you have already imported the CA in the trusted DB store, you can install the package python-certifi-win32 that automagically will use the same certificates from the Trusted DB store.
0 -
Can you please confirm if you are going through a proxy server?
0 -
I can only confirm, that I am using VPN connection.
0 -
What is the result after updating the python certificates -
python-certifi-win32.If all else fails, you might need to create a new python virtual environment and do a clean install of refinitiv-dataplatform library.
0 -
I think, that installing python-certifi-win32 nothing changed.
[2021-01-27 11:27:19,804] - [session.platform] - [ERROR] - [access_token_updater] - [_do_update] - [Error -1 - ConnectError] b'[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1123)'
2021-01-27 11:27:19,804 - Session session.platform - Thread 38816 | MainThread
[Error -1 - ConnectError] b'[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1123)'
2021-01-27 11:27:19,804 - Session session.platform - Thread 38816 | MainThread
[Error -1 - ConnectError] b'[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1123)'0 -
Something messed up in your python installation. Can you try building a virtual environment and retrying. Thanks.
virtualenv --no-site-packages venv
pip install refinitiv-dataplatform0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 37 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 698 Datastream
- 1.5K DSS
- 633 Eikon COM
- 5.2K Eikon Data APIs
- 14 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 6 Trading API
- 2.9K Elektron
- 1.5K EMA
- 257 ETA
- 564 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 283 Open PermID
- 47 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2.1K Refinitiv Data Platform
- 780 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 122 Open DACS
- 1.1K RFA
- 107 UPA
- 194 TREP Infrastructure
- 231 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 99 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛
