Looking for all possible column headers for a script for Shipping Assets

jeremiemae.celajes

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

Eikon_API_Vessel_Info.pdf

Jirapongse

@jeremiemae.celajes

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

The sample code is also available on GitHub.

For more information regarding this search API, please refer to the following article.

• Building Search into your Application Workflow

jeremiemae.celajes

https://community.developers.refinitiv.com/discussion/comment/117729#Comment_117729

Thank you @Jirapongse

raksina.samasiri

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.