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:
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.
Best Answer
-
@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.
0
Answers
-
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?
0 -
@luis22 different databases and matching algorithms, I guess. If there is something missing in permid, you can raise it on the dedicated permid forum
0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 33 Data Model Discovery
- 682 Datastream
- 1.4K DSS
- 613 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 248 ETA
- 552 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.8K Refinitiv Data Platform
- 625 Refinitiv Data Platform Libraries
- 5 LSEG Due Diligence
- 1 LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 83 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛