For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 1 2 4

Using send_json_request in order to get company info.

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.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonjson
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
4.6k 26 7 22

@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.

icon clock
10 |1500

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

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?

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

Click below to post an Idea Post Idea