Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Open PermID /
avatar image
Question by parbat · Dec 05, 2017 at 03:22 AM · apiintelligent-tagging-apipermid-apiopen-permid-apirecord-matching-api

Open PermID - Record Matching - RESTful API, Required fields are missing: [standard identifier,name]

1,RIC:AAPL.O|Ticker:AAPL,Apple,US,"Apple Campus, 1 Infinite Loop",Cupertino,95014,California,

for data not working reply error like "

{"errorCode":3,"errorCodeMessage":"Invalid Content – Required fields are missing: [standard identifier,name]."}

"

The code like bellow

$url="https://api.thomsonreuters.com/permid/match";
$ch = curl_init();
$headers = array(
'Content-Type:text/plain',
'x-openmatch-numberOfMatchesPerRecord: 1',
'x-openmatch-datatype: Organization',
'X-AG-Access-Token:33CpiIRai3nqQjEAEuQ05n1sIHg2Fum0'
);
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
curl_setopt($ch, CURLOPT_HEADER, 0);
/*test1
LocalID,RIC,TICKER,Name,Country,Street,City,PostalCode,State,Website
1,AAPL.O,,Apple,US,"Apple Campus, 1 Infinite Loop",Cupertino,95014,California,*/
/*test2
LocalID,Standard Identifier,Name,Country,Street,City,PostalCode,State,Website
1,RIC:AAPL.O|Ticker:AAPL,Apple,US,"Apple Campus, 1 Infinite Loop",Cupertino,95014,California,*/
//LocalID:1,Standard Identifier:"RIC:AAPL.O|Ticker:AAPL",Name:Apple,Country:US,Street:"Apple Campus, 1 Infinite Loop",City:Cupertino,PostalCode:95014,State:California,Website:""
$body = '1,"RIC:AAPL.O|Ticker:AAPL",Apple,US,"Apple Campus, 1 Infinite Loop",Cupertino,95014,California,';
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($ch, CURLOPT_POSTFIELDS,$body);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
// Timeout in seconds
curl_setopt($ch, CURLOPT_TIMEOUT, 30);
$authToken = curl_exec($ch);
print_r($authToken);

this is php curl example. so can you give me exact body i have to test? or give me proper php example with body i can test.

i have to test the persons data which is proper or not. at singapore and india.

but my example gives error so please reply as soon as possible

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Zhenya Kovalyov · Dec 05, 2017 at 05:59 AM

Here is a sample request done with python:

POST https://api.thomsonreuters.com/permid/match/file HTTP/1.1
Host: api.thomsonreuters.com
User-Agent: python-requests/2.14.2
Accept-Encoding: gzip, deflate
Accept: application/json
Connection: keep-alive
x-ag-access-token: your_token
x-openmatch-numberOfMatchesPerRecord: 1
x-openmatch-dataType: Organization
Content-Length: 576
Content-Type: multipart/form-data; boundary=b797ce52bdb64e9fafe39d85ea2fd223
--b797ce52bdb64e9fafe39d85ea2fd223

Content-Disposition: form-data; name="file"; filename="input.csv"

Content-Type: application/vnd.ms-excel


LocalID,Standard Identifier,Name,Country,Street,City,PostalCode,State,Website

1,,Apple,US,"Apple Campus, 1 Infinite Loop",Cupertino,95014,California,

2,,Apple,,,,,,

3,,Teva Pharmaceutical Industries Ltd,IL,,Petah Tikva,,,

4,,Tata Sky,IN,,,,,

5,RIC:IBM.N|Ticker:IBM,,,,,,,

6,Ticker:MSFT,,,,,,,

7,LEI:INR2EJN1ERAN0W5ZP974,,,,,,,

8,Ticker:FB&&Exchange:NSM,,,,,,,

9,Ticker:AAPL&&MIC:XNGS,,,,,,,


--b797ce52bdb64e9fafe39d85ea2fd223--

Here is the listing, should you require:

     url = 'https://api.thomsonreuters.com/permid/match/file'

    headers = {
        'x-ag-access-token':'',
        'x-openmatch-numberOfMatchesPerRecord':'1',
        'x-openmatch-dataType':'Organization',
        'Accept':'application/json'
    }

    with open('input.csv', 'rb') as input_file:
        content = input_file.read()

    files = {'file': ('input.csv', content, 'application/vnd.ms-excel')}

    response = requests.post(url=url, headers=headers, files=files, verify=False)

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by parbat · Dec 05, 2017 at 06:11 AM

@Zhenya Kovalyov

thanks for you answer but i want to do with php without a file. thats why i had use

$url="https://api.thomsonreuters.com/permid/match";

can you put example of body in php without file. i had tried with bellow 2 test but same error as above

/*test1
LocalID,RIC,TICKER,Name,Country,Street,City,PostalCode,State,Website
1,AAPL.O,,Apple,US,"Apple Campus, 1 Infinite Loop",Cupertino,95014,California,*/
/*test2
LocalID,Standard Identifier,Name,Country,Street,City,PostalCode,State,Website
1,RIC:AAPL.O|Ticker:AAPL,Apple,US,"Apple Campus, 1 Infinite Loop",Cupertino,95014,California,*/

Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Zhenya Kovalyov ♦♦ · Dec 05, 2017 at 06:58 AM 0
Share

you are free to explore the possibilities of the API with the use of PHP, for this I would recommend trying to mimic the post request that I have posted above with the tools that are available to you.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
9 People are following this question.

Related Questions

Record Matching API down?

Any bug or caching issue with this RIC: TEPRF.PA

Entity Search and Record Matching API limit of 5,000 reached: Request for extension

What is the rate limit for permid APIs?

Trying to use permid file match and receive error Failed to resolve API Key variable request.header.X-AG-Access-Token

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges