I'd like to know if you can help us with an API with some information about vessels. To explain i...

...t better, the idea is to input the IMO number of an vessel and Refinitiv return us the fields below
Dear all, good day! I'd like to know if you can help us with an API with some information about vessels. To explain it better, the idea is to input the IMO number of an vessel and Refinitiv return us the fields below:
Name:
Vessel Type:
MMSI:
Call Sign:
Gross Tonnage:
NET Tonnage:
Summer DWT:
Length Overall:
Breadth Extreme:
Year Built:
Best Answer
-
Hello @daniela.sanches ,
Sharing the findings from case #11042734 that you probably have seen, for the benefit of dev community:
Name: TR.AssetName
Vessel Type: TR.AssetType
MMSI: TR.AssetMMSI
Call Sign: TR.AssetCallSign
Gross Tonnage: TR.GrossTonnage
NET Tonnage: TR.AssetNetTonnage
Summer DWT: Dead Weight Tonnage
We only have: TR.AssetDWT and TR.AssetPortMaxDWT
Length Overall: TR.AssetLOA
Breadth Extreme: TR.AssetBreadthExtreme
Year Built: TR.AssetMainEngineBYear0
Answers
-
Hello @daniela.sanches ,
In my understanding, the best approach would be to get one of the IMO numbers and to self-select the available information/fields to use in Python code, using Eikon CodeCreator tool, for example:
1. Selected Instruments = 'C}BS7309857750'
2. In Data Items selected 'vessel - that resulted in all available fields available for vessels
3. I selected 'Vessel Details' which was 39 fields and the 'Add all'.
4. Python code on the bottom was generated that can be used:
df, err = ek.get_data(
instruments = ['C}BS7309857750'],
fields = [
'TR.AssetExName',
'TR.AssetLOA',
'TR.AssetCubicCapacity',
'TR.AssetBuilt',
'TR.AssetBuiltDemolition',
'TR.AssetIsDeactivated',
'TR.AssetBallastWater',
'TR.AssetClassedBy1',
'TR.AssetClassedBy1DateChange,
...
'TR.AssetDischargeDate',
'TR.AssetCharterer'
]
)
display(df)Hope this information helps
0 -
You can combine a couple of APIs that will allow you to capture the necessary details requested. As @zoya faberov pointed out, you can use the CodeCreator tool to help identify some of these fields. I put together a simple Python function that combines a couple of our APIs that will allow you to request the details based on IMO. For example:
import refinitiv.dataplatform as rdp
from refinitiv.dataplatform import eikon as ek
...
def vessel_details(imo):
# Retrieve available details from Search based on IMO
response = rdp.Search.search(
view=rdp.SearchViews.VesselPhysicalAssets,
filter=f"IMO eq '{imo}'",
select="DTSubjectName, DTSimpleType, MMSI, GrossTonnage, DWT, \
VesselBuildYear, RIC"
)
if response.is_success:
ric = response.data.df['RIC'][0]
df,err = ek.get_data(ric, ['TR.AssetType','TR.AssetCallSign',
'TR.AssetNetTonnage','TR.AssetLOA',
'TR.AssetBeamExtreme'])
if err is None:
df.rename(columns={ 'Instrument': 'RIC' }, inplace = True)
result = df.merge(response.data.df, how='inner', on='RIC')
return result
return nullWith this in place, you can use the above as:
IMO = '9901984'
vessel_details(IMO)0 -
Dear all,
Are all the fields mentioned in my first question available in this API?
0 -
Hello @daniela.sanches ,
This forum can be of most help to you with questions about Refinitiv Eikon Data API Python usage.
Your question is now on mapping/pinpointing the required Refinitiv Eikon content, where Refinitiv content experts can help you best, and I have opened case #11042734 with Refinitiv content helpdesk on your behalf to help you map the requirements to fields.
Please await for the content experts to reach out via email.
Once you have Eikon Excel formula for the content that you require, we can be of help to you with Eikon Data API request(s).
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 687 Datastream
- 1.4K DSS
- 622 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
- 254 ETA
- 557 WebSocket API
- 38 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
- 276 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 678 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- 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
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 91 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛