Record Matching API website support gives an error

vna
vna Newcomer
in Open PermID

Hello,

I'm trying to use the website feature through a python script using the REST API, and hitting a snag. It appears that there is a trailing \r after the data that messes up the JSON parsing:

URL='https://api.thomsonreuters.com/permid/match'

header={'Accept': 'application/json', 'Content-Type': 'text/plain', 'x-ag-access-token': 'xxx', 'x-openmatch-dataType': 'Organization', 'x-openmatch-numberOfMatchesPerRecord': 1}

data='LocalID,Standard Identifier,Name,Country,Street,City,PostalCode,State,Website \n ,,Apple,,,,,,http://www.apple.com'

Exception Traceback (most recent call last): File "/usr/lib/python2.7/site-packages/requests/models.py", line 819, in json return json.loads(self.text, **kwargs)

...File "/usr/lib/python2.7/site-packages/simplejson/decoder.py", line 400, in raw_decode return self.scan_once(s, idx=_w(s, idx).end())

JSONDecodeError: Invalid control character u'\r' at: line 1 column 692 (char 691)

Note: i am running python 2.7 and requests 2.7 in cygwin, on windows 10.

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @vna

    I found that the problem only happens when the request text contains the website information.


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

    ,,Apple,,,,,,www.apple.com


    The response will contain 0x0D after the "Input_Website" text.

    image

    However, if I removed the website information, the response is fine.

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

    ,,Apple,,,,,,

    The response is:

    {
      "ignore": "    ",
      "unMatched": 0,
      "matched": {
        "total": 1,
        "excellent": 1
      },
      "numReceivedRecords": 1,
      "numProcessedRecords": 1,
      "numErrorRecords": 0,
      "headersIdentifiedSuccessfully": [
        "localid",
        "standard identifier",
        "name",
        "country",
        "street",
        "city",
        "postalcode",
        "state",
        "website"
      ],
      "headersNotIdentified": [],
      "headersSupportedWereNotSent": [],
      "errorCode": 0,
      "errorCodeMessage": "Success",
      "resolvingTimeInMs": 238,
      "requestTimeInMs": 238,
      "outputContentResponse": [
        {
          "ProcessingStatus": "OK",
          "Match OpenPermID": "https://permid.org/1-4295905573",
          "Match OrgName": "Apple Inc",
          "Match Score": "92%",
          "Match Level": "Excellent",
          "Match Ordinal": "1",
          "Original Row Number": "2",
          "Input_Name": "Apple"
        }
      ]
    }

    Please confirm if it is the same problem that you found.

Answers

Categories