Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 0 0 1

Symbology conversion for vessel IMOs

Hi,

I have a list of vessels for which I have the IMO numbers (more than 20,000 vessels) and I would like to get the RICs for these vessels. There seems to be no data item for Vessel RIC and hence Eikon Get Data functionality wont be helpful. RDP search for Vessel Physical assets can be one option but I am not sure how to pass a list as a filter within the arguments. Is that possible? Or is there a way to use symbology conversion to convert the IMOs to RICs.

#technology#productcommoditiesrdp searchvessel
icon clock
10 |1500

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

Upvotes
Accepted
78.8k 250 52 74

@Sudharsan.Sarathy

You can use Refinitiv Data Library for Python.

IMO_List=['9619907', '7313652', '9131034']
filter_str = 'IMO in ('+' '.join(["'{}'".format(value) for value in IMO_List]) +')'
rd.discovery.search(
    view = rd.discovery.Views.SEARCH_ALL,
    top = 100,
    filter = filter_str,
    select = "IMO, RIC, AssetName"
)

The code above creates a filter string from a list of IMO. Then, it calls the rd.discovery.search method to get the result.

The output is:

1674464532754.png


1674464532754.png (30.0 KiB)
icon clock
10 |1500

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

This works perfectly fine. Thanks a lot.
Upvotes
5.7k 21 2 6

Hi @Sudharsan.Sarathy


I used the Map app to find a vessel:


1674139887206.png


And used its number as a ric in the DIB:


1674139658391.png


Is this the kind of info you're after? It shows all the fields available in the RD Library (for Python or other languages) (which is the newer version of the Eikon Data API Library) for that one RIC.


1674139658391.png (118.4 KiB)
1674139887206.png (132.6 KiB)
icon clock
10 |1500

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

The DIB was helpful to check for the RICs and I can see CF_NETCHNG provides the RIC when I pass an IMO. However when I try to use it in the get_data using rdp library I dont get any results. Currently not using the RD library.


1674461840598.png

1674461840598.png (7.7 KiB)
Upvote
78.8k 250 52 74

@Sudharsan.Sarathy

You can use the /discovery/search/v1/ endpoint to find RICs from IMOs.

The query can look like this:

{
  "View": "SearchAll",
  "Filter": "IMO in ('9619907' '7313652' '9131034')",
  "Select": "IMO, RIC, AssetName"
}

The output is:

1674191749743.png


1674191749743.png (36.6 KiB)
icon clock
10 |1500

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

Hi. This works well but the question is how can I pass say a list of IMOs in the filter argument. Currently you have provided a fixed set of vessels. I tried to use an f-string to pass the required list of IMOs but the search query returns null

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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