Using send_json_request in order to get company info.

luis22 · December 2018

Hello,

I have a list of companies names which I have to collect some data, I order to be able to use get_data to collect that information I need to have the PermID of each company, Initially I was trying to use the permID API but I realised that not all the companies were there, but I could still find them on the Eikon web app. I realise that requesting the data via web (eikon) I could get the PermID to the orgs that doesn't appear on the permID API...

Example of route:

https://emea1.apps.cp.thomsonreuters.com/synapse/service/suggestions/suggest/?client=EikonNow&api-key=KEYHERE&expand=true&highlight=true&instantAnswer=true&profile=DefaultEikonNow&s=TRI.TO&st=RIC&query=A.B.F.%20PROPERTIES%20LIMITED

Response:

{
   "header":{
      "request":{
         "highlight":true,
         "st":"RIC",
         "expand":true,
         "userProfileAssetClass":"CSH",
         "s":"TRI.TO",
         "api-key":"KEYHERE",
         "eikon_version":"Eikon Web",
         "query":"A.B.F. PROPERTIES LIMITED",
         "profile":"DefaultEikonNow",
         "instantAnswer":true,
         "uuid":"GEDTC-101292"
      },
      "response":{
         "duration":71,
         "server":"c699gucaswb01.int.thomsonreuters.com",
         "num_results":1
      }
   },
   "result":[
      {
         "name":"Equities",
         "hits":[
            {
               "score":833339,
               "navigation":null,
               "id":"5060668396",
               "title":"ABF <b>Properties</b> Ltd",
               "subtitle":"Private Company - United Kingdom - Unlisted",
               "symbol":null,
               "cmd":"A.B.F. PROPERTIES LIMITED",
               "relations":{
                  "Apps & Tools":{
                     "name":"Apps & Tools",
                     "hits":[
                        {
                           "score":2982179,
                           "navigation":{
                              "action":"ABF Properties Ltd OV",
                              "name":"Internet Explorer Object",
                              "target":"replace",
                              "url":"cpurl://views.cp./Explorer/EVzCORPzPVTzOVNew.aspx?s=5060668396&st=OAPermID"
                           },
                           "id":"TabsForEVzCORPzPVTzOVNew",
                           "title":"Overview",
                           "subtitle":"Private Company Overview",
                           "symbol":"OV",
                           "cmd":"ABF Properties Ltd OV",
                           "relations":{
                           },
                           "position":0,
                           "explanation":null,
                           "source":"27",
                           "p":{
                              "InventoryId":"TabsForEVzCORPzPVTzOVNew"
                           },
                           "s":"5060668396",
                           "vc":"APP",
                           "fr":false,
                           "st":"OAPermID"
                        },
                        {
                           "score":2707200,
                           "navigation":{
                              "action":"ABF Properties Ltd RES",
                              "name":"Internet Explorer Object",
                              "target":"replace",
                              "url":"cpurl://apps.cp./Apps/privatecompany/?s=5060668396&st=OAPermID#/Apps/Research"
                           },
                           "id":"AutoSuggestForAPPxCORPxRESEARCH_OAPermID",
                           "title":"Company Research (NEW)",
                           "subtitle":"Comp Research",
                           "symbol":"RES",
                           "cmd":"ABF Properties Ltd RES",
                           "relations":{
                           },
                           "position":1,
                           "explanation":null,
                           "source":"27",
                           "p":{
                              "InventoryId":"AutoSuggestForAPPxCORPxRESEARCH_OAPermID"
                           },
                           "s":"5060668396",
                           "vc":"APP",
                           "fr":false,
                           "st":"OAPermID"
                        },
                        {
                           "score":2564775,
                           "navigation":{
                              "action":"ABF Properties Ltd EV",
                              "name":"Internet Explorer Object",
                              "target":"replace",
                              "url":"cpurl://views.cp./Explorer/EVzCORPxEVENTSzEVENTSzAPP.aspx?s=5060668396&st=OAPermID"
                           },
                           "id":"TabsForEVzCORPxEVENTSzEVENTSzAPP_OAPermID",
                           "title":"Corporate Events",
                           "subtitle":"Corporate Events",
                           "symbol":"EV",
                           "cmd":"ABF Properties Ltd EV",
                           "relations":{
                           },
                           "position":2,
                           "explanation":null,
                           "source":"27",
                           "p":{
                              "InventoryId":"TabsForEVzCORPxEVENTSzEVENTSzAPP_OAPermID"
                           },
                           "s":"5060668396",
                           "vc":"APP",
                           "fr":false,
                           "st":"OAPermID"
                        },
                        {
                           "score":2400005,
                           "navigation":{
                              "action":"ABF Properties Ltd CN",
                              "name":"Internet Explorer Object",
                              "target":"replace",
                              "url":"cpurl://views.cp./Explorer/EVzCORPxRESNEWSzNEWS.aspx?s=5060668396&st=OAPermID"
                           },
                           "id":"TabsForEVzCORPxRESNEWSzNEWS_PrivateOAPermID",
                           "title":"News",
                           "subtitle":"News",
                           "symbol":"CN",
                           "cmd":"ABF Properties Ltd CN",
                           "relations":{
                           },
                           "position":3,
                           "explanation":null,
                           "source":"27",
                           "p":{
                              "InventoryId":"TabsForEVzCORPxRESNEWSzNEWS_PrivateOAPermID"
                           },
                           "s":"5060668396",
                           "vc":"APP",
                           "fr":false,
                           "st":"OAPermID"
                        },
                        {
                           "score":2400005,
                           "navigation":{
                              "action":"ABF Properties Ltd CDV",
                              "name":"Internet Explorer Object",
                              "target":"replace",
                              "url":"cpurl://views.cp./Explorer/EVzCORPxCDVzAPP.aspx?s=5060668396&st=OAPermID"
                           },
                           "id":"TabsForEVzCORPxCDVzAPP_OACompanies",
                           "title":"Company Deals",
                           "subtitle":"Company Transactions",
                           "symbol":"CDV",
                           "cmd":"ABF Properties Ltd CDV",
                           "relations":{
                           },
                           "position":4,
                           "explanation":null,
                           "source":"27",
                           "p":{
                              "InventoryId":"TabsForEVzCORPxCDVzAPP_OACompanies"
                           },
                           "s":"5060668396",
                           "vc":"APP",
                           "fr":false,
                           "st":"OAPermID"
                        }
                     ],
                     "hasMore":true,
                     "default":false,
                     "size":5,
                     "moreLink":"cpurl://apps.cp./apps/SearchAll?Search.Value=a.b.f.+properties+limited*"
                  }
               },
               "position":0,
               "explanation":null,
               "source":"4",
               "p":{
                  "OAPermID":"5060668396"
               },
               "s":"5060668396",
               "vc":"CMP",
               "fr":false,
               "st":"OAPermID"
            }
         ],
         "hasMore":false,
         "default":true,
         "size":1
      }
   ],
   "action":"\"A.B.F. PROPERTIES LIMITED\" Search",
   "search":"cpurl://apps.cp./apps/SearchAll?Search.Value=a.b.f.+properties+limited*"
}

So I am trying to figure out how to replicate this request from the Eikon Data API. I believe I should use send_json_request for this one but there's no documentation about this function in your docs. It requires me to define which service I need on the params but I can't find which one I should use for this.

Thanks in advance.

Zhenya Kovalyov · December 2018

@luis22 there is no search api that you can currently use as a part of Eikon Data API, and I would not recommend tapping into the internal apis.

If those companies are public, you can use Eikon Excel (RSearch function) to try and match them.

luis22 · December 2018

Thanks for your reply. Is there any specific reason of why we don't get the same results from the PermID API and Eikon web?

Zhenya Kovalyov · December 2018

@luis22 different databases and matching algorithms, I guess. If there is something missing in permid, you can raise it on the dedicated permid forum

Using send_json_request in order to get company info.

Best Answer

Answers

Categories