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

parbat
parbat Newcomer
in Open PermID

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

Tagged:

Best Answer

  • Zhenya Kovalyov
    Zhenya Kovalyov LSEG
    Answer ✓

    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)

Answers

  • parbat
    parbat Newcomer

    @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
    Zhenya Kovalyov LSEG
    https://community.developers.refinitiv.com/discussion/comment/21808#Comment_21808

    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.

Categories