Matching File Input Request Example
I am trying to build a matching request using csv file using python request library. I am getting <Response [500]> What I am doing wrong here?
My example csv input file contains just one column with the header name and 1 row, like this:
name
There is my code:
request_url = "https://api-eit.refinitiv.com/permid/match/file"
headers = { 'Content-Type': 'multipart/form-data',
'x-ag-access-token': my_apikey,
'x-openmatch-numberOfMatchesPerRecord': '1',
'x-openmatch-dataType': 'Organization'}
files = {'file': open('C:/My_Folder/input_file.csv') }
response = requests.post(url=request_url, headers=headers, files=files)
r = response.json()
print(r)
----------
<Response [500]>
{'error': {'status': {'code': '500',
'errorCode': 'Server Error',
'errorDescription': 'java.lang.NullPointerException'}}}
Best Answer
-
Hello @EA_MZ ,
In Python, by specifying "files" as parameter, the request is already 'Content-Type': 'multipart/form-data':
This discussion thread may be helpful.
It seems, that if you have it twice, Requests module gets it slightly off, resulting in the invalid submission.
It is mandatory.
1
Answers
-
Hello @EA_MZ ,
Please see Record Matching API Swagger documentation. You can test with your file, to see if it is formatted correctly.
Via link "templates can be found here" you can download the required format templates, per record type of search, and test with this file. Next you can follow the same format for your entries file, that will ensure the valid format of the submitted file.
0 -
Hi Zoya, I tested my file through the website and it works without problems, however it doesn't work when submitted through api using python requests.
It is a very basic input, just one row with a header 'Name'.
0 -
Hi @EA_MZ ,
Try
import requests
request_url = "https://api-eit.refinitiv.com/permid/match/file"
headers = { #'Content-Type': 'multipart/form-data',
'x-ag-access-token': 'YOURTOKEN',
'x-openmatch-numberOfMatchesPerRecord': '1',
'x-openmatch-dataType': 'Organization'}
files = {'file': open('.\exampleRM.csv') }
response = requests.post(request_url, files=files, headers=headers)
r = response.json()
print('Response:')
print(r)works on my side
0 -
Thanks Zoya! Disabling the 'Content-Type': 'multipart/form-data' in the header solved the issue! Do you know what is the cause of this issue?
The 'Content-Type': 'multipart/form-data' parameter is presented in the manual as mandatory, so it was confusing.
Image Caption
0 -
You can refer to the OpenPermID Python library.
The source code is available on GitHub.
files = {'file': open(filename)}
response = requests.post(
url,
headers=headers,
files = files,
timeout=self.__timeout__)0 -
they omit the 'Content-Type': 'multipart/form-data' parameter in the openpermid module
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛