Looking for all possible column headers for a script for Shipping Assets
I am trying to find all the possible column headers for a script but there doesn't seem to be any help finding what are the possible filters.
Using Codebook and taking one of their examples on shipping and want to return a different set of columns on the dataframe but within codebook examples-> 06 - > Shipping, you find the two examples and within there there is a line of code for vesseks arrving at port, I want to return that dataframe but with my own choice of columns, problem is there is not a list of what column headers to pick from.
The default in this is this "select = "RIC, AssetName, Latitude, Longitude, OriginPort, DestinationPort, LocationDestination, LocationETA, LocationDraft, HullType"
The TR. Syntax doesn’t work for this code. For example, I do not care about HullType nor the Latitude or Longitude. I would be interested however in other details such as vessel sub type. Please find out what other attributes I can return.
We have available tools - attached PDF but none is working
Best Answer
-
Thank you for reaching out to us.
The TR fields don't work with the discovery.search endpoint.
You can list all fields in the search.Views.VESSEL_PHYSICAL_ASSETS by using the following code.
response = search.metadata.Definition(
view = search.Views.VESSEL_PHYSICAL_ASSETS
).get_data()
response.data.dfThe sample code is also available on GitHub.
For more information regarding this search API, please refer to the following article.
0
Answers
-
Thank you @Jirapongse0
-
Hi @jeremiemae.celajes ,
The code for search function can also be generated from Advanced Search application in Eikon or Workspace application, you can check this article on how to do so Find content and functionality using Refinitiv Data Library with Advanced Search
Below is the Advanced Search application, you can select Universe, Asset type. And filters can also be applied here
This is an example of the exported query as a python code
Hope this helps and please let me know in case you have any further questions.
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛