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

Find more posts tagged with

api

permid-api

intelligent-tagging-api

open-permid-api

record-matching-api

Accepted answers

Zhenya Kovalyov

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)

All comments

Zhenya Kovalyov

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)

parbat

@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,*/

Zhenya Kovalyov

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.

EXPLORE OUR SITES